Hi Brad,

This should work:

=MID(A1, FIND("-", A1, FIND("-", A1, FIND("-", A1, 1)+1)+1)+1, LEN(A1) - FIND("-", A1, FIND("-", A1, FIND("-", A1, 1)+1)+1))

There may be an easier way to do it

Oddly enough something...

Actually they are all listed in BOL together as files, so i would agree with the Question. Helps I got it right as well 😉

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/39e00ebe-c9b7-4d53-90bd-15de2015fd34.htm

Not sure if that works for...

I beleive you can also write the DELETE this way:

DELETE FROM KP

FROM

KP.[ADD] K LEFT JOIN RP.[ADD] R ON

K.ADX_TYPE = R.ADX_TYPE AND

K.ADX_COMPANY = R.ADX_COMPANY AND

K.ADX_CODE = R.ADX_CODE

WHERE (((R.ADX_TYPE)...

I don't normally criticise the questions as:

a. This site is free

b. You don't win anything

c. You nearly always learn something even when the question is ambiguous!

But this one is really...

That will teach me for speed reading the answers - missed the (error results) at the end of answer two! So picked answer 3! My bad...

(But at least I knew...

Hi All,

So the question forgot to mention which version of SQL Server you are running, and which compatibility level. Obviously 2000 is now so out of date only us poor...

Hi,

I agree with Lynn.

I'm pretty sure the idea is to introduce you to the UPDATE(Columnname) and COLUMS_UPDATED.

I did a double take on the UPDATED table answer as I would compare...

Thanks Sugesh for the quick reply.

Any ideas what else we could do?

I did wonder if I could use some kind of timer and check the number of rows transformed. If...

Hi Sandy,

I believe you could do this in an activeX script. And add the destination columns on your DataPumpTask.

Take at look at the Disconnected Edit... properties of the package.

(Right click anywhere...

Stuart,

I think you have two options. Both rely on you haveing some kind of key that you can join the results together with.

1. Would be in two parts:

Insert into  based...

Stuart,

This would work (I've included working tables etc)

But the insert at the end works, you would just need to modify it for your tables.

create table dbo.sumtest

(

ID int identity,

Type varchar(10),

Amount int

)

insert...

Hi Peter,

I had looked at using decimal and money - didn't think to use float - tend to avoid it if I can! Nice solution.

Pity I missed what happens with...

Dear Dobrzak,

I am sure you have a really good reason for this, as if the numbers are stored as decimal or money then the trailing zeros wouldn't matter anyway, to...

Hi John,

Many thanks for that.

The funny thing is he'll end up with full admin rights eventually but this is his first moving from Access to SQL Server, so I was...

Hi John,

Thanks for that, but doesn't that also allow him to drop objects?

Cheers,

Rodney.