Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MAX isn't?
Message
De
17/09/2015 17:35:32
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
MAX isn't?
Versions des environnements
SQL Server:
SQL Server 2008 R2
Application:
Web
Divers
Thread ID:
01624759
Message ID:
01624759
Vues:
65
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform