How would I create a temp table where some of m columns I would like to leave blank heres what I tried but failed:
I would like to leave the name column blank:
drop table #test
create table #test
( id varchar (5),
name varchar (40),
contact varchar (30))
insert into #test
select customerid as id,
contactname as contact
from customers
I would like to leave the name column blank:
drop table #test
create table #test
( id varchar (5),
name varchar (40),
contact varchar (30))
insert into #test
select customerid as id,
contactname as contact
from customers