Thanx from 1+

Never used SQL 2012.

but 1+ as per basic of truncate

😀

TIES never used it

.

Got it right 7,7,8,41,14,80

but thought 7,7,8,8,14,80

but that was`t in ans 😛

OPPs ..

but learn something

Thanx for the question 🙂

Thanx for the question..

i did not go for the catch 1+ 😎

thanx for revision

+1

Thanx learn something TODAY;-)

Back to basic ...

i was looking for catch :hehe:

1+

Back to basic ...

i was looking for catch :hehe:

1+

a nice mind refresher

thanx for question

1+

select '1' as num1, '' as num2

tricky part but 1+

Nice one.

create table #table (Depot_Id int , Depot_Name varchar(10))

insert into #table

Select '1','A' union

Select '2' ,'B' union

Select '3', 'C'

Select * FRom

(

select Depot_Id , Depot_Name From #table

)V...