I found it in BOL right after I posted. Thanks.

Thanks all for your time. I have now resolved the issue but just facing one more issue of case when in where. Hopefully I will resolve it soon. Again, thanks...

Sean,

Can you please take a look at my SP, the challenge is right at (@StartYear IS NULL AND @EndYear IS NULL)) where I need to pass...

Here is my SP:

CREATE PROCEDURE [dbo].[myList]

(

@Id int,

@StartYear int = NULL,

@EndYear int = NULL,

@Name VarChar(50) = NULL,

@Ids VarChar(3000) = NULL

)

AS

DECLARE @query VARCHAR(8000)

SET @query = N'

SELECT ...

Sean,

Casting does work. Now the question is how do i execute? using

EXEC (@query)

or

EXEC sp_execsql (@query)

Thanks.

As I stated earlier, it works for IN clause, but does not work for an int variable

SET @query = N'

SELECT * from tbl where (nid = '+@ID+')

AND ID IN('+IDs+')'

It works...

Sean,

The problem is that I cannot create a function in our database, the lead shouts. I am allowed to create only couple of stored procs.

Any other...

Thanks all for your response. I took STurner's response and created like:

SET @query = N'

SELECT * from tbl where (nid = '+@ID+')

AND ID IN('+IDs+')'

It works for the IDS in the...

I do not know how to ftp using cmdshell, so I wrote a webservice in .Net. Do you know a way to use cmdshell for ftp?

Thanks.

The problem was that I was having a line break within my select statement. I have it working now. Only thing that I need to do is to add column...

Yet another mistake correced from the previous statement

Why is this not working?

DECLARE @exe nvarchar(4000)

SET @exe =N'bcp '

SET @exe =@exe + N'

"EXEC SELECT...

I missed to include "exec" in the previous statement

Why is this not working?

DECLARE @exe nvarchar(4000)

SET @exe =N'bcp exec '

SET @exe =@exe +...

Why is this not working?

DECLARE @exe nvarchar(4000)

SET @exe =N'bcp '

SET @exe =@exe + N'

"SELECT * FROM Customers" '

SET @exe...

Hi Prashavhad,

Can you please give me more hint on creating bcp for this?

Thanks

Gail,

That was the answer I was looking for. Thanks.