|visits||member for||1 year, 3 months|
|seen||Apr 2 at 15:38|
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.