Posted by Michael.Suarez on 03/17/06 22:49

actually, this:

insert #results (ssn)
values ('322')
insert #results (ssn)
values ('536')
insert #results (ssn)
values ('258')
insert #results (ssn)
values ('478')
insert #results (ssn)
values ('861')

can also be done like this:

insert #results (ssn)
exec ('
select '322'
select '536'
select '258'
select '478'
select '861'
')

• Next in forum: Re: SQL query - duplicate records - different dates - how to get only latest information?
• Prev in forum: Re: outer join column
• Thread view: Re: outer join column

[Reply to this message]