Craig,

Ah, that's an excellent idea. I should have thought of that. Thanks!

BTW, no, the messages being sent aren't in the same conversation, but what I found is that this is...

Sure thing. I'm glad you solved your problem.

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 be...

We'd have to see how you set up your endpoints, etc. Though I imagine at this point you've either solved your problem or given up.

Hi Joe,

CELKO (10/14/2011)

---

[...]

link_id INTEGER NULL IDENTITY(1,1),

IDENTITY is the count of physical insertions attempts on one machine. It is no more a part of ta valid data model than the...

Ha! That's not saying...

SpringTownDBA,

Any particular reason you chose CTEs over, say, derived tables? I guess I'm wondering if there are performance implications, or if that was just your personal preference. For me, in...

Performace Guard (Shehap) (10/14/2011)

---

If you need the cluster having the maximum value of count of variety id , you could try it below:

select Max (s.varietycount)as Max_cluster from

...

SELECT a.CustomerID, COALESCE(SUM(b.Total), 0) Total

FROM Customer a

LEFT JOIN Order b

ON b.CustomerID = a.CustomerID

GROUP BY...

SELECT COALESCE(b.name, '') name

FROM (SELECT 'XYZ' name) a

LEFT JOIN tableA b

ON b.name = a.name

I'd typically use a temp table to pass a bunch of results to another sp, the way Ninja's_RGR'us suggested. But if you're stuck on passing the data in as a...

If you're looking for the count of distinct donors per org, then your results are correct. If you're looking for the count of distinct donors, that's something else entirely. I...

...

But I am not getting the correct decrypted data when I run the last query.

Please correct me if I am wrong at any step and let me the neccessary changes...

SELECT a.eid, a.fname, a.lname, SUM(CASE b.estatus WHEN 'good' THEN b.points END) points1,

SUM(CASE b.estatus WHEN 'verygood' THEN b.points END) points2

FROM #mytable1 a

...

Thank you VERY much!