Ninja's_RGR'us (8/20/2011)

---

Might actually be the case where cursor is the better choice.

Looping is looping, the realy slow part here is sending the message...

If this is not a 1 off insert,...

In case it helps anyone else ...

https://connect.microsoft.com/VisualStudio/feedback/details/331882/connect-timeout-0-connection-pool-timeout

No, at least I say 'no' but it's...

Yes, it seems to be working perfectly with the...

Thanks to all for your replies.

What sort of index should I have on my 'join' table.

Like this?

ALTER TABLE tblUser_WhichUsers

ADD CONSTRAINT [PK_tblUser_WhichUsers] PRIMARY KEY CLUSTERED (UserID, WhichUserID)

Is a Clustered Index required?...

Okay, thanks again.

Narud (6/16/2011)

---

I'm not sure how so good or bad is to perform a double evaluation, but I'm afraid that you can avoid it.

About your SQL code, if I'm rigth you...

lnoland (6/15/2011)

---

sku370870 (6/13/2011)

---

The code I posted is made up - the real tables all to do with medicene and would not easily make sense.

But, to continue using my (pseudo) code...

Jeff Moden (6/15/2011)

---

sku370870 (6/15/2011)

---

Regarding your comments about the PK ... I have always just made sure that every table (well, almost every table) has an identity column used as the...

To opc.three - I most certainly am open to adding a couple of extra columns!

Thanks very much for your help.

And to Jeff - thanks also for your help.

Regarding your comments...

The code I posted is made up - the real tables all to do with medicene and would not easily make sense.

But, to continue using my (pseudo) code - if...

I have just asked a similar question in the SQL 2005 forum and a chap called Wayne very kindly showed me how to do it there.

Link to post

I've read the article you suggested and think I am beginning to get it. I have a Users table with about a 1000 users in it - I'll only be...

Thanks for that Wayne - seeing that bit done on my own data - I begin to 'get it'.

I'll look at your link and see if I can get it...

Thanks very much for your reply. That's a lot simpler and more flexible than what I had come up with so far.