none
New line in column headers RRS feed

  • Question

  • I have this stored procedure:

    ALTER PROCEDURE dbo.KSO_OrdrerIPeriode
    @FraDato
    DateTime,
    @TilDato
    DateTime

    AS

    SELECT SalesOrderNumber, ShipDate, SubTotal
    FROM Sales.SalesOrderHeader
    WHERE (ShipDate >= CONVERT(DATETIME, @FraDato, 102) AND ShipDate <= CONVERT(DATETIME, @TilDato, 102))

    RETURN

    And I want the header of the column "SubTotal" to be the date interval - somethink like this:

    SalesorderNumber          ShipDate            01-01-2001
                                                               31-07-2001

    where 01-01-2001 is the value of @FraDato and 31-07-2001 is the value of @TilDato

    How can I do this quick&simple ?


    Best regards KSor, Denmark
    Saturday, September 20, 2008 5:39 AM

Answers