SSRS NoRows – Display a custom message when there is no data
In this short post, I’ll discuss NoRowsMessage property. When there is no data for a data region, the message you...
2012-03-06
1,852 reads
Samuel Vanga
Introducing SQL Roundup
Following in the foot steps of John Sansom (b|t), I’m going to post a roundup of links from other blogs every Friday. I’ll...
2012-03-02
986 reads
Write a Variable To a File Using SSIS
Problem
I’ve a SSIS package. When it fails execution, I want to write a custom message including the package name and error...
2012-02-29
6,007 reads
Creating Your First SSAS 2012 Tabular Project
No matter how simple it is, new things come with some confusion; at least until you get used to it....
2012-02-21
4,574 reads
Be careful with two digit years
I recently had a scary conversation with a user, which can be broken down to:
User: Why would the data have...
2012-02-14
763 reads
LAST_VALUE() Analytic Function–SQL Server 2012
Earlier, i discussed FIRST_VALUE() function. FIRST_VALUE() returns the first value from an ordered set of records. Similarly LAST_VALUE() returns the last...
2012-02-07
2,706 reads
Data Labels, Axis Interval, Rotate Label Text: SSRS Nugget
Charts present summary data in a visually appealing format. Following is a chart for sales over month:
Before
I frequently use a few...
2012-02-01 (first published: 2012-01-31)
8,000 reads
Read contents of a file to variable – SSIS
Sometimes you will find the need to import a file to a variable using SSIS. In this post, I’ll use Script...
2012-01-24
1,845 reads
#meme15 – Use. Twitter. Why?
Should an average Jane or Joe professional use twitter?
Yes.
Why?
Because, I’m using it.
Not enough reasons? <grumpy face> I knew you wouldn’t...
2012-01-16
675 reads
FIRST_VALUE() Analytic Function–SQL Server 2012
Given a customer table:
CREATE TABLE Customers
(CustId INT, OrderDate DATE, OrderAmount MONEY) ;
INSERT Customers VALUES
(1, ’2011-12-03', 12500)
, (1, ’2011-10-07', 15000)
, (1,...
2012-01-10
839 reads
Blogs
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Killing Explicit Sort Steps in Redshift with the Right SORTKEY
You paste a slow Redshift query plan into PlanTrace and one of the tuning...
AI Experiments: Parsing Payment Memos
By Steve Jones
As part of my running the SQL Saturday charitable foundation, I get sponsorship money...
Forums
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
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
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