retrieving the greatest 10 negative numbers

• Tsql-561486

  SSC Eights!

  Points: 821

  More actions

  December 7, 2007 at 5:16 am

  #70548

  Hi,

  I have table T1 with some columns

  e.g

  C1- ID

  C2-Date

  C3-Gross amount( positive and negative values)

  C4-Netamount

  I want to retrieve 10 IDs with the greatest negative Gross amount for the current date.

  Please can anyone help me in getting it.

  thanks

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  December 7, 2007 at 5:41 am

  #758027

  DECLARE @dtStartDate DATETIME,

  @dtEndDate DATETIME

  SET @dtStartDate = CONVERT( DATETIME, CONVERT( VARCHAR(10), GETDATE(), 112 ) )

  SET @dtEndDate = DATEADD( DAY, 1, @dtStartDate )

  SELECTTOP 10 ID

  FROMT1

  WHERE[Date] >= @dtStartDate AND [Date] < @dtEndDate

  AND [Gross amount] < 0

  ORDER BY [Gross amount] DESC

  --Ramesh
  

  ---