I think the query below is equivalent to your original one, w/o all the unnecessary join (unless the join on DAY restricts the rows selected from the "report" table). ...

cfradenburg (7/10/2012)

ScottPletcher (7/10/2012)

Jeff Moden (7/9/2012)

ScottPletcher (7/9/2012)

SELECT

(ident - 1) % 3,

MAX(CASE WHEN (ident - 1) % 3 = 0 THEN value ELSE 0...

Jeff Moden (7/9/2012)

ScottPletcher (7/9/2012)

SELECT

(ident - 1) % 3,

MAX(CASE WHEN (ident - 1) % 3 = 0 THEN value ELSE 0 END) AS...

SELECT

(ident - 1) % 3,

MAX(CASE WHEN (ident - 1) % 3 = 0 THEN value ELSE 0 END) AS part,

...

In general, I too prefer NOT EXISTS, although SQL will often generate identical plans for either one.

It's definitely strongly preferred whenever possible to have an index to support the lookup,...

I think this gets you pretty close, w/o having to resort to CLR:

WHERE

--one +/- optional, but must be first if used

PATINDEX('%[+-]%', varcharValue)...

SQL Server explicitly discards SET values at the end of the stored proc and, AFAIK, there is absolutely no way to change that directly.

You could, of course, save the desired...

Please substitute your db name below,

and your table name in BOTH places below where <your_table_name> appears, then run the queries and post the results.

USE <your_db_name>

SELECT

GETDATE()...

You likely should have (at least) column A as the clustered index on the table.

Would need more details and info to determine if another column(s) should be in the clus...

SQLKnowItAll (7/9/2012)

ScottPletcher (7/9/2012)

SQLKnowItAll (7/9/2012)

What am I missing... How can it...

Join...

I agree that the fillfactor should be carefully reviewed, but not...

OmegaZero (7/6/2012)

I'm not 100% sure of how to handle the AccountSales table though - since if I did it by id the dates would not match up correctly if joined...

Dev (7/9/2012)

ScottPletcher (7/9/2012)

False, of...

False, of course. ...