Martin,

First of all Thank you for really good article with perfect example to show the functionality. I fully support your approch of stored functions/stored procedures to generate the result...

Yes, Category said it all....:hehe:

Good one

Thanks for awarding....Steve:)

It was really logical (Oracle,MySQL,Access logically out) + guess between (MSSQL 2K and 2K5)...

and My guess paid me 5 point reward 😀

As ncprBill8 asked, I also curious to know if...

I also join the club about how to find row count from _columns SP....:hehe:

May be QoD auther has used following cursor

DECLARE abc CURSOR KEYSET FOR

SELECT GetDate() [Today]

And this will...

Second Eye always work in this situation.

I agreed with Mark...Question was not to test ENGLISH it was to test the BETWEEN (T-SQL context).....:hehe:

Using for each loop it one of the best way to go through filename.

But I am just curious about using connection in script.

did you use the servername.ConnectionName?

I think you should have column names in you Excel file to map the column while exporting.

I totally missed Last Union but Count(ColumnName) saved my 2 points:hehe:. Gr8 to have this kind of questions. As it clears/remind the small differences between similar options.

Thanks...It was fun...:)

Cant you pass "," from VS to Report?

I would like to add one point about Identity column is that You can Re-use the deleted number by inserting Explicit values using

SET IDENTITY_INSERT [ database. [ owner. ]...

Good informative question...This will at least make people to read whole question before replying and commenting......:)

use "Page Break At End"