And the referee throws down a...

The check is in the mail!

I'm wondering how improvements #1...

Eugene - Actually, I'm not sure which version of your code I tested against, possibly an earlier one. That one was running in about 16ms as I recall, where...

Here's a version of the Tuples solution that runs in about 1/3 the time:

;WITH SourceNums AS (

SELECT strcol FROM (VALUES ('1'),('2'),('5'),('7'),('8'),('9')) a (strcol)

),

nTuples (n, Tuples) AS (

...

ChrisM@Work (9/12/2012)

---

A completely different method, courtesy of Dwain C:

;WITH SourceNums AS (

SELECT strcol FROM (VALUES ('1'),('2'),('5'),('7'),('8'),('9')) a (strcol)

),

nTuples (n, Tuples) AS (

SELECT 1, CAST(strcol...

This is pretty short too but subject to the DATEFORMAT setting (I think):

SELECT DAY_, MONTH_, YEAR_

,CAST(RTRIM(MONTH_) + '-' + RTRIM(DAY_) + '-' + RTRIM(YEAR_) AS...

What if all 3 are negative? Still zero?

Ah yes, NULLIF... Forgot about that one.

That will work but we still need to hear from the OP their preferred return result for that case so it can be plugged...

Michael Valentine Jones (9/12/2012)

---

dwain.c (9/12/2012)

---

Another way:

;WITH MyValues AS (

SELECT Id

,A=CASE WHEN A > 0 THEN A ELSE...

Another way:

;WITH MyValues AS (

SELECT Id

,A=CASE WHEN A > 0 THEN A ELSE 2147483647 END

...

Another way:

-- To get just the table names

SELECT DISTINCT TABLE_NAME

FROM information_schema.view_column_usage

WHERE VIEW_NAME = 'v_YourView'

-- To get table and column names

SELECT TABLE_NAME, COLUMN_NAME

FROM information_schema.view_column_usage

WHERE VIEW_NAME = 'v_YourView'

Assuming you're using a TIME field to store your values, you can use a Tally table and the built-in DATEADD/DATEDIFF functions for this:

DECLARE @t TABLE

(OfficeId INT,...

Jeff Moden (9/12/2012)

---

dianne.howard (9/12/2012)

---

I'm new to SQL all together, but I have the following issue I really need help solving;

We have a list of customer transactions that are grouped together...

bpowers (9/12/2012)

---

I have a table that contains permissions based on a group id. How would I go about building a script that would compare two groups and return only the...

My archaeological dig uncovered the following:

SELECT a.name

,LTRIM(RIGHT(defn, LEN(defn) - (3 + CHARINDEX(' as ', defn))))

FROM sys.all_objects a

INNER JOIN sys.sql_modules b

ON a.object_id =...