MDX Puzzle #6
As we continue with the puzzles, I will continue to introduce new MDX functions. In this puzzle the requirements are...
2010-08-25
631 reads
SQLDownSouth
SQL Saturday #28 - Lessons Learned
After spending a week in Tampa, FL at a client site I've had some time to unwind and reflect back...
2010-08-23
959 reads
SQL Reporting Services - Line Graph with a Vertical Bar
So, I was recently asked if you could display a vertical bar on a line graph to denote the last...
2010-08-11
3,334 reads
MDX Puzzle #5 - Solution
Again I want to apologize for the slow posting of the solution to this puzzle, but I have been hard...
2010-08-10
583 reads
SQL lunch #28-SSIS Design Patterns 1a: Introduction to SSIS Design Patterns
In this three part series SQL Server MVP Andy Leonard will discuss SSIS Design Patterns.
Speaker: Andy Leonard
Add To Outlook:...
2010-08-08
1,071 reads
SQL Saturday #28 Update
We are just about a week away from probably the biggest FREE training event to ever take place in Baton...
2010-08-06
553 reads
SQL Saturday #28 Announces: Asks The Experts
Do you have a challenging SQL Server or .Net issue that is causing you to have sleepless nights? Well, we...
2010-08-03
515 reads
MDX Puzzle #5
Writing YTD totals and Running totals using T-SQL can take a little effort. However, with MDX it's not too difficult. ...
2010-08-01
549 reads
MDX Puzzle #4 - Solution
This puzzle may not have been much of a challenge, but it introduced two new MDX concepts. I have to...
2010-07-30
1,561 reads
2010 3rd Quarter Goals
Now that we are into the third quarter of 2010 I decided to post an update of my 2nd quarter...
2010-07-28
1,010 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