I have a table that stores a comma separated list of key value pairs for permissions. E.g 45:902,45:61,51:203,51:208 etc. I'm trying to parse a single record row so that I get a record set of ...

SQL Server Management Studio (SSMS ... and then drag the Columns container into the query pane, a nice comma separated list of every column in that table will be added to the query.