This is the data sample, I just display what I need.

DATA_CODE REEL_NO

M10 1138935111

E10 1138935111

M10 113893511L

E30 113893511L

M10 113893511R

Z20 113893511R

M10 1138935XXX

E10 1138935125

E30 1139032102

Z20 1139081101

I want to check if M10 with reel_no...

Sorry my English is bad...:-D

I want display about 150K records and select among 1M records

it's for report purpose

the schema is

CREATE TABLE [dbo].[StockIOData] (

[DATA_CODE] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL...

now I have a problem with that query,

it takes a long time and my application display request timed out...because I have a huge number of record...

so can you give...

Thank you

it really help me....

🙂

3 codes, I mean for checking by three codes

M10 which not have one of E10, E30, or Z20 vice versa

so I need to select data Which have one number

CODE ...

@ lyn, thank you,

I have tried your query, and it work, but i have another problem if it have to check among 3 code...

CODENumberQty

M10 S0001100

E10S0001100

M10S0002200

E30S0002200

M10S0003300

Z20S0003300

M10 S90011000

Z20 S90021000

E10 S90031000

E30 S90041000

SELECT stockIoData.*

FROM stockIoData INNER JOIN

...