Okay. Curious if the OP on anther thread is ever going to say anything. Asks for help and doesn't quite provide enough to help. Posts data and...

Here is another option to try:

create table dbo.valuetab

(

startpoint int,

stoppoint int,

value int

)

insert dbo.valuetab ( value, startpoint, stoppoint )

select 1, 0, 10 union

select 1, 10, 15 union

select 2, 15, 25 union

select 2,...

I was also able to duplicate your results using a LEFT OUT JOIN. Interesting results in the execution plan.

Code first:

select

c.operator,

c.unit,

...

Another issue that may affect performance, a data type mismatch. In the DDL you provided SN is declared differently between the two tables:

[dbo].[Test_completedUnit]

[SN] [varchar](50) PRIMARY KEY NOT NULL,

[dbo].[Test_assemblyQC]

...

Hadn't had a chance to work your problem before you posted your solution, but having found a little time I was able to modify your solution. I also had...

kabaari (7/10/2014)

---

Lynn,

Will this work? I really appreciate the assistance!!!

CREATE TABLE

[dbo].[Test_completedUnit](

[unit] [nvarchar](4) NOT NULL,

[operator] [nvarchar](50) NULL,

[SN] [varchar](50) PRIMARY KEY NOT NULL,

[Workorder][varchar](7)NOT NULL

)

INSERT INTO test_completedUnit

(unit, workorder, operator, sn)

SELECT '01','17879','VERHEY, CHARLES','05201417879001' UNION...

david.vandiver (7/9/2014)

---

We have recently moved to new hardware and have a similar message. Did you have a solution that worked when this happened in 2010?

Our message is:

File: E:\pt85012b-retail\peopletools\SRC\pssys\gensql.cppSQL error....

If the customer number is always 6 numeric characters immediately followed by the customer name and the string is surrounded in double quotes with the end double quote separated from...

If you would post the DDL (CREATE TABLE statement) for the tables involved, some sample data (INSERT INTO statements) that is representative of your problem domain, the expected results based...

Really not enough information to help you. If you can post the DDL (CREATE TABLE statement) for the table(s) involved, sample data (INSERT INTO statements) that are representative of...

With out DDL (provided), sample data, expected results, and what you have already done and/or tried I wouldn't even know where to start. Remember you see what you have...

The Dixie Flatline (7/8/2014)

---

wolfkillj (7/8/2014)

---

wolfkillj (7/8/2014)

---

GilaMonster (7/8/2014)

---

🙁 EVE hasn't taken over my...

Using SQL Server 2000 will make things more difficult. You don't have access to the windowing function row_number() for one.

I will think if I can come up with another...

Guess I should of checked before posting since I got distracted by a code walk through with my tech lead.

First, I reformatted the code to use ANSI-92 style joins instead of ANSI-89 style joins. Did this to verify that there was no accidental cross join due to a...