Why would you not want to use the built-in mailing capabilities of SQL Server? You have not posted this in an appropriate forum so I don't know what version...

I think Ken is on the right track, in that we need to know how the OrderId is contructed.

My understanding is that you can install the tools as often as you like as long as you have a SQL Server license. You would need a CAL to...

Please check the links in my signature line for how to post a more complete question.

You do not define why you need to loop and what constitutes the first row.

tablediff.exe is a good idea. I always forget about it. That will just sync data. If you want to sync schemas one of the third-party tools is...

Can you post the format you rendering the link as?

You could get a SQL Data Comparison product like RedGate SQLDataCompare or ApexSQL's product.

Grant Fritchey (1/13/2009)

---

Jack Corbett (1/13/2009)

---

Where I am at right now, part-time contract for 2 more weeks, there is one "minor" system on 2005, the rest are 2000 except for the...

Grant Fritchey (1/13/2009)

---

Jeff Moden (1/13/2009)

---

True enough, 2000 is out of support... now, tell me it's out of use. Hmmm... that would make a good survey question... I'll think there's...

I don't think that there is a way to do this natively in SSRS.

Of course these means that CTE's are out as well...

I don'[t understand what you mean about it not being an elegant solution. It does what you desire, it limits round trips, and it takes advantage of the abilities...

Okay, here's how I'd do it. I use one dataset, which I think you need to do in order to do it anyway. It also reduces the roundtrips...

gcopeland (1/12/2009)

---

Thus, as a business executive, I would never hire an HR person who judges by appearance. HR is one of the gatekeepers of the business, their job (amongst...

This is the same question asked here: http://www.sqlservercentral.com/Forums/Topic634092-361-1.aspx and there are answers in both posts. Please don't post in 2 forums as that just fragments responses.