Thanks mr_opto that was the issue with needing four single quotes. The second problem came about because you can not put this code on multiple lines. It has to be...

Thanks for your response however I don't think that is the issue. I changed to this and received the following output.

When @import_type = 'UserDetails' Then

'exec master..xp_cmdshell ''bcp

"Select v.EntryValue,...

Here is one idea. Hopefully you can work it out from here.

USE [VC]

GO

/****** Object: StoredProcedure [dbo].[Events_Aggregate_Count_by_EventType_AD] Script Date: 09/16/2011 16:37:57 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER Procedure...

I think I am having a simular issue which I have been unable to solve so far. Any ideas?

This works in a query window in SQL Management Studio;

Select v.EntryValue, FirstName,...

This is great if you have a parameter with only one value but how does one pass in many values for a single parameter?

This worked for me, save this file...