31 Days of SSIS – Adding Some Delta Force (27/31)
31 Days of SSIS
Welcome to day twenty-seventh post of the 31 Days of SSIS. We’re getting near the end now. ...
2011-01-28
1,537 reads
Blog Posts
31 Days of SSIS – Jim Croce and the Foreach (File) Loop Container (28/31)
31 Days of SSIS
It’s Friday and I’m still taking Friday’s off in my 31 Days of SSIS blog series. As...
2011-01-28
888 reads
A Quick TRIM, Sir?
The other day, I was answering a question on the ASK.SQLSERVERCENTRAL.COM forum from a programmer who had hit a
problem...
2011-01-28
2,153 reads
MySQL Saves You From Missing Where Clause, Sorta
I’ve been taking a look at MySQL after a long absence to help a client decide if it should be...
2011-01-28
921 reads
Speaking at the Rocky Mountain Tech Trifecta on March 5
I just got the notification that I will be one of the speakers at the Rocky Mountain Tech Trifecta on...
2011-01-28
687 reads
SQL Saturday #57 Houston
So you don’t have anything to do this Saturday.Well, if you have an insatiable thirst for SQL knowledge like me,...
2011-01-28
478 reads
Un-SQL Friday #002 Roundup (finally)
The invitation for Un-SQL Friday #002 (Tech Giants) was, like, a week ago! I’ve gotta get this train a-rollin, or...
2011-01-28
962 reads
Upcoming presentations
It’s looking like it’s going to be a busy year.
It’s only January and I already have three presentations lined up...
2011-01-28
544 reads
31 Days of SSIS – Small Package, Big Win (26/31)
Welcome to day twenty-sixth post of the 31 Days of SSIS. We’re getting near the end now. If you have...
2011-01-27
911 reads
A Half-Price Seat at the Masters’ Table
Well, it looks like I half-won the SQLskills competition for a free seat at a SQLskills Master Immersion Event on...
2011-01-27
523 reads
Blogs
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
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...
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