blandry (1/6/2009)

---

This is one of those topics where a "keen sense of the obvious" comes in very handy, but unfortunately, in my experience, it hasn't. Its great to design...

Jeff Moden (1/1/2009)

---

Piotr Rodak (1/1/2009)

---

Now, that's a cunning trick I see now Jeff :w00t:

Not earlier than yesterday I said to myself 'one day I have to get those dateadd-datediff calculations...

In case someone's reading this and doesn't have the U.S. English default set on their instance, don't forget to check @@datefirst to make sure which day starts your week.

You'll...

Can I ask why you're doing this?

Is this a one-time y/n determination (in which case, why add a new column, just check as previous poster showed whether something exists)...

Thanks for the blog post Gail, I don't use error-checking and transactions as much as most, since I can't write to anything but Tempdb, but wasn't aware of these issues...

OR . . . . (you guys are making this harder than it needs to be)

Copy . . .

Paste . . .

😀

Score by hand? What...

Two comments -

Steve - interesting model of the solar system you have posted in the article, haven't seen that one before 😀

Everyone else (except Darth & Ninja, you guys...

blandry (12/19/2008)

---

(First - a correction for AndyD... Holly is NOT the female computer in Red Dwarf - that is Hilly. Holly is the actor Norman Lovett, a male...

My sister-in-law is crazy about that stuff. Can't...

I'm partial to the displays and computers seen in Final Fantasy: The Spirits Within, built from lifeforce.

While fictional, it does seem to me that it could be not-so-far off...

Thanks, gotta run tonight, but I'll try Profiler tomorrow. Haven't actually used it before, so that'll be fun, I enjoy learning new tricks.

Thanks for the suggestions, I'll let you...

It'd be a long shot, that's a table for a termed vendor, on whom I'm doing analysis, it didn't exist in the tempdb before I ran the script, and I...

Bummer, there goes my grand scheme. 😉

just running inserts, sample below (minus the data)

INSERT INTO ##UCHP (status,[Name],Provider,DOS,[Claim Amt],[Paid Amt],[Paid Date],[Check Number],[Claim Number],[Payor]) VALUES ( ... )

Well isn't that a nice, fuzzy thought? All I did was

DECLARE @chaos varchar(max)

SELECT @chaos = replicate('DROP DATABASE ' + (SELECT name FROM sys.databases WHERE ID = N) + '...