Home Forums SQL Server 2005 SQL Server 2005 General Discussion Date field in Select & Group by RE: Date field in Select & Group by

  • October 11, 2010 at 2:23 pm

    #1235211

    sbrochu

    To help others help you, please post your table definition, sample data, required result and the code you have run following the directions contained in the first link in my signature block. For example:

    CREATE TABLE #T ([Name] VARCHAR(10), ExeCount INT, Domain VARCHAR(10),

    [Last Logon User] VARCHAR(10), [Start Date] DATETIME )

    INSERT INTO #T

    SELECT 'C03702', 21,'HANOVER','SLE609','2010-09-14 09:09:03.000'

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]