Search results

  1. L

    Select TOP 0.1 Percent

    Hi, My initial query is a make table to store results SELECT Count(*) AS AllCount, Round(Count*0.999) AS ReportCount, Avg([1RawJitter].[Jitter]) AS AllAvg, 0 AS ReportAvg INTO 2RptJitter FROM [1RawJitter]; Then I want to do a SELECT TOP (2Jitter.ReportAvg) type query to update...
  2. L

    Select TOP 0.1 Percent

    I have a table of 8728 records, but I only want to do calculations for the bottom 99.9%, i.e. I can exclude the top 0.1% I know I can't use 99.9 or 0.1 in the Select statement as TOP needs to be followed by an INT So, I have calculated the number of records I want to use...
Back
Top Bottom