Hello Gail!

Thanks a lot again. Definitely going to get one.

You have any book recommendation or any tips to follow on?

🙂 RMudugal

Hello Gail

Thanks a lot.

I just gone through the link... in the "skill measured" tab.. is all that can be achieved by learning through the sql 2k5 express edition or with...

Hi Sri;

From the EmpID = 1 it tells that the startdate is the min of all and the enddate us the max of all, is that it?

just inner join that...

Hi;

From the query what you have posted, the SQL is doing a great job in fetching the data to this level. If you look in to the data what the...

Hi If you want the output in the pivot format itself in the database, then its kinda difficult... but if you can create pivot report in the Excel then populating...

Hi

Not any much of help... but the below link, is on the same wave.

http://www.sqlservercentral.com/Forums/Topic866779-392-1.aspx

and in between

the example was given to me by "Dave Ballantyne" might help you... its good.

http://www.sqlprof.com/blogs/sqldev/archive/2008/04/12/pivots-with-dynamic-columns-in-sql-server-2005-2008.aspx

-r...

Hi

Actually the script is a SQL batch, i execute it and copy the output to the Excel and create pivot table.

But if you convert this batch to SP, then you...

The front-end is a 3rd party app basically used for logging incidents and a lot more, and it has its own database in 2k5. I don't think SSRS is installed...

Sorry Dave, just to make it clear to myself....

from the link you mentioned, (currently I am focusing on the first example), there he has shown the month in vertical manner...

Hi, the attached excel file is the format, hope that can be achieved by using pivot in sql2k8 and below sql script fills the table variable with dates, which only...

Hi, thanks for the reply

I have seen that.... not much help from that. I am not sure how you take time out of the date and create a pivot and...