Hi,

I think we don't need to give full name for the column names. so we can give

DELETE FROM [SD_Order_Dev].[dbo].[ProjectDemand]

WHERE ProjectNumber IN (SELECT Projnum FROM [dbo].[CADFilepath]

Also when you...

If i take out the go statements will they be executed serially or parallely. I mean first I need to truncate the table and after it is done, i need...

Hi S.Krishnan,

It worked. Thank you so much. I appreciate your help.

Sridhar!!

Hi Srinikrish and PhillCart,

Thanks for the reply. In the excel sheet, how should I qualify the area as table1? Where should I mention the datatypes of the columns?...

Hi PhillCart,

I have tried using templates. It is working fine. But now I have another problem. My excel template has an image at the header, and below...

Thanks Phillcart, I will try using the templates.

Hi,

May be You could try like this.

DECLARE @defaultString varchar(25)

DECLARE @countValue int

-- you need to keep this inside a loop.

-- I do not know how to keep it.

SELECT @defaultString=left(forename+surname,20) from table1

SELECT...

Hi Steve,

  I tried this. select top 2 * from syspermissions. I got the following values.

1 0 1 1 0 NULL NULL NULL NULL NULL NULL

2 0 1 1 0 NULL NULL NULL NULL NULL NULL

But I don't know what is my uid? how could i find that? I want...

Thanks Adam,

   That worked.

Sridhar!!

Hi,

  I looked at the article. In that aricle they know the column names before like Q1, Q2,etc but in my case i have to get the column names from...

Hi

Can you explain clearly the meaning of overlapped date range?

Thanks,

Sridhar!!

Hi,

   I have also checked in the BOL and MSDN website. there is no such method named ListAvailableServers(). The method name is ListAvailableSqlServers(). Please let me know the correct answer.

Thanks,

Sridhar!!