I have a script for this at the office. If I forget to post by 11:00 am cst, drop me an email.

John

my bad. vbscript not tsql.

Space(850) still works in vbscript.

Replace(character, number) becomes

Space(Number, character).

left zero pad:

set @s-2 = replicate('0', @desiredlengh - len(@s)) + @s-2

Space(850) works too.

Final solution!

Our network support guys couldn't get the drive letter to work for the account sql logs in as. I used vb script called from a job to create...

Host Integration Server is M$'s .NET bridge server. It allows you to do cool stuff like map an NT login or group to an AS400 login and manage permissions...

Brian,

Give me my 100K and I walk away with a smile on my face!

First off, please get in the habit of formatting your code in such a way that it's easier for you to see what is going on. Start small and...

Anteres,

Your method works, but forces a table scan. I tried it out and it's S L O W. 7 seconds vs under 1 second executing a SQL String...

Luis,

Try this on for size:

select

aramazem,

article,

sum(quant),

sum(total)

from

(select

case when ARMAZEM=1 THEN 'FEIRA'

WHEN ARMAZEM=2 THEN 'PINHEL'

...

I was just about to flame the "cache a recordset in MTS" idea until I read where you took it. Keep the middle tier simple and stateless! Saving the...

Here's a question. When offering a service such as SQL Server hosting, at what point does the lack of preparedness for disaster recovery become negligent? I believe a...

Hmmmm Nope. Don't think so.

Antares,

I spoke with a tech support guy. They actually back up the sql boxes nightly. One thing concerned me - they back up all their sql machines to...

How many dimensions are your users crossjoining? Can you post some sample MDX?