How about this way:

SELECT [Month] = datename(mm,min(SomeDateTime)),

Amount = SUM(SomeAmount)

FROM #MyHead

WHERE SomeDateTime >= '2010' AND SomeDateTime...

How about the comment toggle trick:

-- Toggle trick

SELECT 'Toggle line 1'/*

SELECT 'Toggle line 2'--*/

By commenting line 1 line 2 becomes active.

:w00t:

I wasn't paying attention to the date of your post but to the more recent ones. I...

It is about the...

What...

vliet (4/3/2013)

---

We tried both the CTE approach and the AND clause on the WHEN NOT MATCHED BY SOURCE part to merge rows spanning only a certain period. The performance of...

If the bound errors happens than you will have to replace it with an EXISTS condition:

... and exists (select * from #test2 where id =t.id)

The author was kind of superficial...

al_kessler (4/3/2013)

---

P Jones (4/3/2013)

---

As another MERGE fan I'd use

WHEN NOT MATCHED BY SOURCE AND (t.ID = s.ID) THEN DELETE;

in the original merge statement.

But I've no complaints about the...

Did I miss something? I didn't have the patience to go over all 54 pages of replies. Initially when the code for the cteTally was changed to be faster it...

The "official" answer given is not accurate. Views 3 and 6 are not created due to syntax errors and from the rest 1, 4 and 5 don't return errors if...

--===== 2005 Method, 100,000 rows ====================================================================================

DECLARE @SomeNumber INT;

SELECT @SomeNumber = 100000 ;

WITH

E1(N) AS (SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1...

Jeff Moden (3/24/2012)

---

the sqlist (3/24/2012)

---

ChrisM@home (3/24/2012)

---

I couldn't disagree more. When you're looking at an overall...

ChrisM@home (3/24/2012)

---

I couldn't disagree more. When you're looking at an overall time of 25ms per...

And here is for 100,000 and 1,000,000 numbers:

set statistics time on

set statistics io on

SELECT n = (n1 + n2 + n3 + n4 +n5)

FROM (((VALUES (0),(100),(200),(300),(400),(500),(600),(700),(800),(900)) t3 (n3)

CROSS JOIN...

Practically there is no difference in terms of load:

set statistics time on

set statistics io on

SELECT n = (n1 + n2 + n3 + n4)

FROM (((VALUES (0),(100),(200),(300),(400),(500),(600),(700),(800),(900)) t3 (n3)

CROSS JOIN...