Thank you.

I also found this:

http://stackoverflow.com/questions/13873701/convert-comma-separated-column-value-to-rows

I was looking at this as a learning opportunity and if fact learned something.

I will, however talk to a web developer.

Thanks again.

I found it. It's because of the space.

If I do the following, it works:

SELECT val2 FROM q WHERE replace(val2,' ','') NOT LIKE '%[^a-zA-Z]%'

Thanks,

Thanks for fast replies.

I am trying to identify other potential chars that may break my web app.

Why won't this work?

--drop table q

create table q (val1 varchar(1), val2 varchar(30))

insert into q(val1,val2)...

Thanks for reply. Your query helped a lot.

Thank you, I ended up finding and reading the same document.

John,

The reason for openrowset is because the called procedure calls another procedure where insert ... exec is used.

So, I am getting an error "INSERT EXEC statement cannot be nested"

I know,...

Msg 14607, Level 16, State 1, Procedure sp_send_dbmail, Line 141

profile name is not valid

Thank you Lowell for sharing your code.

Thanks all for replies. Based on our replies I get the idea that I did not explain what I am facing correctly.

Let's say I have a server A on which...

Thanks for your reply.

Perhaps I did not explain this well. What I need is to call a web service from sql server.

My bad, I was referring to

INSERT INTO #Results

EXEC sp_executesql N'SELECT col_1, col_2 FROM A;';

can I use

INSERT INTO #Results

SELECT col_1, col_2 FROM A;

Thank you, that looks like something I can try doing.

One question: why do I have to use dynamic sql? Why can't I just:

-- Use a temp table to store results

CREATE...

Alan, not sure how it's possible, but I think I found a resolution.

I changed datatype of the col_1 from nvarchar(30) to varchar(30).

Thanks,

My bad, I messed up.

Here is what I need to run, but the output is truncated:

drop table A;

CREATE TABLE A(

[col_1] [nvarchar](30) NOT NULL,

[col_2] [varchar](256) NULL,

[col_3] [varchar](max) NULL,

[col_4] [varchar](max) NULL)

;

insert...