any solution for this question | SQL Server

forum.venkateswarlu.net

any solution for this question

Prasannaa Gurasekeran #1
Member 14 Points	Posted on 17 Jul 2014 01:24 PM IST Table1 Table2 PID ProductDesc ProductCode Date PID 1 Packet-Eye P001 1/14/2009 1 2 Wiggy W099 1/15/2009 1 3 Wimax-Lite W001 2/1/2009 2 4 Wimax-Home W002 3/3/2009 3 … … … … … … … … … … The table1 contains 20 rows and the table2 contains 800,000 rows. Output 1 ------------ Registration Date Product Description 1-Jan-09 Wimax-Lite 12-Jan-09 Wimax-Lite 14-Feb-09 Wimax-Home 3-Mar-09 Packet-Eye … … … … Query2 Output 2 Product Jan 2009 Feb 2009 Mar 2009 Apr 2009 May 2009 Jun 2009 Jul 2009 Packet-Eye 45 67 23 54 12 44 6 Wiggy 0 0 0 20 600 788 1000 Wimax-Lite 300 100 150 110 150 200 400 Wimax-Home 200 300 500 300 400 400 500 … … … … … … … … … … … … … … … … Using Table1 and Table2, construct 2 separate SQL scripts to derive the output illustrated by Output 1 and Output 2.
	SQL Server 1011 views Reply to this topic

		Jahnavi N 164 Points
		Subramaniam R 152 Points
		Kalyan Suman 150 Points
		Cherukuri Venkateswarlu 140 Points
		Harikrishna Sikhakolli 108 Points
		Aisha Bobby 96 Points
		Gaurav Dutt 62 Points
		Saravanan Ramamoorhty 58 Points
		MalliKarjuna Cherukuri 52 Points
		Etuuj Dgg 48 Points