Thanks guys, just made one change to sort by the original sortOrder field instead of by ID. Worked on the sample data but sometimes the sortorder isn't in the same...

Here is the script to insert the test data:

INSERT INTO rentalsTEST

(userID, movieID, sortOrder)

SELECT 1,22,3 UNION ALL

SELECT 1,45,5 UNION ALL

SELECT 1,867,6 UNION ALL

SELECT 2,4,1 UNION ALL

SELECT 2,24,3 UNION ALL

SELECT 2,99,4...

Here is the create table script:

CREATE TABLE [dbo].[rentalsTEST](

[ID] [int] IDENTITY(1,1) NOT NULL,

[userID] [int] NULL,

[movieID] [int] NULL,

[sortOrder] [int] NULL

CONSTRAINT [PK_rentalsTEST] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF,...

Hi Esben, Did you get an answer on this?  We are trying to do the same thing.

There are a couple of factors that led to the current setup -

1. The system was originally designed to handle a couple of hundred codes but the requirements ballooned after a...

Thanks guys, somehow I thought that Varchar(Max) variable had an 8000 character limit, but that's great that it doesn't.  The original issue was discovered when I had the variable set to...

To update, I have decided to approach this problem from a slightly different angle.  Instead of utilizing an on-going direct link between the new system I am creating, and the...

Hi Ninja, I have tried out the DIFFERENCE function, but it's not going to be accurate enough.  For example, "Joes Hardware" vs. "Joes Hardware 123" is a 4, and "Joes...

Hi Sreejith,

I am working with your solution and came across a situation that isn't handled the way I would like it to be.  If the table1 list of customers contains...

Thanks, that's perfect!

Thanks Tim, That works great.

Here is the full original code for the query:

SELECT     UpdateSections_1.SectionTitle AS ParentSectionTitle, UpdateSections_1.ID AS ParentSectionID, dbo.UpdateSections.SectionTitle,

                      dbo.UpdateSections.ID AS SectionID, dbo.Updates.ID AS UpdateID, dbo.Updates.PicFile, dbo.Updates.datetimeadded

    , 

  MAX(CASE LangID WHEN 1 then  dbo.UpdateDetails.UpdateTitle...

In this case I don't need to aggregate on the text field.  The details table that contains UpdateContent has a primary key (UpdateID, LanguageID) and I just need to group...

Peter, you're version gives me what I was looking for.  Thanks for your help guys,

Andrew

The notion of "American car" vs. "Import" these days tends to be more about where head office is located than where the car is actually built anyway.  And with all...