Stuart McLachlan
stuart at lexacorp.com.pg
Sat May 26 16:59:28 CDT 2012
Code still not shown :-) Most of us don't have the book, so we still don't know exactly what you are doing. At least post the line containing the CONVERT function so that we can see how you are using it. On 26 May 2012 at 13:02, Alan Lawhon wrote: > Stuart: > > I listed the code (verbatim) exactly as given in the book. The only > difference (which is obvious) is the section involving the 50 percent > calculation where I substituted a CONVERT function to try and change the > display of the values in the "Payment" calculated field for the records that > fall into the 50 percent payment catagory. When you're displaying monetary > values in the result set, it doesn't make a lot of sense for a value such as > $123.45 to display as 123.452349, so I was attempting to convert the > 123.452349 value to a character string that displays as $123.45. > > I'm a little confused about data types, but I'll figure this out eventually. > > Alan C. Lawhon > > -----Original Message----- > From: dba-sqlserver-bounces at databaseadvisors.com > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart > McLachlan > Sent: Friday, May 25, 2012 6:01 PM > To: Discussion concerning MS SQL Server > Subject: Re: [dba-SQLServer] SQL Server 2008 Display Formatting Problem > > Because you have used it incorrectly? > > To use a expression commonly found in programming forums: > "Code Not Shown!" > > Post the problem line(s) and we are more likely to be able to help. > > -- > Stuart > > On 25 May 2012 at 17:41, Alan Lawhon wrote: > > > > > I modified the code (slightly) from what is given in the book. In the > > section of code that calculates a 50% payment, I used the CONVERT > > function to try and modify the output display of the "Payment" > > calculated field. (I wanted the calculated value of 3470.1250000 to > > display as character string > > 3,470.13 so that it looks more "money" like.) However, the CONVERT > > function is not working as I expected. > > > > > > > > Does anyone have an idea as to why the CONVERT function is not working > > as expected? > > > > > > > > TIA, > > > > > > > > Alan C. Lawhon > > > -- > Stuart McLachlan > > Ph: +675 340 4392 > Mob: +675 7100 2028 > Web: http://www.lexacorp.com.pg > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- Stuart McLachlan Ph: +675 340 4392 Mob: +675 7100 2028 Web: http://www.lexacorp.com.pg