BWFC (1/2/2015)

---

ChrisM@Work (1/2/2015)

---

Thanks.

Query 1 (insert into #temp_violation etc.) has an odd filter:

and

(

cast(fh.startdate as date)<= cast(tv.startdate as date)

and

cast(fh.startdate as time)<= cast(tv.startdate as time)

)

This will capture datetimes from fh where...

Thanks.

Query 1 (insert into #temp_violation etc.) has an odd filter:

and

(

cast(fh.startdate as date)<= cast(tv.startdate as date)

and

cast(fh.startdate as time)<= cast(tv.startdate as time)

)

This will capture datetimes from fh where they are...

Can you post the execution plan?

Have you considered using EXISTS

WHERE EXISTS (SELECT 1 FROM #temp_violation t WHERE t.orderno = so.eai_orderno_int)

rather than IN

where so.eai_orderno_int in (select orderno from...

Please provide a sample data script. Not only will this give folks a better idea of how your data looks, it will also encourage them to participate. A dozen rows...

You get it...

I found the same, with the test data...

SELECT

b.*,

a.*

FROM #tbl_Team a

INNER JOIN #tbl_Team b ON b.id < a.id

ORDER BY b.id, a.id

The outer select in the OP's original query isn't aggregated:

SELECT

w.uompScheduleNumber,

COLOR = CASE w.uompScheduleColor

WHEN 'NEON' then 'ORANGERED'

WHEN 'PINK' THEN 'FUCHSIA'

ELSE w.uompScheduleColor END,

x.Printed,

x.Audited,

x.Shortage_Prt,

x.Red,

x.Neon,

x.QC_Hold

...

You may get some ideas from this:

;WITH

E1 AS (SELECT n = 0 FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) d (n)),

iTally AS (SELECT n = ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) FROM E1 a,...

Arthur Olcot (12/11/2014)

---

BWFC (12/11/2014)

---

The answer might be in the title, but as a newbie I went through my usual process of reading...

Can you post up the estimated plan for the query?

Easy enough to do as others have shown - but why turn a valid address into an invalid one?

Child2 table has nothing to indicate which row should be chosen when say row2 is requested - you cannot rely on the order in which you think the rows sit...

Couple of questions:

Is ID the PK of either of the source tables?

Can you provide a few rows of sample data please?

Thanks.

ssandeepksh (12/5/2014)

---

Hi,

Can you please help to solve this?

I have a table with many identical rows which has different numerical value only in once column.

I want these two or more identical...