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

  • October 12, 2010 at 6:54 am

    #1235473

    The "start date" field data is like this in the database.

    StartDate Internal Name FileName

    2010-09-13 09:22:21.000SignIn.exesignin.exe

    2010-09-13 09:23:53.000EXTRAextra.exe

    2010-09-13 09:23:53.000EXTRAextra.exe

    2010-09-13 11:33:41.000ConsoleOneconsoleone.exe

    2010-09-13 14:57:25.000MSACCESSmsaccess.exe

    2010-09-13 17:59:36.000CSAcsacontrol.exe

    2010-09-14 07:54:24.000SignIn.exesignin.exe

    2010-09-14 07:55:43.000EXTRAextra.exe

    2010-09-14 07:55:43.000EXTRAextra.exe

    2010-09-14 08:35:30.000Microsoft PowerPoint*powerpnt.exe

    I was and am able to extract the "StartDate" field. but, with latest version of my script, the dataset changes when I include "StartDate" field. It's back to all duplicate records is what I am saying.