Ran into the same problem myself tinkering with EXCEPT. No, it's not going to do what you want, it can't completely replace LEFT JOIN t ON x/y WHERE t.x...

Digs (11/15/2010)

---

I get round this buy using a #temp table, but it seams this is not wise on a select statement that is very active ( ie behind a blog),...

Learner1 (11/15/2010)

---

thanks ,,,,,,,no it's not a home work

its again an interview question but I got an answer already...

this can be done using a corelated query

SELECT DISTINCT (a.age) FROM test55...

Apparently, no. It's documented here...

GrassHopper (11/15/2010)

---

I want to create a temp table that I can use for my subquery in my loop, so that I don't have to run it 3 times for my...

"So, that's your blade server?...

Remove the GO after the Drop Table statement. It ends the batch.

If you want an in-proc terminator, use ;

It's not necessary here though.

Go forces the following script to happen...

paul.olson.dba (11/15/2010)

---

Craig Farrell,

In the back of by head I thought that migrating to an empty db would be the last resort but it is looking like this is my only...

Well, since you showed your work this will be easy to help get you back on track.

This is a...

I've seen this before. It's not pretty, and you're going to need downtime to fix this if it's production.

For whatever reason, 2k5 and LOBs don't play nicely. It...

To add to what Roy said, and he's right, that just means it's more expensive data wise than it is computationally, there's a few other things you need to see.

No...

CirquedeSQLeil (11/15/2010)

---

WayneS (11/15/2010)

---

Now, just need to find a new girlfriend who actually CARES what sauce...

Might sound odd, but was the table filled with LOB data?

Example datatypes: text, VARCHAR(max), XML...

I'm a geek... Warhammer40k. 😀 (The Tyrannid shall EAT you!)

wannalearn (11/15/2010)

---

Thank you for your reply. Per your advice,

I created

DELETE ABCDEF FROM dbo.XYZ

WHERE Column = 'ABCDEF100'

want to delete ABCDEF AND LEAVE 100 IN THAT COLUMN

Plz help me create statement for...