-- Method 1

DROP TABLE #InList

CREATE TABLE #InList (RowID INT IDENTITY(1,1) NOT NULL, JoinValue INT)

INSERT INTO #InList (JoinValue)

SELECT 5 UNION ALL

SELECT 1 UNION ALL

SELECT 3 UNION ALL ...

Garadin (4/8/2010)

---

Chris Morris-439714 (4/8/2010)

---

Ninja (Remi?)

Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link...

“Know your enema and know yourself and you can fight a hundred battles without disaster.” Sun Tzu

“You never really know your friends from your enemas until the ice breaks.”...

Several random words: -

Sunshine, blue sky, haze, beer, birdsong, smiles, warmth (almost forgotten after a 40-month winter), foliage, spring flowers.

Ninja (Remi?)

Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link table?

It's an interesting...

Ninja's_RGR'us (4/8/2010)

---

ShippingHeader and InvoiceHeader has FK to OrderID

1 order can have n shippings

You...

Wandshoot

Backtracking a little...

Orders (OrderID)

OrderLines (OrderLineID)

Shipping (ShippingID)

ShippingLines (ShippingLineID)

Invoices (InvoiceID)

InvoiceLines (InvoiceLineID)

Which tables hold fk's of which other tables?

Grant Fritchey (4/7/2010)

---

Steve Jones - Editor (4/7/2010)

---

OK, I'm a girl. That's OK. I think I got a crick in my neck from looking down at the rad meter every 3.6sec...

Aah bless, cephalopod romance.

A Scotsman (Tom perhaps) is busking on Oxford Street. Suddenly an octopus jumps on him and rips the pipes from his arms. Falling to...

Ectomycorrhyza

Hey Paulie I just checked your commute time, it's 37 hours including the transfer from Heathrow. Looks...

Paul White NZ (4/7/2010)

---

Please bear me in mind for any future opportunities that might arise :w00t:...

Paul White NZ (4/7/2010)

---

You need help, Mr Morris...:laugh:

I think your mind has been warped by the dense...

Tom.Thomson (4/7/2010)

---

Chris Morris-439714 (4/7/2010)

---

Tom.Thomson (4/7/2010)

---

Oh dear, your sig is a little suggestive after that message. I hope she doesn't get to see...