You can use APPLY instead and it will work just fine.

EXEC sp_executesql N'SELECT [id]

FROM [dbo].[test]

CROSS APPLY dbo.FN_DELIMITED_STRING_TO_TABLE(@1,'','')

ORDER BY id',

N'@1 varchar(MAX)',

'1000,2000,3000'

From what you posted I don't understand why you need...

The answer starts here. http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

My guess is that it returned the data but the report doesn't know how to handle it in a single result set.

One requirement of a CTE is the previous line must end with a semicolon. As such many people have developed the habit of beginning a cte that way.

;with cte as...

Try...

First of all this looks a lot like homework. As such we will point you in the direction of a solution but not actually provide it.

Second there is nowhere near...

What are you trying to connect? SSMS? An application? If it is an application have you double checked your connection string? Is it the correct connection string? I can't see...

Landscape:

height = 8.5

width = 11

Portrait:

height = 11

width = 8.5

height and width.

Sounds like transactional replication may be a good solution for you.

http://msdn.microsoft.com/en-us/library/ms151176%28v=sql.90%29.aspx

error message?

Talk to your network admin. Your box can't see the sql box on the network.

There are also a few people who didn't consider the possibility of unique constraints being defined in the same CREATE TABLE statement, for instance because they have the habit of...

At this point it seems the two of you are putting in far more effort on this than the OP. 😉

http://www.aicas.com/jamaica/3.4/doc/jamaica_api/java/net/NoRouteToHostException.html

Googled here

This is almost certainly a network issue. Can you ping the sql box from your app box?

Open a command prompt

ping [servername]