it's probably easier to use a cursor to iterate through your first table.

declare @c1 varchar(50), @c2 int

declare @rowcount

declare @sel cursor

set @sel = cursor for

select c1,c2 from t1

open...

sure there is, the difference is in c3.

Do the stuff you need where c3 = 0

sqlexecute ("inert into t4 (c1,c2,c3) values (@c1,@c2,getdate())

do the stuff you need where c3 <>...

He's an Indian

I think he described it pretty well.

Unfortunately t-sql isn't friendly like that. It's difficult if not impossible to do dynamic inserts statements.

What you should do instead of "having insert...

dude, I don't know why the fool wants to convert it to a varchar, it's part of the requirement on the post.

He has his reasons, they aren't mine. Floor...

I think it's better to use floor

CAST(ROUND(dbo.invoice_line.qty_shipped, 0) AS varchar(40))

cast (floor(dbo.invoice_line.qty_shipped + .5) as varchar(40))

It's simpler...