Based upon an old SP I have I came up with this:

ALTER PROCEDURE [dbo].[sp_Read]

AS

BEGIN

declare @sSQL varchar(5000)

set @sSQL = COALESCE(@sSQL + ' ','')

create table #MyHead (

Pr_Id int,

Pr_Em_Id int,

Pr_Em_Name nvarchar(50),

SortBy int,

Random int...

The desire output is this:

1) What I am showing in list1 and list2 is what I am expecting to get

2) Pr_Id is the product id, Pr_Em_Id is the provider id

I guess I was no thinking clearly when writing. It is a question,...

It sounds I'll got that way. Thanks Tom.

Jeff,

Pretty impressive stuff. I made a change to your code as I had a problem with your solution in the order by. Keep in mind that the idea of this...

It looks I got something from another forum

Select FROM @tt AS t

ORDER BY (select count(*) From @tt as y where y.Pr_RealEstateAgent_Id = t.Pr_RealEstateAgent_Id and y.pr_id...

I think that ROW_NUMBER is a SQL Server 2005 and in my case I am using a SQL Server 2000

r.hensbergen...

You're right that in this case I do not need dynamic SQL. I'll follow up your suggestion in the BOL for the other case where I really need it.

Issue is solved !!!

The solution was a registry cleaning before installing SQL Server 2005. Got it here: http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

The (....) thing is starting really to (......) :angry:

I first installed SQL Server 2005 without the Workstation components and it went thru just fine.

The SSCM is up and working....

Can't find any reference to SQL Server Express edition

On my machine I just have SQL Server 2000.

I don't remember having installed SQL Server 2005 Express , I ran the Visual Studio 2005 install maintenance and at least the...

I think I could have spend days and *never* will be able to get this.

Still I am having and issue if tblTestsDone is empty the query doesn't return the...

Homework ? Not at all. Let's say that between house building and moving August and September...