|
|
-
|
|
I recently had a scary conversation with a user, which can be broken down to:
User: Why would the data have customers with a birth date of MM/DD/2020?
Me: What are you talking about? Lemme take a look.
Me again, this time with a changed voice: Umm, Umm, i ...
|
|
-
|
|
Earlier, i discussed FIRST_VALUE() function. FIRST_VALUE() returns the first value from an ordered set of records. Similarly LAST_VALUE() returns the last value for an ordered result set, but you are in for a bit of a surprise if you aren’t familiar ...
|
|
-
|
|
Charts present summary data in a visually appealing format. Following is a chart for sales over month:
Before
I frequently use a few options along with charts to get most out of them.
Show data labels:
It’ll be easier for the users to quickly read, if the...
|
|
-
|
|
Sometimes you will find the need to import a file to a variable using SSIS. In this post, I’ll use Script Task to read contents of a flat file into a variable.
I’ve created a file called ‘myfile.txt’ with some random text. I̵...
|
|
-
|
|
Should an average Jane or Joe professional use twitter?Yes.Why?Because, I’m using it.Not enough reasons? I knew you wouldn’t buy this.Okay, allow me to present why you should:Advertise.You might be thinking, “I’m neither an author nor do i have any bus...
|
|
-
|
|
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, ’2011-09-12′, 16000)
, (2, ’2011...
|
|
-
|
|
As the name indicates, CONCAT() will concatenate two or more strings. This is one of the two string functions introduced in SQL Server 2012, FORMAT() being the other one. New? Wait. Concatenating isn’t new. It’s always been there. Yeah. you ...
|
|
-
|
|
When creating a SSRS report, you want to add lines that display trends. Sparklines that were introduced in SQL Server 2008 R2 will allow you to do this easily. But wait there is more. You want to show trends for more than one data point. For example act...
|
|
-
|
|
Formatting numbers in an SSRS report is a common task. For example, you may want to format a number as currency or percentage.
You can select a format from the number page of the properties window.
You can let sql handle the formatting, so data in the ...
|
|
-
|
|
Use Actions!
Your user wants a summary report, containing sales for calendar year, for example. When the user clicks on the report, another detail report should be visible, containing sales for each month of the year, suppose. These type of reports are ...
|
|