The poster's explanation is an opinion which Shaun happens to agree with.

Adam Haines (4/2/2008)

---

This is similar and may in some cases work faster:

SELECT a.id

FROM tblA a

LEFT OUTER JOIN tblB b

ON...

Adam Haines (3/31/2008)

---

Just putting a solution that is new to SQL 2005. It works the same way as not in, except nulls do not throw it off.

select id

from...

Ian, always check an UPDATE...FROM using a SELECT first. Only when the SELECT returns the values you are expecting should you convert it over to an UPDATE...FROM. It makes the...

Try this in SQL2k or equivalent mode:

SELECT ShippedDate AS [OrderDate], * FROM Northwind.dbo.Orders o ORDER BY o.OrderDate DESC

which has a table name (or rather alias) preceeding the column name. If...

Matt Miller (3/31/2008)

---

If you're trying to make sure that they don't re-enter existing clients - why not force them to go through the existing list of customers FIRST? Like...

It's not built-in like 2k5 so you have to write your own. I've used it a lot for migration deduping on the last project with this client, looking for dupes...

Kev

Try this in a SQL2k query window:

select OrderDate, * from Northwind.dbo.Orders order by OrderDate desc

Yes of course it works....

Hi Ahmad, depending on how many rows you're working with, fuzzy matching may also be an option. You could employ SOUNDEX or DIFFERENCE to quickly obtain a list of likely...

Haha! Cool! Good luck, mate. And...nice one, Jason!:)

Bend Over Here It Comes Again. (pronounced: bow-hee-ka)

This is for information purposes only, it's not an instruction :hehe:

How are you getting on with this, Ahmad? It would be interesting to hear which...

LOL! Oh yes! 😀

Loner (3/21/2008)

---

I was there to see the rocks and I did not find it amazing. Maybe it was me.

First no on knew why those rocks were there,...

erdem (3/19/2008)

---

Hi Folks,

I really wonder to know how to correct the mistake below.How can I use CASE statement?????

Please help

select b.SiparisNo,

datediff(day,a.dteTeslimTarihi,b.OnayTarihi) as 'Gun Farki',

substring(c.sKodu,1,12) as ModelKodu,

CASE datediff(day,a.dteTeslimTarihi,b.OnayTarihi)

when datediff(day,a.dteTeslimTarihi,b.OnayTarihi)>0 Then 2...