Have a splendid holiday Mr C - you've...

I reckon the OP is having some difficulty simplifying the real problem. Here's a solution to the "new" requirements;

;WITH Mysample (Record_id, Col1, Col2, Col3,...

Brandie Tarvin (10/17/2012)

---

It's a disgrace, a disgrace I say. Why do you want to know what I know I know? It's a disgrace, a disgrace I say.

Young fella, do you...

Andy Hyslop (10/17/2012)

---

Complex SSIS packages are more likely to increase maintenance cost than decrease it, because there are far more places to look for functionality, and more scope for introducing...

You have two sequence columns in your table - do either of them have gaps? If one of them is guaranteed to have no gaps, then join the table to...

CROSS APPLY VALUES[/url] was made for this;

;WITH Mysample (Record_id, Col1, Col2, Col3, Col4, Col5) AS (

SELECT 101, 'A', 'A', 'B', 'A', 'A' UNION ALL

SELECT 102, 'B', 'B', NULL, NULL, 'B'...

There may be some scope for improvement here. That's...

deepa lekshmi (10/17/2012)

---

Rob, We are asked to do that since the long procedures are not easy to manage. Also, wanted to improve the performance. I am not sure whether converting...

Eric M Russell (10/15/2012)

---

You can simulate the functional equivalent in SQL Server 2000 less gracefully like so:

select C_RECID, H_RECID from

(

select C.RECID C_RECID, H.RECID H_RECID,

(select count(*) from...

Duplicate post. Answers to http://www.sqlservercentral.com/Forums/FindPost1373217.aspx please.

kapil_kk (10/16/2012)

---

hey Chris,

can you plz tell me why you placed this line -

INNER JOIN (select fstate from WCDentalSQL_TOR..ZipCode GROUP BY fstate) d ON d.fstate = Z.fState

I am not clear with...

Eugene Elutin (10/16/2012)

---

...

So, TVF's one is faster than permanent table! Faster by the whole 33ms!

And here I would agree with Joe (that doesn't happen to often ;-)): what about concurrent...

Your cursor block is running slowly because you...

Why?

kwoznica (10/16/2012)

---

Definately does. I was confused by the additional d and f in the inner and outer queries and thought they were needed for some reason in...