DSD, I'm not directly involved in this discussion, but let me throw in my two cents.

As far as I know, many articles in your site were plagiarized. You say...

Take a look at this article[/url]. I think you will find all the information you need.

There are two assumptions that I would revise:

1) 100 rows is the edge value for...

What error are you getting?

This often comes from irresponsible ORDER BY clauses on badly written queries. Doesn't profiler show anything interesting?

There are 2 DMVs that could be helpful in this scenario:

sys.dm_db_task_space_usage

sys.dm_db_session_space_usage

Unfortunately you would have...

I'm sorry, Luigi, I don't understand where values 11-31 come from.

Can you explain it in other words please?

I guess you're Italian: I don't think we will be reprimanded for a...

At last!

I'm glad you got it working.

Interesting question.

Has any of you solved this problem before? I would like to see your opinions.

What I have set up is very simple. Some applications share a key generator, in order to ensure key uniqueness.

The keys are generated by a SQL Server 2005 stored...

OK, looks like you need to filter the whole data set this way:

CREATE PROCEDURE yourProcedureNameGoesHere

@WaySide VARCHAR(50)

AS

BEGIN

SET NOCOUNT ON

SELECT ( Grp.name +...

Without seeing the actual code, I can only guess it involves a double sort (one ascending, one descending) prior to the sequence project steps. It could get expensive.

Can you post...

I'm trying real hard, but no success.

Am I asking the wrong way?

I'm going home now, I feel like giving up.

OK, let's take it one step at a time.

CREATE PROCEDURE yourProcedureNameGoesHere

@WaySide VARCHAR(50)

AS

BEGIN

SET NOCOUNT ON

SELECT ( SELECT name +...

Ok, so let's take next step:

DECLARE @WaySide varchar(50)

SET @WaySide = 'Redondo'

SELECT ( SELECT name + ',' + state

...

That's what I meant.

Obviously you have to put the parameter name in there.

OK, let's try from scatch: copy and paste the query in a new query editor window.

Replace @Wayside with the actual...