Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 sql:Attendance

Author  Topic 

sreekanth939
Starting Member

12 Posts

Posted - 2009-04-24 : 02:40:03
i have a table:ABC
id date name attendance
1 1/1/2009 a 1
2 1/1/2009 b 0
3 2/1/2009 a 0
4 2/1/2009 b 1
here attendance 1 for present 0 for absent

i need thedetails of attendance as following when one istaking report of ABC

eg:data between 1/1/2009 and 2/1/2009

name,1/1/2009 2/2/2009
a present leave
b leave present

i done this throug following sql query using case
but my table is not small.
and it take long time to get the result.
beacause in my case when one take reprt of 1/1/2009 to 30/1/2009
i must have to put condition in a loop with case.
and my query take long long time top execute..
Any other method to sole this time delay?
plsssssssssssssss

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-07 : 02:07:24
You can use the PIVOT method to get your results.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -