Community Member Profile
Gonzalo
Member since Mar 25, 2009
- Profile: /members/3154-Gonzalo.htm
- Comments: 2
- Points: 19
Recent Blog Comments By Gonzalo
-
Using CASE Statements In A SQL UPDATE Query
Posted on Mar 25, 2009 at 4:35 PM
CORRECTED CODE I have the following SQL statement that meets all the requirements of what I am trying to do? SELECT Diff_Adj, Case When Diff_Adj < 0 Then '-'+right ('00000000'+convert (varchar(10), convert (int, -Diff_Adj*100... read more »
-
Using CASE Statements In A SQL UPDATE Query
Posted on Mar 25, 2009 at 4:33 PM
I have the following SQL statement that meets all the requirements of what I am trying to do? SELECT Diff_Adj, Case When Diff_Adj < 0 Then '-'+right ('00000000'+convert (varchar(10), convert (int, -Diff_Adj*100)), 9) Els... read more »
