DBAgal (1/26/2012)

---

Below is part of the query structure. There are 14 CROSS JOINS and 5 INNER JOINS in the entire query. It touches many tables and...

2 options.

1. Use "ISNULL(field,0)" on each field.

or

2. Modify the table/load procedure to default a "0.00" on each field and mark as NOT NULL. This option will require...

Very well written article, I hope to see more about service broker in the future. As to implementations of Service Broker, basically it's only as complicated as you...

MasterDB (12/3/2011)

---

Hi Experts,

since two days am facing problem with service broker. its just like data is not dequeuing from queue.

usually data should dequeued automatically,but since two days data is enqueing...

You need to add join criteria. so your query would be something like

...

FROM A INNER JOIN

B ON A.ID = B.ID

WHERE...

notoriousdba (10/25/2011)

---

No, no different queues. All messages are going into the same service in the source database, to be delivered to the same service on the target database.

Let me...

I'm not an expert but I'd take a look at your joins. You join to Partnership which has multiple rows for ID 1, then join to the other tables...

Mike,

For option 1, Use a view in place of the CTE. That's all it's doing is providing a query on the Data.

OP can correct, but it looks like you start at the top. Select the first row that is "D" and the first row of "A" that have matching DataKeys....

Kraig,

I think what it's analyzing is on the whole find all pairs that match DataKey and have opposite Types. Any "orphan" or "single" DataKey is "Not a dup". ...

hm... not has hard as I might have thought...

UPDATE #TestTBL SET DupInd = -2;

WITH mycte AS (

SELECT

Row = ROW_NUMBER() OVER (PARTITION BY [datakey] ORDER BY [RecID]),

[RecID], [DataKey], [DupInd]

FROM

#TestTBL

WHERE

TransCode = 'A'

),

mycte2...

If I may, that won't be an easy one to do. You might want to have a look at the cumulative update or running total articles by Jeff Moden...

Here's the Query plan for both... it shows both batches.

Sounds like a home work question, so this is a very very basic SQL update with case statement. You should be able to start there.

I found that XQuery tends to be slow... so when I've had to parse XML I used OPENXML and the edge tables to parse it... it's basically a 1 time...