There are good examples in Books Online:

UPDATE dbo.Table2

SET dbo.Table2.ColB = dbo.Table2.ColB + dbo.Table1.ColB

,dbo.Table2.ColC = dbo.Table1.ColQ

FROM dbo.Table2

INNER JOIN dbo.Table1

ON (dbo.Table2.ColA...

Also, both these are reviewed over at the SQL PASS Book Review SIG. Along with a bunch of others.

I've got two, one I've read and one I want to read:

Inside SQL Server 2005: T-SQL Querying

by Itzik Ben-Gan

It's just a wonderful book. I refer back to it regularly. The...

I'd suggest instead of spending your time trying to prop it up, you dive in and start refactoring it in bits and pieces to reduce the compile time and run...

Not arguing, just pointing out, Size06...Size24 is a pretty serious violation of 3NF. I'd think you could get the same results without that.

I'll give it a shot. If I end up in the hospital, after I get out, we're going to have a chat. 😛

dfalso (5/2/2008)

---

Jeff, I appreciate both your and Grant's replies. I also appreciate your concerns about something that's written for a small situation now, but for whatever reason is used in...

How did you know what I had planned for the week-end... 😀

I have to ask though, what's drowning breath exercise? While we do incorporate a lot of traditional stuff, including...

Use a function to turn the comma-delimited list into a table and then join against it. You'll get all the matches and it doesn't matter how long the list is....

Short answer: It depends.

Longer answer: It depends. Let's take an example. You're doing a load that's going to direct data to one of two tables, so there's an if statement...

Personal opinion, so please take with a grain of salt...

You should put the time in to learn how to do things properly in SSIS & SQL Server. That will serve...

You're in 2005 right? Although I don't advocate using ad hoc queries, if you have to, simply use NVARCHAR(MAX).

dheeraj17sharma (5/2/2008)

---

dear,

GETSTOCKLEDGER is just a user defined procedure with some input parameter. above i have describe just a single log which might have arise during the execution of captured statment...

dfalso (5/1/2008)

---

Jeff, I agree with the point you're trying to make, assuming that this code is destined for a production use. I would absolutely look to a set-based solution, not...

Oh, wait. I am an idiot. Here's the deal. The optimizer is smart enough to recognize that you're creating a table within the set when you execute the whole thing,...