The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
SQL question
Deebaser
on my way to work in a suit and a tieAhhhh...come on fucking guyRegistered User regular
on my way to work in a suit and a tieAhhhh...come on fucking guyRegistered User regular
I have a field stored as a float that needs to be presented as currency. The problem is transact SQL doesn't seem to recognize 'double'. Is there an easy work around for this?
It needs to be shipped before I go home, because the dude needs this tomorrow AM in the UK.
It needs to be shipped before I go home, because the dude needs this tomorrow AM in the UK.
Deebaser on
0
Posts
http://msdn.microsoft.com/en-us/library/ms187928.aspx
Do you need the currency symbol? If so, you will need to cast again to varchar.
I wound up converting my final select to decimal(15,2)
I'm sure they'd love the currency symbol, but we don't have a table with that stored and this report has about a dozen different currencies....so....yeah....fuck it.