wow this script has come a long way since the original version; thanks again to everyone who has contributed;

I cleaned up the formatting a little bit and added some comments,...

there is an additional caveat with that; when the driver scans the source for the rules on IMEX=1, it looks at the first 8 rows to decide the data size...so...

i believe this is a well known issue i'd seen with importing/exporting to excel or text files via the jet data providers. To overcome, you have to set the...

do you have a userId/name that is inherited fromt eh page you can use as a parameter? then you can order the data:

ORDER BY

CASE

WHEN SomeTable.AnalystID =...

i think the domain account needs to have launched excel at least once manually on the server itself, right?

the first time excel launches for a user, if there are not...

On a related note, I think this is how to check my current databases to see if any are owned by anyone other than sa, correct? so this doesn't occur...

i have this saved in my snippets on how to map a drive from xp_cmdshell:

exec master.dbo.xp_cmshell 'NET USE G: \\UNCPath\d$ /user:domain\user password'

GO

RESTORE Database DBName FROM Disk = 'G:\PAth to bak'

GO

EXEC...

Lynn on my roughly half a million row table i created with the data below, i get roughly double the performance with ITV vs scalar;16 seconds vs 9 seconds.

from...

my crappy pseudo code construction was off for the case statement Sean; i meant show what this example does: chop up a single field into 3 seperate fields wit the...

is there an index on the [qm_entry_dt] column on table [tblQuoteMain]?

my knee jerk reaction is to use a table value function to get whatever data you need;

for now lets see if a slightly different scalar function will work.

first thing i'd...

well lets start with the basics; are you sure you are connecting at all? can you select @@version from vb?

could you be connecting to MASTER, adn thinking you'll see tables...

Lynn Pettis (3/16/2011)

---

Your project, okay. I could provide you with code, but I'm not going to bother.

What you need is a delimited string parse function. Do a search...

great question.

this book references says that some additional logging information is stored inside the page, and as a result, that makes the max size 8060:

http://books.google.com/books?id=G2YqBS9CQ0AC&pg=PA964&lpg=PA964&dq=8060,+but+it+is+8096&source=bl&ots=ZvMVDjIUaL&sig=3HWawbxnTZqAmVYsPmcNyCSVoxY&hl=en&ei=NhKATdffOPKL0QH3_pn5CA&sa=X&oi=book_result&ct=result&resnum=1&ved=0CBUQ6AEwAA#v=onepage&q=8060%2C%20but%20it%20is%208096&f=false

i just tried to run the code in a database that is set at compatibility level 80 and it fails with that syntax check; in 90 or 100 it goes...