Lynn Pettis (12/29/2009)

---

Congrats Gus. How about sending some of that good luck my way. Can't seem to catch a break at all.

Kassondra was in a car accident Sunday...

For anyone here a month or so ago, I have good news on the employment front. Starting a new job with a much better company in mid-Jan. (About...

jcrawf02 (12/29/2009)

---

GilaMonster (12/28/2009)

---

Precisely why I want it for the PC. Xbox and gaming is all well...

I am. Trust me, I wasn't born perfect, I had to work for...

James Stover (12/28/2009)

---

GSquared (12/28/2009)

---

James Stover (12/27/2009)

---

I'll go one further - I don't think it's acceptable to have service packs. It's an acknowledgement that a product is defective. Only after an...

Will something like this work?

/*

Multi-row string concat using XML and string functions.

Pretty slick trick. Got it from RBarryYoung and Lynn Pettis on SSC.

*/

if object_id(N'tempdb..#T') is not null

drop table #T;

create...

Take a look at "create trigger" in Books Online or on MSDN. It has the syntax for creating triggers. You can use the "inserted" table to select from,...

Steve Jones - Editor (12/28/2009)

---

I hadn't thought of that, but companies ought to offer pay for holidays. I know we're on salary for the most part, but we should get...

It depends on the product. Some yes, some no. Search...

I've been busy with EVE Online recently. That and still playing City of Heroes. I don't have and don't currently want a console. Used to have an...

The server you're deploying the DLL on is missing the objects referenced in the error message.

You need to make sure the machine the DLL was built on has the same...

Not sure what you mean.

Triggers fire when data is inserted, update, and/or deleted. Are you looking for a trigger that fires on an insert if a certain row is...

The whole point of With NoLock is the other way around. If someone is in the middle of deleting or updating a row, With NoLock will still read the...

This one looks like homework, and I usually don't answer those, but it intrigued me enough to give it a shot.

You have a Dept column, and Acct 1 has entries...

The whole point of 64-bit systems is that they can natively address a lot more than 4 Gb of RAM. AWE isn't applicable because of that.