Poor HAVING, nobody likes him 🙂

SELECT

ProductID, BaseSupplierID,

MIN(CASE WHEN SupplierID <> BaseSupplierID THEN Price END) AS LowestPrice,

MIN(CASE WHEN SupplierID...

You could also make the "real" column name a computed column that the developers use, and based off a "dummy name" column so they don't have to deal with NULLs....

Can you just add the column with no default value, for now, and handle the NULLs in the code temporarily?

It's almost certainly applying the default value that is taking the...

select

a.a, a.b, a.c

from @a a

left outer join (

select b

from @a a2

group by b

...

select dateadd(day, -3, dateadd(week,-4,getdate()));

Sqlism (3/11/2013)

---

Hi Experts,

Is this is the Best Practice to select E: for the SQL Server root directory? Please let me know the Pros/cons and the practices to be followed.

Thanks a...

Maybe code below will do what you need.

I haven't tried for efficiency, just to get the result you want.

select

a.a, a.b, a.c

from @a a

left outer join (

...

opc.three (3/8/2013)

---

No, not unless RECURSIVE_TRIGGERS is ON. It...

Hmm, seems to me that in this case the query is the same either way, with exactly the same WHERE clause structure.

The only difference is that the WHERE comparison value,...

Sure, that's easy, as long as you have unique column(s), such as an IDENTITY column, you can use to identify a specific row in the table. SQL provides a...

Lynn Pettis (3/7/2013)

---

ScottPletcher (3/7/2013)

---

Sorry, not to rain on the parade, but to me now is not the time to celebrate.

Getting the job is good, but it's just the start. ...

Sorry, not to rain on the parade, but to me now is not the time to celebrate.

Getting the job is good, but it's just the start.

Dedicate yourself to...

Gazareth (3/7/2013)

---

ScottPletcher (3/6/2013)

---

To confirm, try writing the results returned by OBJECT_DEFINITION() to an nvarchar(max) column and checking the length of that column: I think you'll find that the entire code...

SAinCA (3/6/2013)

---

@ScottPletcher

Not sure if what you are saying is that "it didn't happen the way I said it did..."

READ_COMMITTED_SNAPSHOT isolation is set ON for the database in question.

In order to...

SAinCA (3/6/2013)

---

Please, if you're on SQL2005, watch out that you have sufficient TEMPDB space to accommodate all those deleted rows.

When a row is deleted, it is stored in TEMPDB as,...