Sorry. Yes I was giving a direction for problem resolution.

To dynamically name a file you will use dynamic SQL. Dynamic SQL allows you to Dynamically write SQL code; within your...

Dynamic SQl

Jeff,

Thank you for the suggestion. You know I think I will do that. I need to clean up the code in that case. This project was a bit of a...

Thanks. I got 7Zip working. The solution works perfectly for unzipping and I will use it to ZIP an XLS document that I generate after working with the Unzipped...

I found a script that actually works. Works as in it gets the table data into Excel. NOW I need to midify it as it is designed to get...

I have been stuck on this unzip thing for a while now. Because you have had some success with 7Zip (Never heard of it until now) I downloaded it. I...

You need to be sure that you don't return a NULL value... Try this

SELECT td = coalesce(Name, 'No Name Returned'),'',td = coalesce(Address, 'No Address Returned'), '',td = '<a href="' +...

Now I have the worst situation I think I could have with this process. I downloaded a freeware unzip utility and with command line the attched works just fine....

Good idea, I will try that and update.

Thanks.

Thank you.. Perfect.

You don't have a sample of your table here really so I will give you a sample.

-- Top 5 highest scores

SELECT TOP 5 GameNo, Score, Name, GameDate

FROM Games

WHERE GameNo...

LOL Awesome code regardless...

Both of these are in my toolbox. Great stuff!

Yeah it was really quick. Thanks a TON... I don't think I could have pulled it off.

From 4.5 hours to get through HALF the records to 13 seconds to process the entire job.

The new code is working well. Need to make changes to include some additional code I need for my purpose.