Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Versions des environnements
SQL Server:
SQL Server 2014
>>Hi all, the query below produces a count and summation of monies by month, it works perfectly but *pretty it ain't*, anyone know of a *nicer* way of doing this ?
>
>If you have to have 24 columns, then your statement has to have those 24 rows. The nicer way would require reforming the calendar, and perhaps changing the orbit of Earth to produce a year of 256 or 512 days... so it's easier to leave as is.
I see your sense of humor survived the new year intact.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement