You're welcome. Thanks for setting up...

toddasd (8/31/2011)

---

ColdCoffee (8/31/2011)

---

This will be more robust:

select ColA, ColB

from TestTable

order by isnull( ColA , ColB) ,

case when ColA is...

😀

This will be more robust:

select ColA, ColB

from TestTable

order by isnull( ColA , ColB) ,

case when ColA is not null...

How about this ?

select ColA, ColB

from TestTable

order by isnull( ColA , ColB) , isnull( ColB ,ColA )

A more cleaner version:

DECLARE @StartDATE DATETIME

SET @StartDATE = '01-01-1985'

;WITH Tens (N) AS

(

SELECT 0 N UNION ALL SELECT 0 UNION ALL SELECT 0 UNION ALL

...

If you dont have a tally table, you can utilize this code :

DECLARE @StartDATE DATETIME

SET @StartDATE = '01-01-1985'

;WITH Tens (N) AS

(

SELECT 0 N UNION ALL SELECT...

And Mr ( or Ms ) sdownen05 , thanks for setting up the problem fantastically 🙂 Right on the money ; appreciated 😎

Or this:

; WITH Distinct_Jobs AS

(

SELECT DISTINCT Job

FROM #JobOrder

)

SELECT CrsAppOutput.Job , CrsAppOutput.OperName , CrsAppOutput.Operation , CrsAppOutput.Complete

FROM Distinct_Jobs OuterTable

CROSS APPLY

(

...

And with proper index on YearMonth column, the script should complete in a jiffy. I wonder if a Quirky Update code can be bestowed on this puzzle :unsure:

Wooooosh... i dint see Chris posted a similar solution 😉

{ Note to self : Brush the teeth before even...

Wont this do?

Shamelessly utilizing the sample data that Cadavre prepared( Thanks Cad)

DECLARE @TABLE AS TABLE (Yearmonth DATETIME, Metric1 INT, Metric2 INT)

INSERT INTO @TABLE (Yearmonth, Metric1)

SELECT '2010/01/01', 1 UNION ALL

SELECT...

I so expected this 🙂 I need to just hash thro some of my old code,...

I second what Sean says, formatting is to done at the front end.

But, doesnt this work for you ( or am i missing the obvious ?? )

DECLARE @Budget TABLE

(

ID INT...

Glad i could help 🙂

Have a look at my previous post also on not casting an...