|visits||member for||1 year, 10 months|
|seen||Nov 8 at 8:59|
|asked||All databases restoring in Suspect Mode in SQL Server 2012|
Performance differences between executing via Linked Server vs. SSMS
Have you considered creating a name-value pair user defined table and passing that in to your SP as the list of Ids rather than a string of Ids? It would eliminate the need for your dynamic sql.