I have a query (see below) that returns start time in this format '2014-11-11 15:38:36.000' username, company, Application.
what I'd like to do is for each record pull down the oldest record. I tried using distinct but still end up with multiple entries for
select distinct (StartTime), user_name, Company, Application from [dbo].[LicenseUsageTemp]
WHERE Company = 'Tellabs Operations Inc.' and Application = 'AR Server' and StartTime >= DATEADD(year,-1,GetDate()) order by StartTime;