Not any specific reason just want to know is there anyother way to transfer files

Thanks a lot guys for all your support and moral busters.:-)

I have got the job.:-)

Hi guys,

Relax I had my interview on Saturday, and I cleared it. Thanks all of you for your questions, as these questions doen't help me much becuase i have to...

select count (*) from sys.sysobjects where xtype ='U'

Hi Bryan van ritter,

Interesting to know that you work in Netherlands, I always want to work and live in netherlands though I does not belong to Nethlands I am an...

Thanks Grant.....

I will love to see those questions please let me know.....

Thanks for you reply I have tried this thing it works.....but I am looking for something much more smarter way to avoid it as, I have many queries of these...

I am DBA going for an Interview

My Query is

Select B.location, A.loccvg from [db1].[dbo].[dummy1] A

inner join [db1].[dbo].[dummy1] B on A.LOCATION=B.LOCATION

Thanks Pradeep.

But I need some more questions...... anyone out there please provide

Thanks in advance