Quatrei.X (4/8/2010)

---

^__^ Hi there,

uhmmm, i'm not usre if i understood the problem right...

i turn Ben's code to dynamic sql (which i always avoid using)

from Ben's code, are you saying you...

Paul White NZ (4/8/2010)

---

N-way handshaking combinations...

USE tempdb;

GO

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

GO

DROP...

ShippingHeader and InvoiceHeader has FK to OrderID

1 order can have n shippings

You cannot...

Lynn Pettis (4/7/2010)

---

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

---

Lynn Pettis (4/7/2010)

---

It may help to see the whole problem not just a piece of it. Can you put together a test suite including the expected...

bteraberry (4/7/2010)

---

This is a really interesting problem. I cannot think of a way to do it completely dynamic in terms of the maximum size of your combination collections and...

Think of it this way...

You have 4 persons in a room, how many different "couples" can do a handshake.

p1 can shake hands with p2,p3,p4

p2 can't shake hands again with p1...

lmu92 (4/7/2010)

---

I'm not sure if I fully understood the requirement...

But I would consider building a permanent table holding all variations and query that one based on the number of shippings.

Maybe...

Lynn Pettis (4/7/2010)

---

It may help to see the whole problem not just a piece of it. Can you put together a test suite including the expected output? I...

Hey guys I could use your genious with recursive queries in here :

From n items and n groups of items, get me a list of all possible combinaisons of...

Great question Paul.... when included with the script for the procs, it's good enough to be turn into an article...

Well here's an obvious one I hadn't considered... because I don't trace this one anymore

Were you catching the audit logouts events?

That event keeps the total duration of the whole time...

errh what did you understand when I said that the server could possibly handly 8 queries at the SAME TIME giving you 8 seconds of processing power PER SECOND? ...

oralinque (3/29/2010)

---

I've come to the realization that I won't be able to rely on the sum of the duration column for reporting the accumulated time it takes SQL Server to...

min(starttime), max(endtime))...

I don't have a copy of the trace but if you have open connections for a few minutes before starting the "real" work or a few minutes after the...

You can always e-mail me the rough versions of the incomplete articles... might be enough to qench my thirst for now :-P.