Interesting one.Thanks for question.

+1

Thanks Andy for the question.

Thanks Nenad for question.

Very interesting question. Never used Escape.Thanks Andy.

very interesting question.Thanks Barry.

Thanks for question Andy.

Try this .DATEPART

Procedure

Another confusing question 🙁

Permission to run...

mattech06 (6/18/2014)

---

Actually guys, the old classic, it worked on that specific example but not on the full data set.

So a better example would be using a table with ..

CREATE TABLE...

mattech06 (6/18/2014)

---

sorry I missed rymthnk post. Yep that also works with the sample db, however my actual working sql is (with user variables included)....

(b.TransType IN ('') OR '' =...

what about "None of these" 😉

mattech06 (6/18/2014)

---

thanks BWFC that works but instead of

WHERE q.Description = 'Bob'

I'd want the q.Description to be the description of row number 1 as I can't hard code 'Bob' into the...

what about this 😉

;with qry

as

(select [amount],[Description], row_number() over (order by amount) as RN from #question)

select q.[description],sum(q1.amount) from qry q, #Question q1

where RN = 1

group by q.[description]