Hey try this one.

Declare @No varchar(100)

Set @No =''

select @No = @No + case when @No = '' then '' else ',' end + X

from @T

Select @No

Any help would be appreciated !

I already read about PRODUCT. It is used to multiply numbers or range of numbers.

http://spreadsheets.about.com/od/excelfunctions/qt/product_funtion.htm

But how to implement it in SQL ?

Thats why i used SUM function.

PRODUCT is an excel function. I want to implement it in SQL.

Any helps ?

Yes.

I suggest you look into BOL and try it out yourself. then if you have doubts ask...

Sorry a little late here.

Thanks a lot Ryan,Chris and Arjun ! I really appreciate your's help !

Any inputs ?

Thanks Andras !

Is there any other way to do this ?

Kindly let me know !

PROD data is replicated to DEV environment.

I want to ensure the replication status. i.e Success or done with some changes.

Inputs are highly appreciable !

Please post table structure with some sample records.

I suggest you to read the below article.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Andras,

You mean we need to use TRUNCATE if we dont...

Mark,

you are right. But OP mentioned like

Thats why i preferred TRUNCATE.

TRUNCATE may help for your need.

You have to frame your question better. Also please post your requirement clearly.