Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server-2008
From_Month	From_Year	From_Date       To_Date	   From_Month_Desc
1	         2011	         3-Jan-11	31-Jan-11	Jan
2	         2011	         1-Feb-11	28-Feb-11	Feb
3	         2011	         1-Mar-11	31-Mar-11	Mar
4	         2011	         1-Apr-11	30-Apr-11	Apr
5	         2011	         1-May-11	31-May-11	May
6	         2011	         1-Jun-11	30-Jun-11	Jun
7	         2011	         1-Jul-11	31-Jul-11	Jul
8	         2011	         1-Aug-11	31-Aug-11	Aug
9	         2011	         1-Sep-11	30-Sep-11	Sep
10	         2011	         1-Oct-11	31-Oct-11	Oct
11	         2011	         1-Nov-11	30-Nov-11	Nov
12	         2011	         1-Dec-11	31-Dec-11	Dec
1	         2012	         1-Jan-12	31-Jan-12	Jan
2	         2012	         1-Feb-12	29-Feb-12	Feb
3	         2012	         1-Mar-12	31-Mar-12	Mar
4	         2012	         1-Apr-12	30-Apr-12	Apr
5	         2012	         1-May-12	31-May-12	May
6	         2012	         1-Jun-12	30-Jun-12	Jun
 
This is my Proj Start Date & End Date details result set....
 
Fun_Code	Short_Desc	Fun_Desc	Plan_Month	Plan_Year	 Date_	   Qty
41849	           2	       STOCK HOUSE	        1	2011	        Jan-11	   25
41852	           2	       SH DEDUSTING	        1	2011	        Jan-11	   30
41853	           3	       HOT STOVE	        1	2011	        Jan-11	   32
41853	           3	       HOT STOVE	        2	2011	        Feb-11	   50
41849	           2	       STOCK HOUSE	        6	2012	        Jun-12	   200
 
 
This is my Qty result set,
 
every month we planned some material quantities...
 
now what i want is each and every material i want to display the total proj months if any month i enter qty , that col alone to display that details...
 
I want to merge that 2 result sets...
 

 
How to do this
Posted 29-Mar-13 20:20pm
N@veen.S1.6K
Comments
Kuthuparakkal at 30-Mar-13 1:50am
   
unclear
S. M. Ahasan Habib at 30-Mar-13 2:17am
   
Based on both record set what will be the final result set? Based on what criteria you want that? Please clarify that. Without that your question will be unclear to us.
Maciej Los at 30-Mar-13 14:20pm
   
Please, be more specific and provide more details (about table structure).

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 304
1 Sergey Alexandrovich Kryukov 255
2 Shweta N Mishra 216
3 Maciej Los 210
4 PIEBALDconsult 184
0 OriginalGriff 7,630
1 Sergey Alexandrovich Kryukov 7,022
2 DamithSL 5,586
3 Manas Bhardwaj 4,946
4 Maciej Los 4,525


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 30 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100