2008-01-29 (first published: 2007-11-23)
1,969 reads
2008-01-29 (first published: 2007-11-23)
1,969 reads
2008-01-28 (first published: 2007-12-03)
1,705 reads
This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best results
2008-01-25 (first published: 2007-11-27)
3,794 reads
2008-01-24
1,236 reads
SP to find object and line number that references column(s) of interest.
2008-01-24 (first published: 2007-11-21)
1,024 reads
RDL for use in MSSSQL 2005's Management Studio (custom reports).
2008-01-18 (first published: 2007-09-25)
2,695 reads
This script allows you to check the several availability windows for the current day.
2008-01-18 (first published: 2007-10-29)
1,084 reads
Sometimes you are given a list of values in a stored procedure that you want to use in an "IN" clause. This is a common in Reporting Services multi value parameters.
2008-01-15 (first published: 2007-11-15)
1,004 reads
2008-01-14
989 reads
Two queries below show one of many ways how You can generate a sequence of numbers.
2008-01-14
925 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
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