Something like this should work:

SELECT T.CandidateID,

Missing=CASE WHEN T1.CandidateID IS NULL THEN 'Missing From Table 1'

WHEN T2.CandidateID IS NULL THEN 'Missing From Table 2'

ELSE 'Present in Both'

END

FROM (SELECT DISTINCT CandidateID

FROM...

Your syntax is all messed up. You have no closing parens on any of your ISNULL's or RTRIM's in addition to numerous other syntactical errors. However, due to...

If I wanted to manipulate a single value, or a very small...

The phone number is a float, and when using CAST, it will give you scientific notation.

Try this one:

STR(phone, 10,0)

I personally avoid...

Not to mention the answer he gave had already been given, better, and in more detail before he bumped it. That post was in general a failure of epic...

I just realized that my query will fail in the case that there are no text files associated with a particular date. (IE. If all 5 customers are missing...

The only thing that made sense to me with the time was that it was

70004 7:00:04

210053 21:00:53

20003 2:00:03

200002 20:00:02

Seconds wouldn't work, as there are...

Type faster! =)

So many cross joins, so little time!

---------- ALTER TABLE TO NORMALIZE DATA ------------------

ALTER TABLE #ReportFiles

ADD ReportDate datetime, Company varchar(20)

UPDATE #ReportFiles

SET ReportDate = CONVERT(SMALLDATETIME,SUBSTRING(FileName,1,CHARINDEX('_',filename)-1))

WHERE ReportDate IS NULL

UPDATE #ReportFiles

SET Company = SUBSTRING(filename,CHARINDEX('_',filename,1)+1,(CHARINDEX('.',filename,1)-CHARINDEX('_',filename,1))-1)

WHERE...

I think I'm starting to grasp what you're after here, but to generate a solution, I'd like a bit more information than you've given.

Please supply the following:

A sampling of data...

Sergiy:

Thanks for the tip. I added in a DBCC FREEPROCCACHE before the views and reran the results, but still no differences worth mentioning. I'm guessing that's...

WHERE FirstName <> 'Jimmy' AND LastName <> 'Woods'

I believed both my coalesce View and the UNION ALL to be viable solutions to your issue, but I was curious as to which was more efficient. I'll post...

As bitbucket noted, this question is somewhat limited on information. I went ahead and scripted up a solution(mainly because it gave me another opportunity to use a cross join),...