comma-delimited foreign key help!

I have a Profiles table that, among other things, contains all the groups a member can be a part of. I have a field called [Member Groups] that contains a comma-seperated value of all the foreign keys from the table [Member Group List]. So, in the field, I have this:

I know already that this is not good database practice, but I'm working on existing design restrictions. Does anybody know of a stored procedure, or a query, or some way of getting from where I am to where I want to be? Thanks in advance,

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Featured Post

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…

Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.