Please post that script here, alongside some sample data pls. I'm at wits end to understand what you're looking for given the sample data you provided earlier.

Thanks for the reply,Yes i understand truncate and insert would be simple way to do this but i want to minimize the number of inserts / deletes by rather using...

Is the code being updated from UI then you go for updating the values through SP or use triggers

ws-581925 (3/21/2011)

---

SELECT STUFF((

SELECT ',' + rtrim([StatusDesc])

...

Awesome seems to work fine on my Samsung

Hi

Great effort in getting out this procedure but what about decimal(p,s) that doesn't seem to reflect either.

declare @startDate datetime

set @startDate = '2009-01-01 00:00:00.000'

declare @endDate datetime

set @endDate = '2009-12-31 00:00:00.000'

declare @feeEarner varchar(3)

set @feeEarner = ''

declare @WipCode varchar(5)

set @WipCode = ''

declare @AcCode varchar(8)

set @AcCode = ''

declare @Country varchar(2)

set...