GilaMonster (8/7/2009)

---

Not possible

For someone to even begin to edit the log, the database would have to be detached and they'd have to use a hex editor. I doubt there's anyone...

You probably want to look at the NTILE windowed aggregate.

For more infor look here:

http://msdn.microsoft.com/en-us/library/ms175126.aspx

Absolutely. It's good to be careful with queries like these, but if it uses the index,...

Steve - I agree, but only to a point. I have no issue whatsoever with a loyalty program on those vendors I deem worthy. But that's the rub...

considering it will look like...

The transaction log is what captures all of the changes as they occur to your data. So - you add new rows, and the changes get recorded in the...

It can depend. If the LIKE statement resembles:

MyColumn LIKE 'value%'

Then it's possible it may use the index as a scan.

On the other hand -

MyColumn LIKE '%value%'

has NO shot...

Well - temp tables are certainly one way... but they're not the ONLY way.

depending on what you want to do with them, you can set up a "self-linked...

Slick84 (8/3/2009)

---

Aah... you know what.. I think I have this figured out. I was trying to update Table B above, I just used AND's in the criteria and then added...

David Korb (8/3/2009)

---

Klein! My lineman's pliers, dikes, strippers, and screwdrivers...

Jeff Moden (7/31/2009)

---

You and I have both been through boot camp... remind Kassondra that it's going to get worse before it gets better because it's a big nasty test to...

The scripts that have been mentioned before are to script data structure changes, and not data changes per se. Unfortunately there is no feature in SSMS to capture data...

I don't recommend this approach, but you can structure a WHILE loop to act as a DO...UNTIL loop.

WHILE (1 = 1)

BEGIN

--do stuff

.....

...

Reading between the lines a bit, it sounds like you might be willing to tolerate the areacode being null. You can still catch invalid phone numbers if you were...

Snapshot isolation is going to prevent someone outside of the transaction from seeing the changes.

At best as of now - you could split up the trigger, and turn it into...