I've been using VB6 for many years and moved over to .NET about 3 or so years ago. I mostly program in VB.NET but on occasion tinker with C#. The...

Well after looking at some of the query plans there seems to be lots of table scans going plus one table in particular is about 8GB in size and is...

I've just tried this on a SQL 6.5 DB and it produces the same result so this must go way back! How cool! 😀

Thanks for the reply's

I've done bit more research into Open XML for Office 2007 and released that I should probably using SQL to return data as xml and handle the...

Sorry everyone posted above to wrong forum.... see http://www.sqlservercentral.com/Forums/Topic721917-391-1.aspx