Re: big sql question (made a link for you)....

2004-02-07 Thread Jochem van Dieten
Michael T. Tangorre wrote: > Well perhaps next time you could post the code the way YOU need it to appear > to understand the question. > I was merely trying to help And as I wrote it *did* help. It helps to make the SQL statement readable. But there was some attachment in the first message

RE: big sql question (made a link for you)....

2004-02-07 Thread Michael T. Tangorre
Well perhaps next time you could post the code the way YOU need it to appear to understand the question. I was merely trying to help   _   From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Saturday, February 07, 2004 7:08 AM To: CF-Talk Subject: Re: big sql question (made a link

Re: big sql question (made a link for you)....

2004-02-07 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: > I surely apologize for inconveniencing the 200 readers. Thank you Jochem, > for taking the time to post that query. As for the gif, I just thought it > would be easier for all...my bad. http://www.catb.org/~esr/faqs/smart-questions.html Jochem -- I don't get it immig

Re: big sql question (made a link for you)....

2004-02-07 Thread kelly
I surely apologize for inconveniencing the 200 readers. Thank you Jochem, for taking the time to post that query. As for the gif, I just thought it would be easier for all...my bad. > Michael T. Tangorre wrote: > >> This link should help someone help kelly >> >> http://cs.alfred.edu/~tangormt/

Re: big sql question (made a link for you)....

2004-02-07 Thread Jochem van Dieten
Michael T. Tangorre wrote: > This link should help someone help kelly >   > http://cs.alfred.edu/~tangormt/kelly.html It helps to make the code more readable (although it would have been more practical if Kelly did it once before posting instead of 200 readers doing it once each), but it do

Re: big sql question....

2004-02-07 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: > I would, if I could. I have it all setup locally. Surely you don't *need* to use an image to show us what you want to have as a result. You are outputting text and numbers, so you should be able to represent that in ASCII art. Jochem -- I don't get it immigrants do

RE: big sql question (made a link for you)....

2004-02-06 Thread Michael T. Tangorre
This link should help someone help kelly http://cs.alfred.edu/~tangormt/kelly.html Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: big sql question....

2004-02-06 Thread kelly
I would, if I could. I have it all setup locally. > [EMAIL PROTECTED] wrote: > >> --=_20040206160050_15165 >> Content-Type: text/plain; charset="iso-8859-1" >> Content-Transfer-Encoding: 8bit >> >> I have a query, and I know you want to see it, so here it is: >> >> SELECT dbo.ClaimsHeader.

RE: big sql question....

2004-02-06 Thread Andy Ousterhout
I have a similar need for timecard module and I use loops to create totals.  I have two loops: loop through employees {     zero out pay period total & weeks     loop through weeks { total hours for week total hours for pay period     }     display row for employee } Hope this hel

Re: big sql question....

2004-02-06 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: > --=_20040206160050_15165 > Content-Type: text/plain; charset="iso-8859-1" > Content-Transfer-Encoding: 8bit > > I have a query, and I know you want to see it, so here it is: > > SELECT dbo.ClaimsHeader.InvoiceNum, dbo.ClaimDetails.ClaimID AS > claimdid, dbo.Cla