This must be much simplier than I'm making it...
I have an unique idenifier for a person, and a space delimited field containing grades they teach, since they could teach more than one grade I'm looking to have their unique idenifier and a single grade taught. I have a split list function but how do I do this...
(SELECT * FROM dbo.udfSplitList(Grades,' ')
I know this is the wrong way and I get errors, any guidance would be great!