Hi Farlzy,

     Thank you for your Reply. But the query o/p has slightly differed from my requirement. If the server is present on the weekly report ( It is...

Thanks, Steve/Jeff

Please find the attached excel. we used to get data in this format.This column to row conversion of the specific columns is required in my report. I...

Thanks for your valuable suggestion.

I am using MS SQL Server Management Studio, but i am unable to implement the suggested solution in the existing procedure, would it be possible...

Still i failed to get desire result.

/*

The following example displays the current date and time, uses CAST to change the current date and time to a character data type,...

Thank you Eirikur Eiriksson/ HanShi

I got your point. is there any way to raise an exception ,if the given input parameter format is not DDMONYYYY.

Torrid.