Pls try this

With SLNo

AS

(

SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY object_id ) Id from sys.objects )

Select ID from SLNo

Try this

1. Create a temp table contains required column in FactETMPositionRequests and ETMMessage Table. Filter should be

MW.MessageTimeStamp between convert(date, '06/05/2012 12:13:59',103) and convert (date,'08/05/2012 00:00:00',103) and

...

try this

select DISTINCT Field1,

STUFF

(

(

SELECT ','...

Try

Where PortfolioBaseCode = Replace(@Portfolios,'@','')

riya_dave (4/25/2012)

i am using replace function.

giving me error like 'Error converting data type nvarchar to float'

reportheading1 is nvarchar(72)

select ReportHeading1 From vPortfolioBase

Where PortfolioBaseCode =...

Try

Where PortfolioBaseCode = Replace(@Portfolios,'@','')