Hello all,
If I have a table with iownerid and dtassigned for a number of users (say 1.5 million records) and I want to pull a report with their initial record (this is a customer table with purchase data), then I would like to pull their second purchase date with number of items and then third purchase date. This data is all on a SQL 2000 box, but I do have box running 2005 so I could do this with SSRS, but I have not really used SSRS before. Any help or hints for the query would be greatly appreciated.
wb
If I have a table with iownerid and dtassigned for a number of users (say 1.5 million records) and I want to pull a report with their initial record (this is a customer table with purchase data), then I would like to pull their second purchase date with number of items and then third purchase date. This data is all on a SQL 2000 box, but I do have box running 2005 so I could do this with SSRS, but I have not really used SSRS before. Any help or hints for the query would be greatly appreciated.
wb