Flipping a Table Sideways
Not too often, someone asks for a strange request like wanting to pivot on every single value inside a table....
2010-05-28
1,596 reads
Blog Posts
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I import binary files into SSIS as well as how to improve throughput by...
2010-05-28
9 reads
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I import binary files into...
2010-05-28
2,491 reads
Importing binary files with SSIS
I have gotten a number of emails over the past few days asking about how I
import binary files into SSIS as well as how to improve throughput by...
2010-05-28
25 reads
New Unlocked CPUs From Intel
AnandTech has an interesting review up about some new models of Core i5 and Core i7 processors that are designed...
2010-05-28
1,453 reads
Permission Issue
I found a post of setting up database access in the following site and I responded there and I wanted...
2010-05-28
1,736 reads
The Truth about SQLPS and PowerShell V2
With the release of SQL Server 2008 R2 there have been claims that sqlps is really PowerShell V1 under the...
2010-05-28
5,535 reads
Two Blog Series You Don’t Want to Miss
Blogs are a great way to learn new things about SQL Server, and just in case you have missed them,...
2010-05-28
1,581 reads
Adding Space to a Home Server
I got new drives for my Windows Home Server the other day and decided to add some space to the...
2010-05-27
1,042 reads
Becoming a Part of the SQL Server Twitter Community
There have been tens of thousands of blog posts and articles written about Twitter, and because of this, I have...
2010-05-27
752 reads
Blogs
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...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
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