Viewing 15 posts - 7,561 through 7,575 (of 10,144 total)
CirquedeSQLeil (8/6/2010)
Chris Morris-439714 (8/6/2010)
dbowlin (8/6/2010)
How do you spell relief? F-R-I-D-A-Y:-DP
pfpfpfpfpfpfpfpfpfpfpfpfpfpf
Anyone care to guess Jason's religious background?
August 6, 2010 at 9:39 am
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,...
August 6, 2010 at 8:48 am
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...
August 6, 2010 at 8:32 am
dbowlin (8/6/2010)
How do you spell relief? F-R-I-D-A-Y:-D
P
August 6, 2010 at 7:15 am
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....
August 6, 2010 at 6:59 am
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...
August 6, 2010 at 6:40 am
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...
August 6, 2010 at 4:31 am
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...
August 6, 2010 at 3:50 am
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...
August 6, 2010 at 3:45 am
Chris-475469 (8/5/2010)
...bunch of statements which runs with errors...
Hopefully this is...
August 6, 2010 at 3:16 am
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...
August 6, 2010 at 2:32 am
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...
August 6, 2010 at 2:28 am
Paul White NZ (8/5/2010)
Chris Morris-439714 (8/5/2010)
August 5, 2010 at 10:19 am
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...
August 5, 2010 at 9:52 am
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.
August 5, 2010 at 8:25 am
Viewing 15 posts - 7,561 through 7,575 (of 10,144 total)