Database

SELECT  A.* FROM
(
    SELECT B.ID, B.Date,
      RANK() OVER (PARTITION BY B.ID ORDER BY B.Date  DESC) AS RowRank
    FROM   tblName B  WHERE
      B.Value>0 AND Date<CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME)
    GROUP BY
      B.ID, B.Date
) A WHERE RowRank<=5 ORDER BY ID

CASE input_expression <br />
    WHEN when_expression THEN result_expression <br />
        [ ...n ] <br />
    [ <br />
        ELSE else_result_expression <br />
    ] <br />
END <br />
<br />
Searched CASE function:<br />
<br />
CASE<br />
    WHEN Boolean_expression THEN result_expression <br />
        [ ...n ] <br />
    [ <br />
        ELSE else_result_expression <br />
    ] <br />
END

<br />
USE pubs<br />
GO<br />
SELECT   Category = <br />
      CASE type<br />
         WHEN 'popular_comp' THEN 'Popular Computing'<br />
         WHEN 'mod_cook' THEN 'Modern Cooking'<br />
         WHEN 'business' THEN 'Business'<br />
         WHEN 'psychology' THEN 'Psychology'<br />
         WHEN 'trad_cook' THEN 'Traditional Cooking'<br />
         ELSE 'Not yet categorized'<br />
      END,<br />
   CAST(title AS varchar(25)) AS 'Shortened Title',<br />
   price AS Price<br />
FROM titles<br />
WHERE price IS NOT NULL<br />
ORDER BY type, price<br />
COMPUTE AVG(price) BY type<br />
GO<br />
<br />
<< >><br />

Vuyiswamb wrote:

what do you think is Wrong? Do you want me to send you the vb6 code?