New York City .NET

I love MERGE. You know all those awful IF BEGIN END ELSE BEGIN END blocks you need to write for...

2011-01-17

4,087 reads

Wiring up a common click event handler in an ASP.NET page

I was just refactoring a server-side control and ran into some horrible code. Basicaly there was a big listbox that...

2010-12-30

3,112 reads

I recently was working on a library to manage reports in an application (probably a good candidate for an open source project)...

2010-12-29

678 reads

It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...

I’ve had a Dropbox account for years. Like a lot of people, I started...

Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...

hi a peer of mine who ive never known to be wrong says a...

Comments posted to this topic are about the item Displaying Money

Comments posted to this topic are about the item The Slow Growing Problems

I want to get the currency sign displayed with my amount stored in a money type. Does this work?

DECLARE @Amount MONEY;
SET @Amount = '?1500';

SELECT CAST( @Amount  AS VARCHAR(30)) AS Euros