Thank you R.P.Rozema and Paul. This code can answer why my initial query was wrong. Thanks again.

Thanks

Lindsay

Thanks all your help^_^

I found there is one way to work arround it, we can use & for XML format to replace it. is there any other better way?

Thanks all of your help.

arjun,

Your code is perfect. But I fund it doesn't work if my string include "&" (like Set @colname = 'a2soft,a1soft,a3,b1,b2,a1soft.abc&test'), how to work arround it?

Thanks

Lindsay

aha.. Thanks a lot opc.three

Thanks a lot opc.three.

It is indeed good way to get data, but it has a restriction that we should know the table structure before we insert the data into the...

Thanks a lot Sergiy. This solution works for me^_^

Thanks

Lindsay

Lutz,

I only want to create one query has 8000+ charaters, and prove the openquery doesn't work. and see a solution for it. Becasue I can't give you the my...

what do you mean Sachin?

This is the topic of this thread, I hope to seek one solution to resolve the issue when the query has 8000+ data. the query...

Lutz,

Please refer to the following sample, I only want to find one query which has 8000+ charater, the table in the query is the sample database of Adventure database...

Thanks for your reply Lutz^_^

Could you please give me a sample to create that SP? In our scenario, the querystring is parameter, which is passed into openquery no matter whether...

I have found one way to workarround it, past the sample here, in case someone hit same problem. Really appreciated if someone can share another way to fingure out it....

Thanks a lot Jason and Lowell.

Seems that we have to use Jason's suggestion to get column's info if I don't know the structure of the local table.:)

Thanks

Ling

Thanks for your response Jason-299789.

Because this is only one step in the SP, I want to create this SP and then user can call it easily. I know the SSIS...

Thanks a lot stewartc-708166. You are so kindly 🙂

Thanks

Lindsay