Touched.

It will still be tricky, even with a full...

What's confusing folks here is that this sample datainsert into #sample

select '11003291001-----NOB30000','0V003','A00A00',269,285,305,1 union all

select '11003291001-----NOB30000','03003','A00A00',287,30,305,2

is both an order and a description of the available stock. Split them out and...

Thanks for the ddl and dml, it makes a real difference. I'd recommend you split this into two steps. It will make the end result easier to understand, test and...

Can you please read the...

The SELECT query is no longer using index IX_suspect_status_rsn_shipopt, it's now using IX_sessionID, same as the UDATE query, because of the changes made in the last iteration. Using IX_sessionID, the...

-- Some reformatting to make the code easier to read

-- and a small change to make the logic a little easier to follow.

-- Please check that this query returns the...

Try modifying this instead;

;WITH Dupechecker AS (

SELECT ID, NUM, ECD, ?,

dupecount = COUNT(*) OVER(PARTITION BY Col1,Col2,COl3,COl4)

FROM Table_A

WHERE ID = 5628

)

INSERT INTO table_b (A,B, C, D)

SELECT

ID, NUM, ECD,

ERR_MSG_TXT...

Yes, it will work.

You will have to correct...

-- why...

You've listed 7 columns in table A in your query - it would help us if you were to correct the column names.

Neither, use OVER() with COUNT:

;WITH Dupechecker AS (

SELECT

A.ID,

A.NUM,

A.ECD,

Col1||Col2||Col3||Col4 as ERR_MSG_TXT,

dupecount = COUNT(*) OVER(PARTITION BY Col1,Col2,COl3,COl4)

FROM Table_A

WHERE A.ID = 5628

)

SELECT *

FROM Dupechecker

WHERE dupecount > 1

kmundt (3/28/2013)

---

The status is always being set, because I require them in .NET to select something, but even when they select both and it's 'B' it just selects the Closed...

You will need to a) read...

Are...

Please run this query and post the result:

SELECT COUNT(*)

FROM [DI81SW].[CNET_EXP].[dbo].[NOYAU_NUM_TELEPHONE] AS CNet WITH (NOLOCK)

WHERE (CNet.[SMS] = 1)