Hi Gopi,

Fantastic answer and Explanation..

good

good

select * into #D1 from (

select '1' as c1,'A' as c2

union

select '','B'

) T

select * from #D1

go

select * into #D2 from (

select 1 as c1,'A' as c2

union

select '','B'

) T

select * from #D2

drop table #D1

drop table #D2

Note : Really and very exact explanation....

i understood very nice...

thank u .