Thanks for the reply John.

It was an issue with the concurrent connections.

The person who owns the server had set the value to 1.

It has been reset to Zero using...

This is what we did it the end to achieve the solution:

declare @STR varchar(50),@z varchar(10),@y int

set @STR = ','+(select VAL from TEST1 where ID ='3') +...

Thanks a lot!!!

I'll try this and let you know....

Thanks..

Thanks Mahesh!!!

But, how do I convert it into columns?

Hi,

Try this...

Select A.Eno,Datepart(Month,JoinDate),Datepart(Year,JoinDate),count(*)

From Emp1 A

Left Outer Join Dept B on A.DeptNo = B.DeptNo

where A.Eno = '101'

GROUP BY A.Eno,Datepart(Month,JoinDate),Datepart(Year,JoinDate)