2008-09-19 (first published: 2008-07-20)
1,491 reads
Scripts
2008-09-18 (first published: 2008-07-15)
705 reads
2008-09-16
336 reads
Create string from table
This simple script retrieves a range of values from a table and presents the results as a string.
2008-09-15 (first published: 2008-07-16)
1,624 reads
Get DBMail information
get the profile name and the account name etc about the dbmails created on the server
2008-09-12 (first published: 2008-07-13)
1,001 reads
2008-09-11
1,529 reads
2008-09-10 (first published: 2008-07-12)
1,520 reads
DB Connection Killer
This script opens a little cursor that will clean out connections to any DBs you specify.
2008-09-09 (first published: 2008-07-21)
1,535 reads
2008-09-09
1,083 reads
2008-09-08 (first published: 2008-07-20)
1,276 reads
Blogs
AI Experiments: Parsing Payment Memos
By Steve Jones
As part of my running the SQL Saturday charitable foundation, I get sponsorship money...
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
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