Was stuck trying to do without cte/subquery... Using my sample data above:

SELECT

Col1 = ISNULL(a.name,b.name),

Col2 = CASE ISNULL(a.name,'') WHEN '' THEN 'Table B' ELSE 'Table A' END

FROM @tableA...

I was thinking....

DECLARE @tableA TABLE (id int, name varchar(20));

DECLARE @tableB TABLE (number int, name varchar(20));

INSERT @tableA VALUES

(101,'Dante'),

(102,'Henry'),

(103,'Harold'),

(104,'Arnold');

INSERT @tableB VALUES

(102,'Dante'),

(107,'Gilbert'),

(109,'Harold'),

(110,'Arnold'),

(106,'Susan'),

(112,'Marian');

WITH names AS

(

SELECT a = a.name, b = b.name

FROM @tableA...

Great article Sam. Simple, to the point, easy read - well done sir!

I could be wrong but I don't think so. To my knowledge the wizard is only available when you select "New Report".

I was a DBA turned developer in 2010. I like administration but love development. If you are interested in a career as a SQL Developer you should consider getting up...

You're missing a SELECT statement. Using NOLOCK removes the guarantee that...

dmodersk (4/17/2015)

---

Wow thanks Alan! If I explain how I am interpreting this can you confirm if I am correct?

First, a temp result set is created with all the rows...

I have not worked with SQL Server HA technologies (clustering, mirroring, replication, Log Shipping) since I was a DBA but I'll give you a few questions and the thinking behind...

Ok, I put together some DDL and sample data... I screwed up the aliases a little compared to what you have but this should still suffice. What you are doing...

DDL and sample data?

Excellent, glad that worked for you.

With respect to records that are duplicated, let's say you only wanted the one with the most recent

To get the records with the oldest Export date you could do...

I'm assuming you want your query results to include the Export date? and if so which record to you want keep (e.g. the one with the earliest Export date? oldest?)

Nope, not that I am aware of. Not without using a sp_cmdshell or other non-tsql scripting tool

What's wrong with this?

SELECT

DbName = db.name,

FileType = CASE...

Katerine459 (4/16/2015)

---

Alan.B - thanks for the DDL correction. Sorry about that; I totally forgot to indicate NULL/NOT NULL when setting up the table originally, so SQL Server assumed NULL for...