Can I fulfill formatting requirement of my customer with SQL Complete? Each column in list must be placed on separate line, comma in first position, then 3 spaces, then column specification. Sample:
Code: Select all
select
pp.ProductID
, pp.MakeFlag
, pp.FinishedGoodsFlag
, columns_updated()
, nullif(pp.MakeFlag, pp.FinishedGoodsFlag) as 'Null if Equal'
from Production.Product pp
where ProductID < 10
and pp.StandardCost < $100;
go