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 helps.
Andy
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 6:01 PM
To: CF-Talk
Subject: big sql question....
------=_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.ClaimsHeader.ParticipantID, dbo.ClaimsHeader.PromotionID,
dbo.ClaimDetails.ClaimDetailID AS claimddetalid,
dbo.Transactions.ClaimDetailID AS tranclaimdetailid,
SUM(dbo.Transactions.DollarValue) +
SUM(dbo.Transactions.Bonus) AS mytranstotal,
SUM(dbo.fixmodels.DollarValue)
+ SUM(dbo.fixmodels.Bonusflag) AS Mymodeltotal
FROM dbo.ClaimDetails INNER JOIN
dbo.ClaimsHeader ON dbo.ClaimDetails.ClaimID = dbo.ClaimsHeader.claimid
INNER JOIN
dbo.Promotions ON dbo.ClaimsHeader.PromotionID = dbo.Promotions.ID INNER
JOIN
dbo.fixmodels ON dbo.Promotions.ID = dbo.fixmodels.PromotionID AND
dbo.ClaimDetails.ModelID = dbo.fixmodels.ModelID LEFT OUTER JOIN
dbo.Transactions ON dbo.ClaimDetails.ClaimDetailID =
dbo.Transactions.ClaimDetailID
WHERE (dbo.ClaimsHeader.ParticipantID = 267)
GROUP BY dbo.ClaimsHeader.InvoiceNum, dbo.ClaimDetails.ClaimID,
dbo.ClaimsHeader.ParticipantID, dbo.ClaimDetails.ClaimDetailID,
dbo.ClaimsHeader.PromotionID, dbo.ClaimDetails.ClaimDetailID,
dbo.Transactions.ClaimDetailID
ORDER BY dbo.ClaimsHeader.InvoiceNum
There can be only one invoice number, but each invoice can have multiple
claimids. For each invoice I need to only display the invoice number, then
with each claimid that is the same, I need to group that together and add
up each "mytranstotal" and "Mymodeltotal". I have attached a .gif to show
an example of what is outputted. Would it be easier to try to accomplish
what I need to do in my query, or is there a way when I am outputting it
to say "if the claimid is already defined...don't show all records and sum
up the dollar values"?
Thanks so much!
------=_20040206160050_15165
Content-Type: image/gif; name="results.gif"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="results.gif"
R0lGODlhDAOGAOYAAAAAAP///4I6W5xIdGEAN3QASDsAN2EAW3QAdEgASDsAW0gAdGE6enRInDs6
ejs6WwAAdAAAWwAASAAAN0hInEhIdGF/rwBInAA6enS//0ic32GcyDt/rwB0vwBIdABflpzf/0ic
v2Gcr4K3yHS/v0h0dJzf33ScnL///9///ztfW2GcloK3r57QyGF/errQyJzfv7//357Qr7//v9//
357QloKcerrQr7/fnN//v563errQlt/fnP//v///37q3etTQltTQr5x0AIJfADs6N55/N7qcW9+/
dNS3ev/fnGFfW9TQyHRIAL90AJ5fAGE6ALp/N9+cSP+/dNScW5xIAII6AJ5fN790SN+cdGE6N55f
W4I6N3QAAGEAAEgAADsAAJxISHRISICAgP///wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5
BAEAAGMALAAAAAAMA4YAAAf/gEuCg4SFhoeIiYqLjI2Oj5CRkpOUlZaXmJmam5ydnp+goaKjpKWm
p6ipqqusra6vsLGys7S1treUYrq7vL2+v8DBwsPExcbHyMnKy8zNzs/Q0dLT1NXW19jZ2tvc3d7f
AQEA4eTl5ufo6err7O3u5uPv8vP09e/x9vn6++z4/P8A8/kLSLDguoEGEypEqLBhQIYOI+oDICad
oHG4TGHMSGojR1EeP4IKKdITyZKcTqLUpHIlJooWl7R0aekkEgcvJt3MSWjnrZk0KQENKskmTp1H
Bfl0tHRQ05QBND19NJXR1KqJhsbC+jIqqKtJI3EVWhHdRa9fAERoITbsISRf/zgodevKKE+ndA3d
/BF2bF20ANSyVbTzqV9EhdNG0JE28IaRgAVnKpy3EFy1jAMDeAzSa0+6h5tWHe2A793DQr2iTgT2
LuK8pPmaxut6kdbPtdvmXkJ6d1dBXz4McoLBN1XQOLH2Tln23Nm5xi0heZBlBO/Kq+wirb1a1caj
U4oTxk7JJ+WccDl3+p4zfHSm5PUmP5q+s/z3r0/D3s89fqWN3b3lX373EYjbI7fRJl1ly5nkFXXW
IUHEgIu0phx/zMUE4HxDOIaEAmwBcUALl621ExBdeJjWBCPcZIRwe9FX2gNPACBCFZuVshGKgbmA
ExSBsbgXjTbi+NhlAGBgGv+S4tnC3hIitgAkAEI6MEQEMuAIgAo48QiAjz8QmeOUVXa4WRBacnAe
dA4KcpSIOlhpomIkEnljjiW2gGZgXL6Q501mHjkfTwEW5ZWXPr5AZosz1njnkY0Vx6SfK46wJwAc
LBojpYE1uZ5XWnJ5pZRBMhoolCl++WOpQzpqJG+RcsripZmyWtqtnCaJ3yAb2Wkkmo8BQQALocpJ
KpWmOrbElBjckGaetGpKoaFuFiGXEz46GywBNviKJ52wdioro84Gpiad0dq6K4LNmfPcdZQ+5p4T
8n6A4mNQfHCTtoJEeZ1p9G76rwEjTMGiex2ByllTU+hbGsEGF4zBDl0Iyhf/xYKum8qTUHjacH3w
7lvFwg9bN8Vag3z8hbySyuhnUv5+6mZOHf+wMqr46gvxwRNXvCyM82H8c33urQnliKFsNDKbgnxc
csThCX2T1A7sgLTRTTt8sc+FIqhacjcTojLL/MKbstY7S0y11WxhvYTTslXN9bQyeZW2ew2/DXS8
hYz9tpIgLqEFiV36nK/ZZ3ftyHdWx2la3h/f3XPO917H9r+DVn74U05r3AhMZtUNnXk45W0Fo+gp
4HhSSGI2X9zo4eo2ZDOPHinslM0Wo+50o7JRrOEmOVvIuM41m7At3u4y6S/zFDNUwInLPG+qDyrw
h4S/rHv1sTe/1PNtLsE6/9id4v66jLzbrJmJ9CkPO+IyE0+o8rEPn1j5sp9ff2OCmef+rbzTGHvO
EyV6yU8p9LNcF1B2QOz5D3+e89rMnLCZE40oYNYr3ofitL/1cXBNDmwfBDMUug01D15BEEANGHDC
DRYPfj6BApjQl8EITuJJA4sQADOYPg327hQ45A3BMEco/RnvTdwa4vUGdUD4bSKI03Oh9zQIotzR
h3vyW4riJCi+Iv5AiTucYg/r55bCgDFuAfyECc1zRhp6sY1LMqLAaIMEOIbRibbxSg2X4IQVXI2J
ddRhGlHEvhZWMTlttOHn9OinQ+akjyM6z/WwOMcsXjF7gSQiCZ0jugYeBf8KSpCL5hxWtsqxCUWA
Y0vN9jgKpZFsNquM48t2QADrrJKWtvQULaD4SSWx7pBlE1h4YOnL7mHvgKaMX1/eZDiHTVFomzsk
NJ1pyZwkU40KOyLNfCnLqdVyWRP7ZseE5hRHgjNuuASnIhkBIHPGsJjXCWbxYpnBdI7TZ+XM3jl3
aE9d5nFmIIyLUtzZy/RZYAlB2EKLQDRK6ulzlev8ZxcVBBe5SFJulBPn5OjI0GY69J3DY0m7yvEu
xXDQbMcMVyGRtAEmDc89U+JSN394Q9U0JlEU3FIYzzMFPuGqpzqNqH0mOhyfhpSCfUISmBqDspzK
1GV83JJJG8Mi2hEVcX//qmGeBIFU8hXyX1MtVStt2iOcOHWngwJqn9RKPl1FlQNnhR1bhZoVz3SV
J3Fd3k3NatT8NW+uk3prXuXqUwEyck0JtQ5Xg7pYnfKOYuZa7LkkI9i+0hURvMxJYqu5VcAmkIKT
ZSBo83pZQoCOkwkiyiJVyxLPbGKL3nEta/8j29nW1LaXGArCcHsI3fqTtxcZKTneBVxqFde4nIDt
xmp7XHYyt7mKSC10O5kIA06Xuoiw7nRPCw/NePe74A2veMdL3vKa97zoTa9618ve9rr3vfCNr3zn
S9/62ve++M2vfvfL3/76978A1q9wywERiRh4Hks4sILzkeAFO1geDX6w/4TXEeEJW9hdF84wSTXM
4QpzeMJLGLBXCvzhA3u4xA4+MYoVrOIVG7jFLo4IjGPckBnTOCE2vnFBQqwhHbPYxyYG8ouFLJEc
E3kfRj4yg5VcYyYrhMclJEcPuBCYDki5ASkIhxQCo4EATDkwEgBBOHqAZSVH+MsQQEE5mnCBFCTB
C1x2MoXJ8eY4B2DLAOhyFLxrZTmbhRx71kyf/UyPM1MZAFZGs5rrnOcA1DnMhI6KlA+daCqn2dFw
bvSjxUxoD5M5y4qOdDs8XeZQi5rCIj6LljMQAB+AQcx7bvOdLz1mBKgZ0ACQ9ZEjTAVWS0HXTSgB
BVIgBVb3oACcPrWkV//tZWRLgdbmaEKXlb3saE+b2uyIcLFb/eomsDoKVt72sU3w6jvrWs7aZrWr
QeDtAID7zsYuALnF/Oss+7nCsc5yu9+NbeeUI98B2Peg+z3cVNfNHD2wdTiSMOwAXCHZXlZ4ORhu
byJHWOEJV3MUNEBxcqwb2yde98PRkYQF3FrZJy75yQn+Z4QjYAYK73g4XD1vRzf83udIOMwXfXNu
11zm6DYHxTNu84qz3MNDj3nPj25wf/iACtAe+qEBYOxDXxvoQo4wsrkNgo0Xnc5LF3XKKZCDqbOa
HNLu94nTznJ1VPjpaSY60Rc+7C9DutPlgDsK5C7xotsd4k5Get0x3vf/owt98Gqee9uhjNqcb93v
MTe5lB+PdSBHmNEQiAEVvCvrYwNe7AhHNtFVvnDJg1zopm97y8txbBgQ/taeD3gGnj7wwDve9YmX
eOy9TftICz4FfF85wX8ffNVHpenoaDfk1fzxmZf767s+B9A7Hnu1s37rRG8+20+/5msbH8PnaAIJ
lA7qrXe8+UEP//h5Xn4xn//56Qc78MlvfOLTX/WMd9fBA4AFMVe/42mncttGetBncebwdN5HcUmQ
AJ93apfHgGjXZaRHgNxXesL3feEQYf3XbOz2bVa2gJw2ZaxGgbYXDhvoeQLnaBDoZVwwgqlXgvIn
e+5We8N3ePrmgd+X/38ktX94RnXhEGhU93QAAGmMdnZAeHZZRw545n1FB4SNRm0R5oQaIISQhoCG
N3NUwIQYmIFKqBlVBwCXJoWb5ntdGBhfGIbexXFwdnc4h2tmaGr4929eCIeLh3xbmG13iId56HZ7
yId9uHp/uGGBCH6DWHA9VojDhYiJqIjVhohJloOM2IiF+Ij1J2KacV2YmImauImc2Ime+ImMIGLh
QGJ5SIlxyIimuHiRmIpXqIisOHx26IqrOIuoSIuyWIuoGIuOaIu7iIu3+Iu96Iqx+GWIdmWgZmkn
92mYZmcGOGbIyIJVBo3QhnJ0lmnTtoTuxmcVOIZ7aGjRGGqM1mXEyP+GMEiMlQaGi2aN0DiEDdiM
6xhmdNiK4wgC8QiLhwhvXJeNbfZ0viZrACduj5eE4dBr5kZs6gYGJkCQ9VaBAAkCz3aBAaeFeBcO
5baQpaiEB9mBM4iPnqd4E4mP65aCDemRbRhxJ5eC9SdlfYeS+KeLtXZrSZd7MLl06Gd55PB6Krlz
JlmBHvdqIyd9Lwh6FOl+YQeJLqeTQLduJBl/OXl/XLeU5ah7TimPUsl+lXiPrQZ1Jzd0W9d8WFd5
OqZ1YvZxehd7NSmUE0d2Ztd91ueM7NiHb6eVxUd3wGd1ZOhxcomTdEmMEhl9bplnc6mKf6kBgcl0
WDlmlNdwmDeTFVf/fe64mJMHApAJhaFHj5EHk0GJlrxHBTRolNeHezvJgdfXjgL5mXrpmKJZkpMH
mlBJmaHHmoVnj1EWfmf3lTcnc6hZmjGIdkgIlh8pmtn3fNvnmgHQcGfpmWu2fl+Xm8fpl9GmnNQX
kM5HmjZ5gGAAmr5JnD2JnUUJcrF4golZcVZIlypInTTmYVYInpw2nsQJghHoaJJHgtQYDi0InxB5
ivznf8iWgu7JbPJpZuSgnvy5gvj4n845gCbHkoJZoAmKg1c5m3fmhT/ohdg4oWYohQdqZz3oa8xI
nFJIhWOZha3IjRepZRIaamKYaUgYfxsqjRqXhkV4l8vog/XYljN6/4b3CYUuOYivaKPB+KOTyItB
mouHyaNCaqS+CKRICoyTaImBAYpQGqVSOqVUWqVWygmiKA5HGog9ypNDyqRLqqRcuqNcuqV/2KXa
+aVieqarSKZsmqRqGqdhKqdlSqQQao4zKoHqiHZtRqK66WVlFqGapo7z+JHhaKKN5oSdWZJ+uoVr
12ahFqmHRo5MNmNvNm0MxwO3SQGaam/ZeZ7rcKl016mjuqlGV5156qI5GIvbtm4N2ZDhEGwUQAMV
eW6oqo9Z9pAYyYGtCaDM5nm6Gn59GX+1eqrIGXDCRgMK2WYp2KvOiXANwAMVEAZESao2Z61JOQA5
2mHpQGbSSq3Xuv+p2NpzPqCtYbmrKOigLVmkiod+H7dxDEerRGmsN/Z7DteAShmbTDmdP4l621qp
5FBun9qK7sZxZEd4SIl4DngOesdwR/CBnCqupsp6XGCrKBZyWumwEDuu42p0U2axJRZy1zmVstl4
eDmN0zdsXid1b/msfreW8seXMgp2ZSeh71mBfweXgCaBZNeVIyuTMvubAXd3FOdtmSqxnlqUb7ao
GeZhTUC0w2a0EZu0HSt9XsC0FzZ2OaCXdciuj+eYnieEmnEBQjB7nOmrMXuZiAlxuYm2azt6pmeg
H7mZWNuKmze2PJBpEKCTite2zimCaelmEcuxE4sOwRqyk7aiCjj/uEhLnoY7jdw6moVZsvrHEO0G
ttIZrlnWnKAauMGpn4DHuboZe58bq8NaksYJf44qfT3HcFtrldMptE/LaR0XBScwtaWatMa6tDHm
tFCbZbaLu5rruBN3tb07mjs5sGL3naDbn+XJumXngv96sTYYkfbpvAg6vfVKZwQagPGZmWhZn3K7
oLtphSIpvUKblWlGfRWbA48HbjKHdR9Lr5GbdxnbcB/rvpwGv4XrjCD7YQ+YbApqmBDaolKIoXTZ
qD6Gb14IotmoGWpohjL6oZtXhSJagwu3huaJwYFboeCoojPLetF6c/XGaH2qtzigtyhQrtprYS3m
rSR8woEhw2CY/8KBkWYsfK4WymU16p1FWqdgCsRrqrNwOqc86qZEHMRvqsRJPMTd2KbpcIlXOsVU
XMVWfMVYTBRZSop3iKbzycRPXMRCTKdnisRhDMYlisZdbKZN3KQ/vMROnMZxvMZiDMdufKeUlqp4
qqgKrMPGiKh6qqEdCoOHKqh6po3tqcFtHHCQ+oySio4hLHRegKnCe7S667ZWS8mEe8nOeag9rKP3
2Kqv9qoZuWYhUKzP+o/Q9qqQy6Lx5pCtbL3EicpyjKyzuqwpIHD8WJDpO2bROq3V2rgFmMPbiw7e
CszDm8zZ2sIghq77qa5dC6EqeXLop3glFwMC252dG4P9mnc+uf/Bf8p13Uxn4FuS2Uy/5AuvB5t7
Cfu6obmv6osCGqvMlbx087vNJyvPFPCw9Fy1k/a/9budJKt2uqh3gRvPbJmzLsuyEkyzMKuadFez
DW26NqrQabyyPTuWPxtxM+Cz4IzPQ0u7UZsBlpy7xFuNddvMa/a7UrvJJ53BKS1hWsu1BGyyyJua
a2uBstd7C62wBNiRagvRQL1ocVvOJUm3SXy3M5y3N8y3tjaZ8Qe48ne0Ll2A5nC4AJy4gUvVwpyd
WB3QvErTlLuDlvvKtEnR7/fRYB2T+Ui6Cie6t+rWzCecpxt/qavWC1u9Ee2UyuvHsfq77na7VQ2W
vOtivivSwCv/2F2ttMZr2Mg7etqMcszLgc6rnvbJgujrjuTpvfLcvRJo1KjqvJx92TYqvqDNweUr
oizJnvDcsPjbvu/bAfFrzxWLzk3LsPd7jBegvz8o2/3LggCtYQHMmxv5oDZtwGnYouzZx8W8w2b7
lhTcsiUZ3RZc1/HH3Pgpfx78jBXay4BqrSWcaTQMATaMjsQM0lcG3jQ83uWNw+ba3FL4yZL9xos8
xkZs3/htx/ddxvR9xnO8unVc3/qd33DppACQxQie4Aq+4Aze4JOwxWzs32Qs4BQu4ftd4P1dyxdu
4QTO4QP+4RguzRPu4RWu4R1u4iDejcOYx56cx3ysyC6rjIac/6ozbqh7io2Kuo0wruFsVpeQ/MHS
Dc/Fq8mLbduOrQ6i2s+/HdqE+ozGXbm76qqvLMoQ1wSnTG/BfeQTKmuHy8rM3NxennzW7Zy0TMdo
l6y4rMtlDoPQ+q3BTLX9e97Ha8y/DK4lTc/i+d7b3JADPNbDtX/T3JPJZs0LgM3z2tNZNs78itfN
LeiKTtpffM7+rc7urHNKJ69WDbAHeL/8fOeeTttZnrW4vb77vLFFTrGh7sIMu9F93WkFrZUHbdDv
adF/ytA+6NA2C9E2J9G3TtE4S2WUioFRyLO87WqwuXfAzugrdth02dKnLskx/WDMXnTODuecXLzR
nmLQK9YE7f+1ISid/yd5SI3ocAt7ohfU+zrUpD2+8TfuaazUucbUYOjUKODuUV2fU8241v7SShjL
ou6MijtsXL3vmd7vXz5kksvtPizisWrW0XZ2AXjX5P7W5SbX+aiaFq99Y462Eq/hKevOJQ3XCxxt
gB28g83Y2b5g0167ik3whN3Yy/7YA73wNq2elQ26lw247B7zB83Zov3ZB0+9C+fZl73zMGjaQZ++
Mme+Hqjzp+3XWEjqus3bMzjbHlvb6O3aUx/bVo/qRq7qQy/A0FzTUI6oPiiFyn3Byxjsfn2EDkzd
yi70D8xlDszaiRzkAN7BdgbkbO+y6R3DbibegX/D7b3Cej7/5zk3wvYW3jM8+DWswnKu5fHt5OvK
8Cdu5v8t7BGO4iXexWbM+SQe+qA/+pg/4qVo4A6e+qq/+qzf+p4I4QEu+qW/4aSf95m/qhk++5dv
+6av+yle+8L++b7f+bxP+8Mv+8U/pveIpy0ejS+O9yMvwosfZ4Xc3dd943GW43ff99kdq438405u
/WyeySaN55gsyUTu8pGN+M3v76BcwBlJyhcfq1fOy5qtyicX5mip/9YGCAGCg4SFhoeIiYqLiEuD
YCABUhcpjJaXmJmZjoRNJRQ0VBmSlE2jUR2SECiara6anIY9DTwVYZFJFDwUlQG5u725vQE+A6yv
yJixhbO1/7e+uryCv9LQw8XHydqKsVKjPQUgpgGo2+bnhktijUsAsgjZPpCDPfCDSQsx88Lo/YfL
1gJciWRIHoiB/hJaAkgMEkJD+LIpnNjoEa5qFDPCIhRFQ64c9urNsCfsoUaNDH1QWZXrSCpqwaLF
HBagBxdKJ12lXImi5UuZ04AGpHeTZs5LKcHAIInxqFN17NwNUrmKED+qEptoqMkFgASCTpMBFGYT
gNlR9yjk6Ho2rD+GH9kCQCtIq9uMscp+vctXUKyO0HKEa7iUlUi5dPuKLdRkrzVTMIMCC2rUl5dU
iit2ciwMstDIQ61ezqzZqtqQ9khPhPqvnazBNWELAkcwYv8AUyoxq15YiCzJBcdo12Nle3crgMJ/
HytuXFss3FR0N6cYi4pZsxd4eDELYaRhBN59AZ++iWhiYdQmQ1PP75CUqs3zcjnPK3010O0NvZeo
Gnm44TWlRp45rKXjmiHj0IYgWnZdNc+A//TGC4AGxRYJhQ9CuMgyCmJIkF0a6jSINBWG2A9cGH3E
FEislGhiaXVxJk0UJ3xmY2VJjEYeQI3VNmON7N0IkY7TcTgYgPm9eNw6rUkVABYXhpNEAmBBaaF4
hs2HpZJ+SVhJg8BNCRaY/HHZ5TRUDkLmlmbyJoiWzLX5Coq9qLTVOOWsKecgO7EkjU0XCEYQKu0l
CWhlu/X/2dOfNwkqCKH3NXUohLGIqeYp0u3JSIGFLHGgJNedch0AGkgRKjFUbDXNdo5xuUwUoark
VSSwXqeBrK1q+teot1q3l52abngPq2AFu5GXppI6W1dV4VrsngzNRks1k6SQI3bWbgcABDhouwo2
IUZb07S9VHstAJScy623KICr4a62lgWfsRsyaaCT9DqXL4H7biNuv8oAvJjAcxJcsMFLRoXwcQsf
2zBSDwccsZsTC1uxxRcnwikh13nq8ccghyzyyCSXbPLJKKes8sost+zyyzDHLPPMNNds880456zz
zjz37PPPQAd9s72H4JtxOkdrnDSMS/PZNNJPE/Lv0VNn/7wxn59GHUDVF3NdsdcTgx2x2A+T3bDZ
C1/tV9ZRo42w2wbDTbDcAtMNsN394r2v2lt/WhYAL2m71d+p1GpWB9fm+iJyDZRr1lbnqpqsqsFW
Krggk5Mzaqb0Wj5r0gw1QYm8WW7LiuGAGzt1jqriJ6SZq3vRuo1BIvrusI9zZfrYREv9qTcNgQA8
bcC7eFsI81QLO0foVrLfIMOH83y+3Xwj/bydUL63RaTYnjZjn4QySrV4Zgqirog0Y8tFQdY+lTHh
pk/L+utF6r4g7lIKvfXiYMq7wswQkIsANI187KMpJhqLNExCCIMwUHUFccizClgmCArigN57G0c8
cprvhP8nP3GSk6J8Ur+Y3G9ZOBnQCCngkhJKJlI0mZQKI1iY0Lytd1jDF1ZMU4kdqmlwXVFcAr30
t7mYZi2nsuAREZO9uRHlc1QbBGA+Mhh51JCAt9EetBgjoxR4pn0wHBLn+sNFH3kxA6474bDGSBoU
sShAFbwbDtdmtCvZcTawsQ102Kg/HiJpPBb6YxyV5B8QCJKCTqxLBnIDukFY5zrZ8VZ4CBhCEZqH
h/YxYRjdgz0yLos+1ooGGGeCiOkZp5AAwuINAcgY/i2oLpAjUYYWR0R7VKhDtpylJelxpFx+SIvb
E4QsJ1g2iKSog0M5X+XKSBlyAMl+mxQNHxXDoy46k3b/0VzjDHl5IaZkkHpz7JuTrEQbSwmCnIOx
jU1GUcnb8TCLWDInPNvpqnukCZZboqcS4QTIrhmzTqm6jf/YpMSp8IQfgHIUORCXTRnuqCAHZVSg
YAMpUhIlhQ9F05gGerZwespJyTIi6kp1KmCtCor1lGKsfEUrXjmrcyq11UtNmkjLoNSfyMqd7poV
UOrJTz3m0la6vNUt7rQLfu6UBbkwN1RsqauopsvfNjUXL2YNMm8eZdvT9OZTrZ3Jq1yFqVe3Nlay
jpVvHy1rWAvaNrW69axvBWs4Oya0utr1rnjNq173yte++vWvgA2sYAcrs3AKoo5NW+sy4cpYsMZV
a4rV/1VWEbu0yG6xsZB9bFsx27bJanarn01saCs7WtB5dlmH013q/vYV0u30qhm1qbLUhFHRZUun
i5Wt5HKHumnukh6N0+3YcLcXwr32uEpM3IXYkgrXulaJz7XaEzsZttNKYhQGKR4kCKiS8ZWCo4Tc
nx09UQ3ypiB6xEzpdS1kyibejXk4QW8xLxiJamm3fwvtbveUmDxK3Ld8+lVebkWxX+kKgsAC7pp1
6SGg4RAwleDx5vIKUaGO8MPCGDHeb6ciwUPo87JpoYmGa4pBBn8Qmar8bYlnE2HioFhAIEYNbGsq
Y6ot2Ic7/JsGFGTFGqs3xFPkRZCHkaQNBwWJbflhTf+bGeL56s4xWIHwDKqoyzbJB4pRRs2UIzHi
CQeAyun9niDAbGNWcvPMeASBuiYJ4yESgjayuo4HmDAqnCiIrckhDiA/DGIm31HMAmUkL68ID3XN
OKl7fHMBCN0TdiXX0QaWLXXLtuBLdYIuLlKRi78ZH0U/C4R/kk1ur+QhfC55KHd28jA7QQIJ+xnE
q1ZTqzfd5FG/Omz/LHOTBoFOEPQaeMUBVvmsbM8Jgtpa9xSrL5K9Jj73OSDydDI/UdDrYeOvp7md
drU5SlP0NRDbODUoMP+3a8ydKqTs1Nb4dBrd8D6KV7W2xkiVONKZgvu9MZ3LvM9G3PqeyrWZU7Zy
QdXhFoDjNrcBj6K5Z6vre5VW4Y7lLGglLtqzVnriEc94ZilOWo6bFhF0JazIR07ykpv85ChPucpX
zvK6GjYAlG2kxyG+cY1v1uZbvXjFcb7zmvv85j/PuZmBTnSMB73nRUe60Mut2uYyV7WttSpwOd3p
kzL8NrUd3dMfrdPM9bZuzAhu5IZ70uJufVzDmAXVkzpw40or7cGFrtQh3u6vWfe+9+UugnECK4y6
e713Nm9dPnFe7FbZy+htr5Lx/e74upLf9O3efTWXwr6vvY8B6G/hg0f5Xlhe2Xu/fDADEPqGFyIQ
ADs=
------=_20040206160050_15165--
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Re: big sql question (made a link for you).... Jochem van Dieten
- Re: big sql question (made a link for you).... kelly
- Re: big sql question (made a link for you).... Jochem van Dieten
- RE: big sql question (made a link for you).... Michael T. Tangorre
- Re: big sql question (made a link for you).... Jochem van Dieten
- Please make selection -----> Stuart Kidd
- Re: Please make selection -----> Bruce Sorge
- RE: Please make selection -----> Cameron Childress
- RE: Please make selection -----> Stuart Kidd
- Re: Please make selection -----> Bruce Sorge
- Andy Ousterhout