Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: RowNumber function Problem

    I have run into problems with RowNumber before. Sometimes the best way to index rows is with RunningValue()

    I didn't test this at all, but I'm thinking something like:

    August 25, 2005 at 10:40 am

    #585091

  • RE: Culmulative Reports

    This is the query I'm using

    select year (i.Invoice_Date) as Invoice_Year,

    month (i.Invoice_Date) as Invoice_Month,

    datename(month, i.Invoice_Date) as MonthName,

    i.Sales_Rep_Id as Sales_Rep_Id,

    i.Sales_Rep_Name as Sales_Rep_Name,

    i.Line_Amount as Line_Amount,

    0 as Quota

    from T4_Invoice_Lines_View i

    -- We are searching...

    August 25, 2005 at 10:10 am

    #585076

Viewing 2 posts - 1 through 2 (of 2 total)