I was about to go the long way by using identity(smallint,1,1) as RowNmbr and then pick the min or max by RowNmbr. I didn't realize I can use min...

Thank you for your response. Here is my task:

I'm passing the date parameters into a stored proc. When the users run the report, they provide the date range....

Mike,

Thank you for your inputs. I'll definitely try the steps again. I'm thinking that it is the permission issue. I just don't know enough to resolve it....

Hi Mike,

Thanks for the link. I follow the instruction and still do not see anything other than the HOME area where I can not do anything...I did see on...

Yes. the only option work when connecting to Reporting Service in SQL Server Management Studio is Windows Authentication. Any idea? Thanks

Thank you for your response.  How and where do I grant the permission you mention to the Crystal user?  As I mention in the original post, Crystal is a user...

Hello All,

I'm facing a similar situation. However, the value of every single column in my table are identical to the original row. for example:

rec   last   first   email  

1     Doe   John  ...

Thank you all for your input/suggestion.

Osoba,

I'm not ranking on any value so your solution worked perfect!!! Thanks so much!!!

Thank you all your help/input.  My project is much more complicate than what I have posted.  There are many computations involved within the dts package to arrive to various total...

thanks for your response.  i'm awared that i have to use activex script task in order to accomplish this.  but how?  any example? thanks

Thank you all for your input/suggestion. 

Thanks for your respond.  But don't you need to add a linked server to the production environment in order to pull the data from the processing environment over?

Thank you all for your help/suggestion. 

MrSQL, i create test table and apply your code it work perfectly.  I'll have to do further testing and will report my finding.  i...

Jonathan, that works great!!!Thank you so much...

I also add an important criteria to the where clause

tbl_a.key_id = tbl_b.key_id.

my WHERE clause now look like this:

tbl_a.key_id = tbl_b.key_id

and tbl_a.column5 = tbl_b.column5

and tbl_a.column6...

Thanks for your reply.  can you pls provide detail steps how i can accomplish this.  i'm not a sql dba and have not done this task.