@jeff,

Thanks! But all those smileys have left me emotionally confused 😀

@Halloween,

My entirely personal view is that if someone is able to talk a little about things like...

Bob Hovious (4/6/2009)

---

My sincere thanks for stepping in and cleaning this up. My new resolution is to never post anything of substance if I'm too tired to either...

Thanks Jeff - and you too! 🙂

@Flo:

Yes I've just seen it (the cascade)...spooky!

@Kruti

I'm going to assume the results are right then (your time zone is GMT +5 or something?)

The 4ms timing difference came about, I imagine,...

Nice solution flo!

Typical developer - a code-based solution 😛 😀

...while the DB guy hacks away with cut and paste :laugh:

Yours is great 'cos it goes all the way to 100...and...

Good luck with that, 2cams! :blink:

You didn't tell us what the input was!

The 4ms difference is odd, I...

Well I was 100% wrong!

Cascades do not have a limit of 32 levels.

@@NESTLEVEL is not updated.

CREATE DATABASE [BCE86EC3-7D5C-4D73-B5BE-D9295C7C0CB1];

GO

USE [BCE86EC3-7D5C-4D73-B5BE-D9295C7C0CB1];

GO

CREATE TABLE A (A INT PRIMARY KEY);

CREATE TABLE B (A INT NOT...

Hey there,

I'm going to assume you are asking how many times an action (DELETE...

Hey all,

The DECIMAL needs to be (4,2) because the precision (4) includes the scale (2):

Apologies to flo who posted at the same time - but I'd already written this so...

Bob Hovious (4/5/2009)

---

Oh, one more thing about the bit datatype. I rarely see a simple active yes/no. Usually it is a "status" column and (A)ctive...

Well, according to my faithful weather widget, Colorado Springs will...

An alternative method (albeit less satisfactory) would be to define the UNIQUE index with IGNORE_DUP_KEY = ON.

Another method would be to use WHERE NOT EXISTS or the EXCEPT operator.

Cheers,

Paul

RBarryYoung (4/5/2009)

---

Well that one was no assumption....

Grant Fritchey (4/5/2009)

---

While that does allow a single procedure to act on multiple tables, you're still only getting a single table per insert statement. You're just rigging the insert statements...