Jeff, please please please write a book, without changing your style. Give us all an opportunity to repay you for what you've done for us.

Here's another version using APPLY without any sneaky tricks.

DROP table #orders

create table #orders(

oid int,

itemid int

)

insert into #orders (oid, itemid)

values (1,1111)

insert into #orders (oid, itemid)

values (1,2222)

insert into #orders (oid, itemid)

values (1,3333)

insert...

IF / ELSE is conditional processing of statements, so CASE would better match your requirements.

You will need to provide a more complete explanation of conditions and outcomes for a...

Hi Virgil

This link[/url] will show you an alternative set-based method of calculating running totals and introduce...

Koen Verbeeck (5/1/2011)

---

ChrisM@home (4/30/2011)

---

LutzM (4/30/2011)

---

Slightly different over here in Germany: if a holiday falls on a Sunday (as it happens with May 1st this year), we won't get a public...

This is probably the simplest set-based solution. It's...

A recursive...

Here's a solution right now. Never use code from a website without checking it first and fully understanding how it works - this article [/url]will explain the method used in...

Dave Ballantyne (4/30/2011)

---

Combined with the Easter Holiday last weekend as well, April is not going to be...

LutzM (4/30/2011)

---

Slightly different over here in Germany: if a holiday falls on a Sunday (as it happens with May 1st this year), we won't get a public holiday during the...

OP appears to have lost interest :ermm:

There's a solution to this without using TOP or any aggregate functions: variable assignment.

This query

DECLARE @curr tinyint, @ddate smalldatetime, @rate decimal(15, 4)

SELECT @curr =...

In addition to the questions which Craig has asked, can you confirm which version of SQL Server you are using? This is the SQL Server 7, 2000 section.

Cheers.

This has been discussed on the forum before, I'll try to find the thread.

If you have a sequential integer PK, then this is fast.

SELECT *

FROM TransactionDetail

WHERE TransactionDetailID = (SELECT ABS(CHECKSUM(NEWID()))%100000+1)

Replace 1000000 with the max ID in your table.

What result do you expect from 134.478?