Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

  • RE: Calculate daily turnover in SQL Server 2008

    J Livingston SQL (11/14/2015)


    here is one way....this should get you started.....

    SELECT

    CONVERT(varchar(10) , TimeOut , 101) AS yourdate

    , SUM(CASE

    WHEN DATEPART(hour , timeout) >=...

  • RE: Calculate daily turnover in SQL Server 2008

    J Livingston SQL (11/14/2015)


    mrbill.mt (11/14/2015)


    J Livingston SQL (11/14/2015)


    mrbill.mt (11/14/2015)


    I have the following data:

    I have to count data from date A to Date B (e.g: 11/1/2015 to 11/3/2015) and From Hour...

  • RE: Calculate daily turnover in SQL Server 2008

    J Livingston SQL (11/14/2015)


    mrbill.mt (11/14/2015)


    I have the following data:

    I have to count data from date A to Date B (e.g: 11/1/2015 to 11/3/2015) and From Hour to Hour (e.g: From0_12:...

Viewing 3 posts - 1 through 4 (of 4 total)