Thank You - That was a great idea to have a tally table used with a function to split csv and inner join!  It worked like a charm - thanks...

Hello Jeff,

I created a tally table and added the split function to my database.  I was just trying to test it before I add it to my stored proc and...

Can this be done with an in versus a like?

Never realized the sp_ - thanks!

Is there anyway to fix this error without touching registry keys?

Hello - So I used sp_configure to set the ad hoc distributed queries to 1 and then i ran reconfigure.  I received the following error:

This is for 64 bit

OLE...

Thank You!  I started naming my sprocs with sp__ (two underscores) to prevent naming conflicts in the future in the event Microsoft happened to provide a sproc in the future...