Can I fix this in my setup options?
jeffsturgeon2002
Posts: 10
SQL Refactor first off looks like it will save me hours of tedious work. I purchased SQL Prompt and love it.
I am demo testing Refactor to see if its something I may wish to purchase.
My code is getting set like this:
I want it to look like this:
Its taking the value after the comma and forcing it to another line. Any help is appreciated. Maybe I just overlooked something obvious.
I am demo testing Refactor to see if its something I may wish to purchase.
My code is getting set like this:
'120.Insured1Zip' = CASE WHEN COALESCE(pi.InsuredSameAsPatient, 1) = 1 THEN pp.zip WHEN COALESCE(pi.InsuredSameAsGuarantor, 1) = 1 THEN g.zip ELSE ISNULL(pi.zip, '') END,
I want it to look like this:
'120.Insured1Zip' = CASE WHEN COALESCE(pi.InsuredSameAsPatient,1) = 1 THEN pp.zip WHEN COALESCE(pi.InsuredSameAsGuarantor,1) = 1 THEN g.zip ELSE ISNULL(pi.zip, '') END,
Its taking the value after the comma and forcing it to another line. Any help is appreciated. Maybe I just overlooked something obvious.
Comments