select * from assignment
insert into assignment(location_id,assignedtorolename,assignedto)
select location_id,’Pre Sale Manager’,'nd2145′ from dmslocation where city=’Delhi’
ex:
select* into edms..dmstemptable from dmstemptable
select *
into edms..dmsemail from dmsemail
select
l.city,c.business_type,count(distinct convert(varchar,c.location_id)+convert(varchar,c.level3code)) from dmslocation l
inner
join category_transaction c on l.location_id=c.location_id and c.status<>‘D’ where l.city=‘Jodhpur’ group by l.city,c.business_type–25924
