Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MAX isn't?
Message
From
17/09/2015 17:35:32
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
MAX isn't?
Environment versions
SQL Server:
SQL Server 2008 R2
Application:
Web
Miscellaneous
Thread ID:
01624759
Message ID:
01624759
Views:
64
I have a temp table that for a particular UserID has CompletionDates of 10/24/2014, 08/02/2015, and 09/14/2015

My command is

Select Max(completionDate) from #TempTable where UserID = 9999999

it returns the 2014 date, which makes my brain go 'bwuh?'

What's going on here?
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Next
Reply
Map
View

Click here to load this message in the networking platform