ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,026 through 8,040 (of 10,143 total)

RE: Recursive cross join to get all available combinaisons

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 9, 2010 at 4:51 am

#1148953
RE: Today's Random Word!

CirquedeSQLeil (4/8/2010)
Enema?
“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.”...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 9, 2010 at 2:25 am

#1148874
RE: Today's Random Word!

Several random words: -
Sunshine, blue sky, haze, beer, birdsong, smiles, warmth (almost forgotten after a 40-month winter), foliage, spring flowers.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 9, 2010 at 2:17 am

#1148872
RE: Recursive cross join to get all available combinaisons

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 8, 2010 at 10:16 am

#1148442
RE: Recursive cross join to get all available combinaisons

Ninja's_RGR'us (4/8/2010)
Chris Morris-439714 (4/8/2010)
Backtracking a little...
Orders (OrderID)
OrderLines (OrderLineID)
Shipping (ShippingID)
ShippingLines (ShippingLineID)
Invoices (InvoiceID)
InvoiceLines (InvoiceLineID)
Which tables hold fk's of which other tables?
ShippingHeader and InvoiceHeader has FK to OrderID
1 order can have n shippings
You...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 8, 2010 at 9:39 am

#1148405
RE: Today's Random Word!

Wandshoot
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 8, 2010 at 9:21 am

#1148386
RE: Recursive cross join to get all available combinaisons

Backtracking a little...
Orders (OrderID)
OrderLines (OrderLineID)
Shipping (ShippingID)
ShippingLines (ShippingLineID)
Invoices (InvoiceID)
InvoiceLines (InvoiceLineID)
Which tables hold fk's of which other tables?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 8, 2010 at 2:51 am

#1148093
RE: Are the posted questions getting worse?

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 7, 2010 at 9:56 am

#1147495
RE: Today's Random Word!

mbricker-600840 (4/7/2010)
And suckers meet.
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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 7, 2010 at 8:53 am

#1147405
RE: Today's Random Word!

Ectomycorrhyza
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 7, 2010 at 7:30 am

#1147316
RE: Today's Random Word!

Paul White NZ (4/7/2010)
Chris Morris-439714 (4/7/2010)
I'll cup an ear 🙂
🙁 :crazy: :angry: :blink: :crying:
Hey Paulie I just checked your commute time, it's 37 hours including the transfer from Heathrow. Looks...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 7, 2010 at 4:53 am

#1147189
RE: Today's Random Word!

Paul White NZ (4/7/2010)
Chris Morris-439714 (4/7/2010)
Heh too late Paul, a new permy TSQL & DW permy started yesterday!
Please bear me in mind for any future opportunities that might arise :w00t:...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 7, 2010 at 4:28 am

#1147176
RE: Today's Random Word!

Paul White NZ (4/7/2010)
Chris Morris-439714 (4/7/2010)
Man humming theme to Jaws after trip to dentist
Berm, beam, berm, beam...
You need help, Mr Morris...:laugh:
I think your mind has been warped by the dense...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 7, 2010 at 4:19 am

#1147169
RE: Today's Random Word!

Tom.Thomson (4/7/2010)
Chris Morris-439714 (4/7/2010)
Tom.Thomson (4/7/2010)
Chris Morris-439714 (4/7/2010)
Quiver
(Janey from accounts just swished past)
Oh dear, your sig is a little suggestive after that message. I hope she doesn't get to see...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 7, 2010 at 4:03 am

#1147166
RE: Today's Random Word!

Paul White NZ (4/7/2010)
CirquedeSQLeil (4/6/2010)
Chris Morris-439714 (4/6/2010)
Berm
Beam
Berm.
Man humming theme to Jaws after trip to dentist
Berm, beam, berm, beam...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

April 7, 2010 at 3:14 am

#1147150

Viewing 15 posts - 8,026 through 8,040 (of 10,143 total)