ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,561 through 7,575 (of 10,143 total)

RE: Getting data/rows to line up after running query

bkana (8/6/2010)
Will read through the instructions and post back with the samples, stand by.
Hi Bill, sample to help you.
-- create some sample data
DROP TABLE #FilteredInvoice
CREATE TABLE #FilteredInvoice (
invoiceid,
contactidname,
name,
pa_payments,
pa_invoicedate,...
^{“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

August 6, 2010 at 8:48 am

#1203580
RE: Getting data/rows to line up after running query

Hi Bill
Your query benefits from the use of table aliases:
SELECT i.contactidname,
d.description,
d.extendedamount,
d.pa_paymentapplied,
i.pa_payments,
d.pa_transactiondate,
i.pa_invoicedate,
d.invoiceid,
i.totalamount
FROM FilteredInvoice i
INNER JOIN FilteredInvoiceDetail d ON i.invoiceid = d.invoiceid
WHERE d.pa_cancelled IS...
^{“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

August 6, 2010 at 8:32 am

#1203563
RE: Today's Random Word!

dbowlin (8/6/2010)
How do you spell relief? F-R-I-D-A-Y:-D
P
^{“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

August 6, 2010 at 7:15 am

#1203496
RE: Are the posted questions getting worse?

tosscrosby (8/6/2010)
GilaMonster (8/6/2010)
Whispers.
What are circus peanuts?
An orange marshmellowy type makeup shaped like a peanut - a child's delight.
Anyway, I am fond of "gummy" anything at the moment....
^{“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

August 6, 2010 at 6:59 am

#1203482
RE: Are the posted questions getting worse?

Brandie Tarvin (8/6/2010)
In a total change of topic.
Out of the blue this a.m., I suddenly wanted Circus Peanuts. So, what is the one candy that you want right now?
Today's Random...
^{“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

August 6, 2010 at 6:40 am

#1203452
RE: Can I use pivot on this query?

LutzM (8/6/2010)
Chris Morris-439714 (8/6/2010)
...
Chris, please take the time to set up the sample data properly. The whole batch should run without errors, and the column names and types must match...
^{“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

August 6, 2010 at 4:31 am

#1203365
RE: Can I use pivot on this query?

LutzM (8/6/2010)
Chris Morris-439714 (8/6/2010)
...
Chris, please take the time to set up the sample data properly. The whole batch should run without errors, and the column names and types must match...
^{“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

August 6, 2010 at 3:50 am

#1203334
RE: Updating a table starting with the first empty column in a specific row

Bearing in mind what others have said, can you write a query which returns your empty columns in the order in which you would like them sequentially populated? You will...
^{“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

August 6, 2010 at 3:45 am

#1203330
RE: Can I use pivot on this query?

Chris-475469 (8/5/2010)
Sorry about the delay in replying but here is some sample data and the tables with only the fields I'm referencing:
...bunch of statements which runs with errors...
Hopefully this is...
^{“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

August 6, 2010 at 3:16 am

#1203314
RE: Are the posted questions getting worse?

Lynn Pettis (8/5/2010)
Well, getting really short here, tomorrow is my last day with my current employer!
Wish me luck!!
Good luck today Lynn, a smooth flowing last day on a job can...
^{“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

August 6, 2010 at 2:32 am

#1203298
RE: Are the posted questions getting worse?

jcrawf02 (8/5/2010)
Paul White NZ (8/5/2010)
I feel a blog entry coming on...
About time, we've only seen what, ten from you in the last two weeks?? :w00t: Don't you sleep?
Something on chasm...
^{“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

August 6, 2010 at 2:28 am

#1203295
RE: Are the posted questions getting worse?

Paul White NZ (8/5/2010)
Chris Morris-439714 (8/5/2010)
A few weeks back Paul W cleared a smokescreen with a definition of a type of join, something like a 'stick' or 'branch' join, where...
^{“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

August 5, 2010 at 10:19 am

#1202911
RE: Are the posted questions getting worse?

Alvin Ramard (8/5/2010)
The Dixie Flatline (8/5/2010)
Wow, a nice technical discussion on The Thread.
Who'd have thought?
SACRILEGE!! HERESY!! CURSORS!! :w00t::w00t:
Doesn't Rule #9 (not sure about the number) say something...
^{“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

August 5, 2010 at 9:52 am

#1202879
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/5/2010)
Wow, a nice technical discussion on The Thread.
Who'd have thought?
Heh sorry Steve, I'll go out and buy some brie.
^{“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

August 5, 2010 at 8:25 am

#1202795
RE: Are the posted questions getting worse?

Brandie Tarvin (8/5/2010)
Chris Morris-439714 (8/5/2010)
What creeps me out is when I left-join a child table to a parent, then inner join child to a grandchild, with no reference 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

August 5, 2010 at 8:24 am

#1202792

Viewing 15 posts - 7,561 through 7,575 (of 10,143 total)