Viewing 15 posts - 1 through 15 (of 73 total)
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...
May 21, 2008 at 10:59 am
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...
May 21, 2008 at 7:18 am
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,...
May 21, 2008 at 6:55 am
Hi Esben, Did you get an answer on this? We are trying to do the same thing.
September 21, 2007 at 8:30 am
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...
September 10, 2007 at 9:54 am
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...
September 7, 2007 at 2:50 pm
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...
November 9, 2006 at 5:17 pm
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...
November 9, 2006 at 12:08 pm
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...
November 9, 2006 at 10:00 am
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...
July 10, 2006 at 8:36 am
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...
July 8, 2006 at 10:21 am
Peter, you're version gives me what I was looking for. Thanks for your help guys,
Andrew
June 12, 2006 at 12:09 pm
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...
June 12, 2006 at 7:44 am
Viewing 15 posts - 1 through 15 (of 73 total)