Cast Sql tweets
SQL="select CAST( $MPI * ($BASE_VISIT_TOT/$POS_VISIT_T- OT) AS DECIMAL(32,20) )" using database as calculator...are you that afraid of code?
http://twitter.com/edwardcapriolo
13 years ago
IF CAST([Requests] AS nvarchar(50)) in ("Reasonable","Considerate") THEN [Demeanor] = "Nice" ELSE [Demeanor] = "Curmudgeon" END #sql
13 years ago
#sqlhelp Trying to CAST a varchar into datetime with SUBSTRING in dynamic SQL - works executed separately but not in the dynamic statement
http://twitter.com/AndrewSciSquire
13 years ago

