Click here to Skip to main content
11,642,216 members (66,049 online)

anil_kumar_bhakta asked:

Open original thread
Hi Experts,

I have some data like below in SQL Server Table 'tblLeave': -

PAYCODE	LV_TYPE	FROM_DATE	TO_DATE	        LVALUE
5023	SL    	14/12/2012 0:00	14/12/2012 0:00	1
5023	SL    	15/12/2012 0:00	15/12/2012 0:00	1
5023	COF   	16/12/2012 0:00	16/12/2012 0:00	1
5023	SL    	19/12/2012 0:00	19/12/2012 0:00	1
5023	SL    	22/12/2012 0:00	22/12/2012 0:00	1
5023	SL    	23/12/2012 0:00	23/12/2012 0:00	1
5023	SL    	24/12/2012 0:00	24/12/2012 0:00	1
5023	PL    	28/12/2012 0:00	28/12/2012 0:00	1
5023	PL    	29/12/2012 0:00	29/12/2012 0:00	1
5023	PL    	30/12/2012 0:00	30/12/2012 0:00	1
5023	PL    	31/12/2012 0:00	31/12/2012 0:00	1

Query result must be as below: -

PAYCODE LV_TYPE FROM_DATE       TO_DATE         LVALUE
5023    SL      14/12/2012 0:00 15/12/2012 0:00 2
5023    COF     16/12/2012 0:00 16/12/2012 0:00 1
5023    SL      19/12/2012 0:00 19/12/2012 0:00 1
5023    SL      22/12/2012 0:00 24/12/2012 0:00 3
5023    PL      28/12/2012 0:00 31/12/2012 0:00 4

If same type of leave taken continously,it shoul be merged in one row mentioning from_date to to_date.

Please help me.

Thanks,

Anil Kumar

[edit]Code block added - OriginalGriff[/edit]
Tags: SQL-Server-2008

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).



Advertise | Privacy | Mobile
Web02 | 2.8.150731.1 | Last Updated 26 Mar 2009
Copyright © CodeProject, 1999-2015
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