Not a real fast solution but it is generating 1,679,616 permutations:

DECLARE @t TABLE (strcol VARCHAR(4))

DECLARE @Alphanumerics CHAR(36) =

'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'

;WITH Tally (n) AS (

...

L' Eomot Inversé (10/29/2012)

---

Stefan Krzywicki (10/29/2012)

---

SQLRNNR (10/29/2012)

---

Revenant (10/29/2012)

---

Koen Verbeeck (10/29/2012)

---

They can be pretty nasty.

Most...

With those lengths, it is possible to use a DECIMAL type to store the encoded...

I won't be able to help you much as your business logic is slightly elusive to me as I'm not much of a sports fan. 🙂

However you have two fields...

I am not 100% sure given the limited sample data but this may also work:

SELECT VOL_NAME, NODE_NAME=MAX(NODE_NAME)

FROM T_VOL_USAGE

GROUP BY VOL_NAME

HAVING COUNT(*) = 1

INTERSECT

SELECT VOL_NAME=MAX(VOL_NAME), NODE_NAME

FROM T_VOL_USAGE

GROUP BY NODE_NAME

HAVING...

Jeff,

Thanks for keeping me honest. I must be rusty from my holiday away to have forgotten the MAXDOP and TABLOCK.

This should also work, no?

UPDATE #Pmts WITH(TABLOCK)

SET TotalInterestPaid = ISNULL(@InterestPaid,...

ChrisM@home (10/28/2012)

---

jrichards54 (10/28/2012)

---

Is it possible to use the "IF" function in a column at design time as the value for that field? I do it regularly in Excel with no...

I'm thinking that you may have your interest accured and interest paid terminology a little mixed up here.

Take a look at the following Quirky Update (QU) method for calculating what...

I believe that 10AM until the end of the day should be 840 minutes and not 839. If that is the case, I propose this easy-on-the-eyes solution:

DECLARE @T TABLE...

How about Dim Sum for breakfast in the southern province of Trang in Thailand?

Soon I shall be logging out of SSC for a week of much needed R&R. I know you'll miss me. 😀

So, to help you cherish fond memories, I've attached...

Another article I'm looking forward to reading.

Wish I'd seen this thread sooner as I might have been able to help. Not that I claim to know that much about...

You can do it with a subquery but I tried that and it's slower. Your query is pretty good.

But there is another approach if you're running more than one...

Uggh! :w00t:

I knew my "nastiest" would also be the "costliest."

SQLRNNR (10/17/2012)

---

Stefan Krzywicki (10/17/2012)

---

SQLRNNR (10/17/2012)

---

Jeff Moden (10/17/2012)

---

Sean Lange (10/17/2012)

---

Jeff Moden (10/16/2012)

---

Wow... recent interview of a Web Developer interviewee just set a new record. Interviewee claimed 14 years experience in...