There is nothing that special about writing stored procedures. When it comes to the crunch they are basically just a bunch of T-SQL commands that are executed together.

From Books...

Ok, borrowing substantially from Learn2Live's post on the other message thread, see if this works. You can copy the whole lot into Query Analyzer as is and test it out....

Is this related to http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=217491 ?

I'm thinking it would be best done in a stored procedure. Can you provide a table structure for us to work with?

Have you applied SP1 & SP2 to Reporting Services? If not then the report is not being exported to native Excel format. Apply the service packs and try again.

If you...

If you're storing PDF, DOC and PPT files in the database, then they'll be stored as BLOBs. You'll need to either get a third party tool (or write on yourself)...

So what is the result for

SELECT #tmp.*
FROM #Tmp
ORDER BY AvgRating desc, NumRatings desc, Name asc

Just to be clear myself.

When it comes to storing files in a database as blobs, I advocate that if the item does not change as part of regular database transactional...

Maybe it's just because it's Friday evening here ... but I'm confused

Why would you be doing this in VBScript ?? Why not use a plain and simple Datapump from the Excel spreadsheet into the table?

Prior to the datapump, or even in...

Does the temp table you're inserting into have an index on it? When you're selecting the records from the temp table, are you using an ORDER BY.

Any chance of posting...

I agree with Chris.

I'd seriously be looking at why you're storing a supposedly unchanging file in a database where you'll have to constantly perform maintenance and backups.

Stored on a...

"security control is maintained in user tables"

Are you talking about SQL Security here, or is this application security?

Anything I can think would out of necessity require the use...

Care to explain your requirement for this and why you need a function to do it?

CREATE procedure dbo.usp_select
    @tbl sysname
AS
BEGIN
    DECLARE @SQL nvarchar(100)
    SET @SQL = 'SELECT * FROM...

Check the workflow properties of the datapump task that writes to the Excel file. Make sure 'Close Connection on Completion' is selected.

Is this VBScript, or part of a compiled VB program?

You should be able to handle errors like this pretty easily using workflow within the package. Also, make sure that 'Fail...