Frankly, this strikes me as the sort of problem that might be better done on the client side, but you can test this logic out.

Basically, the...

Joe, this is essentially a running totals problem further complicated by the need to associate each sale with a buying price. It's like FIFO inventory. ...

Sean is correct, and I was remiss in not mentioning the possibility of SQL Injection attacks. Gail's article, which he refers you to is excellent. ...

Congratulations, Lynn! Hope all goes smoothly for mother and child.

If any value in a formula is NULL, the result is NULL. This includes concatenation of columns and variables.

(I know not these "fields" of which you speak.)...

You might want to look at the Quotename() function in BOL.

Wisecrack withdrawn.

This is pretty standard stuff actually. Here's one way to code it.

If your table is large you would certainly benefit from having indexes on both...

So can beer, Jeff. I'm about to go sample some. Have a great weekend, y'all.

Your join requires that every row of Table2 be tested. Your addition of NOT NULL restricts the set...

Stats on how many NULLS are in Col2 and in Table1.ID?

In deciding to use an index, the optimizer is informed by both the sequence and the distribution of values in...

Be sure always to call it please "research."

But you HAVE to enclose the variable in parentheses

This works.

declare @x int = 10

select top (@x) *

from sys.all_objects

This doesn't. You'll get a syntax error.

declare @x int = 10...

I tested it out. The Double-LEFT join runs over 10 times faster when joining 100,000 rows to 9,000 rows. HOWEVER, the critical difference isn't...

Jim Murphy (6/3/2011)

Bob - this is an old thread and...