Thanks, Jeff!

I was inspired by this to make a CSV Splitter that also respects double-quotes, such as 10,"20,30",40 so it doesn't use the comma inside quotes.

Style note - commas are...

Um, add ,c.scale right after ,c.position

(sys.columns has a scale column)

You can't use a list in a varchar like this. Use a table instead:

declare @dir table (d varchar)

insert into @dir select '4' union select '2'

SELECT *, empresa FROM #DIRETORIAS...

/* This seems to sync the SIDs between login and database user in SQL 2008 */

ALTER USER [Mary5] WITH login=[Mary5];