Never mind i framed the query myself. Thanks anyway

Hi ,Thanks fot your reply.i have addded some sample data. I need to research on dynamic crosstabs if this is not possible

I just want to add one more condition i.e...

Hi,I have updated the code to get more clarity on this request.

Thanks

Sure.I understand. I am sorry abt that. Thanks!

Thank you very much for the script and your thoughts.:-).The script works fine.However I will check if i can work on the front end rather than in back end.

Thanks...

Yes my management needs to know how long the SQL server is down for a year/month.

So we need to find out the total uptime and total downtime of the server.