That works. Thanks a lot Dan.

Hi David,

Thanks for the reply. I have SSRS 2008 not R2. We are migrating from 2008 to R2 and have a problem with few reports with data driven subscriptions.

You...

Hi MC,

Try this

With ct

as

(

select UserID,PackageID,DateCreated,Row_number()Over(partition by UserID order by UserID)as RN from test

) ,

WITH ct2 AS (

...

Hi Jeff, Thanks for the reply. It worked well.