The attached script is mangled when I open it. Looks like line-breaks were removed.

You can almost always insert from temp tables to real tables with simple Insert...Select statements, and...

When you say "sorted by letter then number", it would be helpful if you'd give an example of what you want vs what you get.

If, for example, you want:

Q1 Alliant...

Managers who give a darn is the best "perk" I've had. I've had the privilege to work with lots of them, at most of my jobs, but I've also...

Connections via SSC and LinkedIn have got my phone ringing off the hook (well, the phone isn't old enough to do that literally, but you get the idea) from recruiters...

For a number of things, a "local fast_forward" cursor can be much faster than other looping methods. I use these to generate scripts that can be run dynamically, like...

Hello everyone. I'm Gus and I'm not currently a DBA,...

WayneS (8/26/2010)

---

Stefan Krzywicki (8/26/2010)

---

On a side note, why busses? Why aren't people in these theoreticals brought up in too many meetings ever hit by taxis, trucks, private cars, trains, boats,...

It's a pic of a pet iguana I used to have.

The Import Wizard works great if you only have to do this once. If it's something you'll do regularly, I recommend SSIS. You can use the Import Wizard...

You'll need to set up an account that has the rights to do that, and then have the program use that account to issue the necessary T-SQL commands.

Books Online (or...

Amusingly enough, I'm taking a break from City of Heroes (online superhero game) to read a few posts on SSC, and I find this!

If I could be any superhero at...

CirquedeSQLeil (8/26/2010)

---

So here is my question of the day

How do you convince somebody that archive data should not be changed?

Data integrity didn't work

Point in time visibility did not work

Reporting consistency...

Oh, and since I got rid of the beard, I've updated my picture. 🙂

Hello The Thread!

Sorry about disappearing so suddenly and completely a few months back. Let's just say life has been unusually "interesting" lately, and hope you guys can forgive the...

jcrawf02 (4/22/2010)

---

Grant Fritchey (4/22/2010)

---

jcrawf02 (4/21/2010)

---

Pity that Brent will get kicked out of the MVP club so soon after his MCM... 😛

And now for something completely different...

Any advice on ridding my...