Wow!

Just caught up from when I posted yesterday... That is a lot of posts about books...

Probably missed the boat on most of these but here goes:

Dune, I have to say...

The Thread is also a little bit Skynet!

Maybe it/ he will transform in to every scifi computer system/ cyborb...

So long as it does kill the rest of the crew, sorry...

So either Steve with a list of people receiving their refund

Or

Jeff with his role call of pork chop inductees!

Rodders...

Steve should have the honour of posting the 1,000 post 😛

Rodders...

Wow three pages of replies since I went home last night - I must be in the wrong time zone...

On a different note -

...

I liked this from Gail

This is not the first time that you've criticised the free help that you're getting here. If you want a solution to your exact specs, with...

I agree, I was going back...

I'd just like to add my thoughts about the Reporting Services question...

Assuming the OP and bsrlong aren't the same person, and it's not some ruse...

If I were the OP I'd...

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...