|
|
-
|
|
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 ...
|
|
-
|
|
I read a post about documenting your day by Steve Jones, here is where culture insists i write a few words about the person i refer to. But you don’t expect that for Steve. Do you?
In this short post, I’ll present my view on why you should...
|
|
-
|
|
And the trick i share for this month’s T-SQL Tuesday is… Distraction free management studio.
If you’re an avid writer, you might be using Writeroom. It’s a full screen distraction free writing application, which gets your computer out-of-the-way ...
|
|
-
|
|
This is by far the simplest and silliest post ever, but i just figured how to create vertical tabs in management studio. When I learn something, you have to read it. I apologize, but you have to read it. As Ellen DeGeneres says, “if I see something… you...
|
|