Another way:

INSERT INTO TableB

SELECT * FROM TableB

EXCEPT

SELECT * FROM TableA

If your tables have many rows, performance is likely to be an issue so I'd recommend that you create a temp table to store the row vs. row time differences...

Using Alan.B's set up data, here's another way (except using DATE data type):

-- Setup

IF OBJECT_ID('tempdb..#x') IS NOT NULL

DROP TABLE #x;

CREATE TABLE #x

( Studentid int, DateID DATE unique, attendaceind bit)

INSERT...

Sounds like you got it working! That's great!

I thought of a simplification right after I posted the original, so here it is based on the latest query you just...

BWAAAHAHAHAHA!

Actually, I thought maybe you couldn't use it because you had multiple rows like this to process.

It is difficult to interpret your Excel results because you don't have any identifying keys saying what ship type it is.

Can you align the results from Excel with the results...

greg.bull (2/5/2013)

---

Golly, thanks for this - saved me a lot of time. I read Jeff's article and was just beginning to understand bits of it when my daughter cam home...

I get these errors when I run your SQL.

(780 row(s) affected)

Msg 207, Level 16, State 1, Line 792

Invalid column name 'questionnbr'.

Msg 207, Level 16, State 1, Line 792

Invalid column name...

Not sure exactly if this is what you're after but maybe it'll help:

DECLARE @XmlData XML = '

<Root>

<Person>

<Name>Simon</Name>

<Age>20</Age>

<Skills>

<Skill>Cooking</Skill>

<Skill>Cleaning</Skill>

</Skills>

</Person>

<Person>

<Name>Peter</Name>

<Age>21</Age>

<Skills>

<Skill>Ironing</Skill>

...

greg.bull (2/4/2013)

---

Well, thanks. I wish I'd been able to find this earlier. As you cleverly noted - I really want to do this myself - so am grateful for the...

You're welcome!

Curious why you wouldn't want to use a string splitter (like Jeff Moden's) for this:

DECLARE @Word1 VARCHAR(8000), @Word2 VARCHAR(8000), @Word3 VARCHAR(8000)

SELECT @Word1 = CASE ItemNumber WHEN 1 THEN Item ELSE...

Koen Verbeeck (1/31/2013)

---

You use a CREATE TABLE statement in an Execute SQL Task:

Creating Excel Worksheets Dynamically in SSIS

@dwain: you can use a script task to get the metadata from an...

tota00 (2/1/2013)

---

Hi Dwain!

I´m dynamicly building my statement and adding and removing countrys from the sql-question on the fly depending on what filteroptions the user has choosen.

I´m for the moment generating...

Jeff Moden (2/2/2013)

---

That's absolutely the...