I asked that...

mark.sayer (6/15/2012)

---

The CROSS APPLY seems to return the results in triplicate. I can't use DISTINCT as i've other columns in my select.

The NOLOCK hint is for speed, the query is...

ChrisM@Work (6/15/2012)

---

Sean Lange (6/15/2012)

---

The answer...

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

You might want to do this during off hours especially if the table is large because it might take a bit of time to create the index.

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.