ggraber (1/23/2009)

---

Don't know if this helps, Jeff, but I found a post from a few months back that was asking to solve this problem.

The OP did not say why he...

JohnDBA (10/23/2008)

---

Please help me!

I have this values that I need to count based on condition.

- If the value is between 10 and 15 and the code is = a...

Heh... aswesome... new word for my IT dictionary... should be included in the definition of RBAR as a result of a set based programmer finding RBAR in code. ...

I'll add another wish... there's a lot of things (not just running totals) that require "looking" at a range of previous or next rows. It would be handy to...

MelS (1/23/2009)

---

Add a lightning-fast way to encrypt and decrypt data. Even following Microsoft's suggestions to combine symmetric and asymmetric functions, performance isn't there. And what about indexing on...

sing4you (1/23/2009)

---

My big beef is with the date functions. I often have to calculate how many years, months and days between two dates. SQL will tell you that...

majorbloodnock (1/23/2009)

---

Agreed. Has anyone else looked at the calculation necessary to work out Easter? I had to write one a few years...

Jim Russell (1/23/2009)

---

Error messages from BULK IMPORT or BCP that provide some useful information about the nature of the error.

Native ability to import fixed format flat files with sign over...

Helen Trim (1/23/2009)

---

I would appreciate an Age function.

It is only a small bit of code to calculate, I know, but I bet a lot of people would find...

Man, I forgot about that. Add a nasty fast LUHN-10 checksum and the bank account number checksum...

Chris Harshman (1/23/2009)

---

I agree with Jeff Moden on a number of the items he mentioned, especially better date functions and the ability to more easily read in delimited files such...

It had to be... nothing else would do it. Thanks for the honest feedback.

Heh... Oh my... everybody knows about the pork chops!

Nope... no pork chops for you today. 😛

Lowell (1/22/2009)

---

wait, i think i get it....still use a loop or FOR XML to construct the complete set of statements, and run the massive varchar(max) as a batch, instead of...

Heh... ya just hit a sweet spot, Steve...

Proper windowing functions that you can do proper aggregations like SUM(xxx) OVER() with so running totals and the like are a bit...