Post the entire test harness so we can do the same test, Tom 😉

Oh... and do be aware that STR uses FLOAT for it's main operand... 😉

I assume you're talking about adding leading...

nigelrivett (9/29/2007)

---

There is a case for auditing inserts - it depends on what you are using the audit trail for.

If you want to report on full history of the data...

Ninja's_RGR'us (9/29/2007)

---

Sorry Jeff, but I only audit full rows, not columns sot he 5:1 ratio doesn't apply.

2 what do you do about the rule that says that auditing data should...

Outstanding job Steve, Warren, and Andy!!! Yeah, I know... Warren and Andy are on the "sidelines" now, but that group of 3 started this! Nicely done!

Open Query Analyzer...

Press f8...

Drill down to table and "columns"...

I think you might need two roles... one for WebGroup and one for WebGroupAdmin which is where you'd put Tracey. Then maybe do some correct grants?

Simply put, there are more reasons than I could possibly post here as to why you should not, nay, must not store dates as 3 separate columns. The efficiency...

I gotta ask, because you're a newbie....

Why are you worried about reassigning barcodes? Bar codes can be made to easily exceed 2 billion (approximate max for an INT). ...

Hey there PoleCat... long time no "see"...

Is it the goal of this bit of code to update all but the "first" row for each customer what has been entered within...

BWAAAAA-HAAAAAAA-HAAAAAA!!!! Oh, stop it! You're killing me!!! 😀 They don't even...

Transactions??? Why do you need transactions for this??? That's the problem....

A little exuberant on Remi's part... but I absolutely agree with Serqiy and Remi... writing to system tables is a form of "Death by SQL"... you will make a mistake...

I got the following from a fellow by the name of "Jeff Smith"... it's pretty much spot on and is a long winded version of what Serqiy posted, which is...