Nice simple T-SQL question that will no doubt prove totally uncontroversial
Anyone know the easiest way to get from:
Currently I cast my int as money, use convert to varchar with style 1 and then lop off the .00. Is there an easier way?
Two things before you get all upset and start squealing about front ends:
1) These are admin functions that I am running from SSMS. I don't want to go to the bother of creating an application when SSMS is perfectly adequate for what I need (namely to-a-large-degree unformatted result sets).
2) I'm not too fussed about it just curious.
good old style 1, that seems like the best approach
i did a quick search and came up with a number of threads where this question was asked and the answer was a resounding "it's a display issue and you should do that with the front end application, not sql"
of course, you already said you don't have an app...