I don't seem to be able to suppress the indenting of BEGIN/END statements. What I'd like to achieve is the following formatting:
IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') < $15
BEGIN
   PRINT 'The following titles are excellent mod_cook books:'
   PRINT ' '
   SELECT SUBSTRING(title, 1, 35) AS Title
   FROM titles
   WHERE type = 'mod_cook' 
END
ELSE
   PRINT 'Average title price is more than $15.'
jmeyer
0

Add comment

Please sign in to leave a comment.