Many thanks

Ram

I've finally sorted it out by writing the stored procedure as given below:

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

DECLARE @Counter...

Dear All,

That's simply great! works charmly...

Many Many thanks for your valuable help!

Regards,

Ram

Hi Craig,

Print @columns results:

[2013-01-05],[2013-01-12],[2013-01-19],[2013-01-26]

Print @convert results:

select * from (select * from UserProductivityMapping) wk.WeekStartDate

pivot(sum(PercentageProductivity) for wk.WeekStartDate

in ([2013-01-05],[2013-01-12],[2013-01-19],[2013-01-26])) as pivottable

Thanks and regards,

Ram

Hi Drew,

Please find the attached .xlsx file for your reference contains the table structure and also the expected output which may be useful for you to understand the requirement.

Many thanks,

Ram