Boomi table import formatting
DECLARE @string VARCHAR(MAX) = 'boomi query'
SET @string = REPLACE(@string, ',', CHAR(10) + ',')
SET @string = REPLACE(@string, 'FROM', CHAR(10) + 'FROM')
PRINT (@string)
super simple, I'm in TSQL a lot, but the boomi table import always brought in a query string as one big blob & that drove me crazy, i like to see my columns have returns after each one, i paste it into this quick SQL statement to get a better format when working with imported db profiles lol. saved me a lot of time
Edited by Mitchell Franklin