Cause I am tired of the personal attacks for the most part.  It's gotten to the point it isn't worth debating with some people.

url: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=383658#bm385709

Give this a try:

create table dbo.MyTable (

    JobNo decimal(6,0),

    Status char(2),

    TransDate datetime,

    RecordId bigint identity(1,1)

)

go

insert into dbo.MyTable values (1234,'AB','01/07/07')

insert into dbo.MyTable values (1234,'AB','02/07/07')

insert into dbo.MyTable values (1234,'AB','03/07/07')

insert into dbo.MyTable...

What is the recover mode for the database?

You probably need to use dynamic sql in this case.  I was looking at BOL, and was curious, what if you try this:

in ((select @isps))

It would help if you could provide the DDL for your table, some sample data, and what the returned result set should look like.

We use the ExecuteProcess Task to FPT files to an MSP using sslftp.  I wrote a cmd file that is called in the Execute Process Task that uses a script...

And it is starting again in a different thread (and no, I'm not getting involved).

You will need to ask your friendly DBA to install the SQL Server 2005 client tools on your box (or where ever it is you need them).  If you have...

Try this:

     SET @QRY = '

           UPDATE

                 tblCR_MainData

July 26, 2007 at 2:52 pm