for once i agree with celko on the point its bad design. if you look at all your tables you have the exact same columns in each. since...

Touchdown and field goal

(ok more than one word...

; WITH CTE AS (select ROW_NUMBER () OVER (PARTITION BY testCol ORDER BY (SELECT NULL)) row, * from testPartition)

SELECT testcol, CASE WHEN row = 1 then 'first' ELSE CAST(row AS...

something like this maby:

SELECT *

FROM TableA a

LEFT JOIN TableB b

ON a.empid = b.empid

AND a.code = b.code

WHERE b.empid IS...

Forum Saint

bucky balls (SP)

ok something like this may work:

UPDATE #Temp1 SET t1.mtd = ISNULL(t1.mtd, t2.mtd), t1.ytd = ISNULL(t1.ytd,t2.ytd)

FROM #Temp1 t1

LEFT JOIN #Temp2 t2

ON t1.id = t2.id

WHERE t1.mtd IS NULL

...

Lynn Pettis (4/20/2012)

---

Just read Riya_Dave's latest post, just more of the same "I'll repost what I have already posted, maybe with a few minor but incomrehensible changes."

I wanted to say...

finally we are close to answering one question, can you post your DDL for #Temp2. im not sure how it relates to 1003 and 1004 in temp1. should...

inner tubes

riya_dave (4/19/2012)

---

Lynn, i have seen your post to every thread,instead of helping , you just posting your stranded one to everybody.

thats so annoying . and i dont except any response...

ON TOPIC: http://www.sqlservercentral.com/Forums/Topic1286816-392-1.aspx Lynn are you really going to try again. i wonder where your troll feeding sponser is. LOL 😀

GilaMonster (4/19/2012)

---

Personally I'm voting for 'ignore the trolls'

#declare NewTopic;

Who plays MMOs and which ones?

I've just quit the one I played for a few years, they added a 'pay to...

========== ORIGINAL METHOD ======================================================

SQL Server Execution Times:

CPU time = 9251 ms, elapsed time = 9267 ms.

========== With out PATINDEX =======================================================

SQL Server Execution Times:

...

The Dixie Flatline (4/19/2012)

---

Okay, I will apologize for bringing this up in the Thread. But I'm getting tired of writing private messages.

Yes, Gail, I was at the last Summit...