Ramco Ramco

Ramco Ramco

  • 419
  • 3.4k
  • 528k

Query to display data like below

May 15 2022 4:30 PM

Hi i have below data & i want to display like below. I want to concat Item for a particular day.

Id	Code	Date	Value	
1	1	01/10/2022	5000	
2	1	02/10/2022	1000	
3	2	04/10/2022	10000	
				
				
Code	ItemCode	Date	Qty	
1	I1	01/10/2022	4	
1	I2	01/10/2022	2	
1	I1	02/10/2022	4	
2	I3	04/10/2022	20	
				
Code	ItemCode	Date		
1	I1	01/10/2022	1	
				
Output like below
				
	1	01/10/2022	I1-3,I2-2	5000
		02/10/2022	I1-4	1000
				
	2	04/10/2022	I3-20	10000

Thanks


Answers (1)