claudeless
|
| Posted: 05/29/2005, 7:34 PM |
|
OK Here is my SQL my only problem is I am not getting the Right lookup from
From this Statement. Can anyone help.... Thanks
INNER JOIN pricebook ON
(( classofsoftware.Catagory = pricebook.Category) AND
( @PLEVEL = pricebook.Level))
SELECT
MasterCusID,
CurrentVersion AS CVER ,
SUM(MultiNo) AS QTY,
`Orginal AssetType` AS OTYPE,
`Orginal MODEL_NO` AS MODEL,
@PLEVEL:= CASE
WHEN SUM(assets.MultiNo) = 1 then @PLEVEL:= 'A'
WHEN SUM(assets.MultiNo) BETWEEN 2 AND 6 then @PLEVEL:= 'B'
WHEN SUM(assets.MultiNo) BETWEEN 7 AND 10 then @PLEVEL:= 'C'
WHEN SUM(assets.MultiNo) BETWEEN 11 AND 25 then @PLEVEL:= 'D'
WHEN SUM(assets.MultiNo) BETWEEN 26 AND 50 Then @PLEVEL:= 'E'
WHEN SUM(assets.MultiNo) BETWEEN 51 AND 100 Then @PLEVEL:= 'F'
WHEN SUM(assets.MultiNo) BETWEEN 101 AND 200 then @PLEVEL:= 'G'
WHEN SUM(assets.MultiNo) BETWEEN 201 AND 400 then @PLEVEL:= 'H'
WHEN SUM(assets.MultiNo) BETWEEN 401 AND 800 then @PLEVEL:= 'I'
WHEN SUM(assets.MultiNo) BETWEEN 801 AND 1500 then @PLEVEL:= 'J'
else @PLEVEL:= 'K'
END AS LEVEL,
Catagory AS CAT,
pricebook.Level AS PBLEVEL,
Description AS DESCRIB,
Retail,
DealerCost
FROM
(classofsoftware
INNER JOIN assets ON assets.`Orginal MODEL_NO` = classofsoftware.ModelNo)
INNER JOIN pricebook ON
(( classofsoftware.Catagory = pricebook.Category) AND
( @PLEVEL = pricebook.Level))
WHERE
(MasterCusID = {MasterCuSIDSTAT}) and
(assets.VOIDED = 0) and
(assets.QuoteAsset = 0)
GROUP BY
assets.`Orginal AssetType`,
classofsoftware.Catagory
VER SUITE 4 THIS is Right
QTY 6 THIS is Right
TYPE LICENSE THIS is Right
MODEL 1TO50 THIS is Right
CASE LOOKUP B THIS is Right
CAT CAT1
PRICELEVEL A Value being Posted Should be B not A
DESCRIPTION CAT1 1-50 PPM Single This is the A Value not B
REAIL 1400 This is the A Value not B
COST 980 This is the A Value not B
|
|
|
 |
|
