Article View: borland.public.interbase.sql
Article #176Re: How to query
From: Bill Todd [TeamB]
Date: Sat, 05 Jul 2008 19:12
Date: Sat, 05 Jul 2008 19:12
12 lines
1334 bytes
1334 bytes
Hs wrote: > can I do it in one query? No. If the cost is dependent on the BUY_DATE it should be stored in the BUY table. Since it is not the best solution is probably a stored procedure. I assume the costs and their effective dates are stored in another table in the database so the stored procedure could locate the price for each record as it is being processed. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<486fc780$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.isoc.lu!newsgroups.borland.com!not-for-mailReferences:
<486f7abd$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,19aface1effac68b
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd [TeamB]" <no@no.com>
Subject: Re: How to query
Newsgroups: borland.public.interbase.sql
References: <486f7abd$1@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.9
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 63.147.41.232
Message-ID: <486fc780$1@newsgroups.borland.com>
Date: 5 Jul 2008 12:12:00 -0700
X-Trace: newsgroups.borland.com 1215285120 63.147.41.232 (5 Jul 2008 12:12:00 -0700)
Lines: 12
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.isoc.lu!newsgroups.borland.com!not-for-mail