Bhaskar.Shetty (5/23/2013)
You cannot call insert like that, = operator works while you are updating any row or table.
Before making blanket statements like this, I find that it is always best to double-check, lest you are left looking silly in perpetuity:
create table #test (ID int)
insert into #test
(ID)
select Id = 1
union all
select Id = 2
select *
from #test as t
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.