Removing Time From A Datetime Value
How much time would a DateTime have if a DateTime had no time?
Ok, forgive the bad pun. But the point...
2011-01-14
893 reads
Blog Posts
SQLServerCentral.com Track at SQL Server Connections 2011 in Orlando in March
SQLServerCentral.com will be offering a track at SQL Server Connections, to be held March 27-31, 2011, at the JW Marriott...
2011-01-14
920 reads
31 Days of SSIS – Create XML Document (13/31)
31 Days of SSIS
Day thirteen and we are trucking along with the 31 Days of SSIS blog series. The last...
2011-01-13
1,958 reads
Introducing MagicPASS - Orlando's New PASS Chapter
After a year of planning I'm proud to announce that South Orlando has a new PASS chapter: MagicPASS! Our first...
2011-01-13
998 reads
January ’11 Meeting Reminder
If you saw my blog post the other day, you know that S3OLV has a meeting this Thursday (Jan 13, 2010) at 6:30 PM PST. If not, then you...
2011-01-13
13 reads
January ’11 Meeting Reminder
If you saw my blog post the other day, you know that S3OLV has a meeting this Thursday (Jan 13,...
2011-01-13
468 reads
Silly Billiseconds
You have to admire Microsoft for sticking to their guns, even when being palpably stupid. I refer, of course to...
2011-01-13
3,348 reads
SQL People Events - TED for SQL Server
When I first saw Andy Leonard's post about a new SQL People event, I was intrigued. It's not a training...
2011-01-13
2,503 reads
SQL University: Spring 2011
The new SQL University Logo
Welcome back students! We’re very excited to start up a new semester and SQLU is back and...
2011-01-13
849 reads
31 Days of SSIS – UnPivot Alternative (12/31)
31 Days of SSIS
This is the twelfth post in the 31 Days of SSIS blog series. This post is going...
2011-01-12
1,009 reads
Blogs
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Forums
identity increments by 10,000 when it was supposed to be 1
hi a peer of mine who ive never known to be wrong says a...
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Question of the Day
Displaying Money
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 EurosSee possible answers