2005-02-11
2,431 reads
2005-02-11
2,431 reads
The original function fails when a mistaken split char is being snet to the function.This can easly be corrected by adding an if to check the value of the @holdpos inside the loop before sending it to the substring functionif the value is 0 then break the loop
2005-02-23 (first published: 2005-02-07)
118 reads
2005-02-07
2,164 reads
2005-02-04
2,500 reads
You can return the date as a string (varchar) in whatever date format you like by adding a 'style' to the CONVERT statement. Exmaples of style values are (two left hand columns):1 101 USA mm/dd/yy 2 102 ANSI yy.mm.dd 3 103 British/French dd/mm/yy 4 104 German dd.mm.yy 5 105 Italian dd-mm-yy 6 106 - dd […]
2005-02-18 (first published: 2005-01-31)
203 reads
2005-01-24
1,816 reads
2004-12-31
2,025 reads
2004-12-30
2,179 reads
2004-12-27
1,387 reads
2004-12-17
2,543 reads
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
You paste a slow Redshift query plan into PlanTrace and one of the tuning...
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