Hi Daryl. Interesting problem - thanks for posting it

Off the top of my head, here's one possibility...

--data

create table #table1

(id...

I guess you can simply "pad out" those columns. Something like this...

SELECT id, STR(id, 12) AS IdRightAligned FROM SYSOBJECTS

There are a few techniques. Here's my preferred method...

--data

declare @t table (jobcardn_fk varchar(10), Technician_code varchar(100))

insert @t

          select 'jc01', 'TC01'

union all...

All 3 methods use a tally/numbers/value table and old value setting trick, but that's definitely the neatest yet! Well done, Jeff...

Bill - Why do you keep asking the same question in different threads?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=267409

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=267685

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=267396

There might even be more.

As I said, I think the formatting of your question made the request difficult to understand.  I'd like to understand why what I gave...

From EXECUTE in BOL:

G. Use EXECUTE with DEFAULT

This example creates a stored procedure with default values for the first and third parameters. When...

It looks like the formatting of your question made the request difficult to understand.

This does the trick (I think), but I've used an id column as a helper, so maybe...

LOL - I thought about doing it exactly that way, but ended up going the other way to keep things clear. I guess they're really the same way, but definitely...