This should do it...

UPDATE Grade

SET Grade_Name = CASE

WHEN Grade_ID = '35800'

THEN 'TRANSCOPY' + CHAR(153) --™

...

Not trying to be a smart guy here...

What did you learn by this?

Jpotucek (11/28/2007)

---

trying to come up with a few commands that I can use to query my SQL Server 2000 Instances and Document my Databases - preferably Excel

exec sp_helpdb comes...

That's easy... it would be the person with the most to loose if the design is bad 😉 That's the only way someone will be interested enough in doing...

Doug Stoltz (11/28/2007)

---

Jeff, I've got a couple more questions for you:

1) I belive my earlier statement about the 2 web users sharing the same connection are correct, but I believe...

oh, be careful with IDENT_Current... lot's of folks can insert rows in that very brief time span between the time you do an insert and the time you use IDENT_Current.

Sorry about the EM thing... still trying to flatten out a crease in my brain with coffee...

If you set the scripting options correctly in Query Analyzer, you can generate such...

Heh... ammo is one thing... learning how to shoot it straight may be another. My advice is to play with the code I gave you......

Heh... "Quadrillion"...

Mill = 1

Bill (or BI) = 2

Tri = 3

Quad = 4

etc, etc...

Except in some European countries 😛

Start in Enterprise Mangeler... uh... Enterprise Manager. 😀 Drill down to the database tables you want and select them all. Right click on any of the selected tables,...

You could probably get away with the VARCHAR location ID.

On the other, consider this... what does a dealer need most? Customers? What would a dealer need to trend...

Yeap... even on my 4 year old 1.8GHz desktop... not much of a difference... remember, this is to "return" a million rows out of 2 million...

==============================================================================

Testing lookup for non-0 Ints...

Are you using any of the sp_OA* stored procedures? Are you closing GUI (and other) connections to the data base when they are no longer needed?

Matt beat me to it... using a cursor for this is a sure fire way to make code run slow. Lose the cursor and do it in the setbased...

They would be in "Books Online" which is the T-SQL help that comes free with SQL Server... learn to love it...

Lookup "Functions" after you find "Books Online"... I'm not sure...