It has nothing to do with ISNULL. It has to do with the implicit conversion of the empty string into a DATETIME.

You...

http://msdn.microsoft.com/en-us/library/ms191461.aspx

EXEC sp_addlinkedserver 'exchange',

'Exchange OLE DB...

Define the "first occurrence". SQL is unordered sets of data, so there is no defined "first" unless specified by the code in an ORDER BY.

With the sample data you have...

Because your WHERE clause is implicitly converting an empty string to a datetime.

e.g.

SELECT CAST('' AS DATETIME)

Which equals "1900-01-01 00:00:00.000".

So your WHERE clause is basically as follows: -

WHERE ISNULL(a.DayBase,'') <> '1900-01-01...

cliff.gettings (11/30/2011)

---

Thanks Drew,

Unfortunately, I still unsure what to do.. you refer to a csv file? I don't have this in a csv file, these are in a table in SQL...

Here's the responses from the other version of this post -

Cadavre (12/1/2011)

---

SELECT aYr, bYr, aCol, CASE WHEN aYr = bYr

...

And another

SELECT aYr, bYr, aCol, bCol

FROM #A a

INNER JOIN (SELECT bYr, bCol, MAX(bYr) OVER (PARTITION BY (SELECT NULL)) AS maxbYr

...

Ummm. . .

I was showing you how...

Not sure I know what you're asking. Does this help?

BEGIN TRAN

CREATE TABLE #user

(id int identity(1, 1),

userid int,

firstname VARCHAR(20) NULL,)

INSERT INTO #user (userid,firstname) VALUES (4,'Duke')

INSERT INTO #user (userid,firstname) VALUES (5,'David')

INSERT INTO...

Untested: -

CREATE TABLE #A (aYr INT, aCol INT)

INSERT #A (aYr, aCol) VALUES (2008, 2)

INSERT #A (aYr, aCol) VALUES (2009, 5)

INSERT #A (aYr, aCol) VALUES (2010, 9)

INSERT #A (aYr, aCol) VALUES...

bitbucket-25253 (11/30/2011)

---

My observation of comments on mine, plus those on yours, shows just one thing. How disrespectful people can be. I noticed the "incorrect" text in the CORRECT...

tmccar (12/1/2011)

---

Yes, you are right - the drawing number should not have the ".dwg" extension

OK, here is what I've tried:

SELECT Smalltable.[Drawing Number], "Path"

FROM Smalltable

INNER JOIN Largetable

ON Smalltable.[Drawing Number]=Largetable.[Drawing Number]

But I'm...

What was with the font size? I had to zoom out to 5% to be able to fit it on my screen! 😛

What John was asking you for was ddl scripts and readily consumable sample data, such as this:...

And another, far uglier method 😀

DECLARE @startdate DATETIME

SET @startdate = '2011-11-18'

SELECT DATEADD(DAY,ISNULL(NULLIF(ISNULL(NULLIF(ISNULL(NULLIF(NULLIF(NULLIF(NULLIF(NULLIF(DATEDIFF(dd,0,@startdate)%7,0),1),2),3),6),1),4),3),5),2), @startdate)