Can you please help me with that code?

Actually, we can’t do it as the whole datamart is in 2000. So its not possible to do it. For doing that we must have approval from Business Management.

No, because this sp will be connected to crystal reports for creating report.

I figured out why, We are using the SQL server 2005 but the datamart is in SQL server 2000.

So that’s why its giving me error when im running.

yes i'm using sql server 2005

Its giving me Row_number() is not a recognized function name.

The maximum will be 50 I guess. I need this to use in my report. Anyway thanks so much for what you are doing.

Hi RbarryYoung,

Thanks for your help but i have a problem...