Eric M Russell (7/26/2012)

---

Lynn Pettis (7/25/2012)

---

Eric M Russell (7/25/2012)

---

I'm not a beer connoisseur and don't care for the small batch gourmet stuff. When I drink beer, I'm either drinking Miller...

Karthiart (7/26/2012)

---

ChrisM@Work (7/26/2012)

---

Well I'm stumped on this one. The CASE expression is a red herring - it's irrelevant. What's...

Sometimes all it takes is the extra thought required to write the problem down. Would you like to share your solution with us Thomas? I'm sure the...

Well I'm stumped on this one. The CASE expression is a red herring - it's irrelevant. What's significant is...

amitsingh308 (7/26/2012)

---

hello

This query is work's for me but only the case where number of result set in both select statement are same but in my case issue is that...

Golfer22 (7/25/2012)

---

How do I optimize a query with several nested joins? An index scan has the highest cost in the execution plan and a related nested join has the...

I'd agree with Phil - it's not worth...

Thank you, that's very kind - but I'm just a jobbing TSQL programmer 🙂

Here's a slightly performance-enhanced version.

IF OBJECT_ID('tempdb..#PreAggregate') IS NOT NULL...

Thanks for the sample data, excellent work. This query generates the correct result set, you may wish to change the way it's presented:

IF OBJECT_ID('tempdb..#PreAggregate') IS NOT NULL DROP TABLE #PreAggregate;

;WITH...

milindsaraswala (7/26/2012)

---

I am using SQL Server 2008 R2. I was looking for help to make query. I am trying to compare data between two years with following query

Select [Business...

deepzzzz (7/26/2012)

---

Hi,

Please find the below query

INSERT INTO tbl_employee (EmpNo,CompanyID,MngrID,DateOfFiled,DateOfClosed,DateOfCreation

,LastModified,Active,flag)

VALUES(

'2011-1508' ,89827,null,null,null,GETDATE(),GETDATE(),1,'C')

In the table, column 'Active' is of type int

I...

vinu512 (7/25/2012)

---

Jeff Moden (7/25/2012)

---

Look at the execution plan for that, Vinu. There are 9 rows in one table and 4 in the...

Sean Lange (7/25/2012)

---

Phil Parkin (7/25/2012)

---

Nice article - thanks for the link. When I read absolutes (like 'meaningless') my brain subconsciously challenges them. I still think it was the wrong word...

Gazareth (7/25/2012)

---

ChrisM@Work (7/25/2012)

---

Phil Parkin (7/25/2012)

---

Nice article - thanks for the link. When I read absolutes (like 'meaningless') my brain subconsciously challenges them. I still think it was the wrong word...

Quite right...