Try full outer, instead of left, and you should be able to include an "is null" in the Where clause that will filter for unmatched rows, you just have to...

Sounds like an interview question, actually.

Do you have the tables he's using? Do you understand the differences between inner, outer and cross joins?

This should get you what you need. Just put in your column name where I have the string literal.

select reverse(cast(cast(reverse(substring('05380101010000', 8, 4)) as int) as varchar(4)))

Edit: And, of course,...

I don't see where leading zeroes have anything to do with that.

Can you cast/convert them into a numeric data type (int, for example)? That'll get rid of leading zeroes.

Robert Frasca (4/8/2009)

---

GSquared (4/8/2009)

---

On the "temp tables are bad" thing, the coding requirements for the place I work state that table variables should be used instead of temp tables, and...

Update dbo.Table1

set EndDate = dateadd(minute, 30, dateadd(hour, 8, StartDate))

where EndDate is null;

I think you can use an underscore there. I had to solve the same problem once, and I think that was what did it.

insert into dbo.Table2 (EndDate)

select dateadd(minute, 30, dateadd(hour, 8, StartDate))

from dbo.Table1;

On the "temp tables are bad" thing, the coding requirements for the place I work state that table variables should be used instead of temp tables, and that temp tables...

I'm not clear on where the Flag data is coming from. You say you want to create the data for tableB, but part of that is the Flag, and...

I've had a few problems with schedules that were changed after they were created, not working as planned. My solution was to create a new schedule, with the desired...

Is that in a table, or a recordset variable, or something else?

Have you tried using IsNull on the column? You might not be able to do that directly in the Pivot operator, but if you first use a CTE to...

The easiest way is to take your most recent full backup, copy that to the test server, and restore it there. That's assuming, of course, that your databases are...