Actually, that is not what this paper says. In fact it give a...

The plan you use should be based on the needs and specifications.

Lets start with a few obligatory questions: Why was Service Broker chosen as the solution instead of :...

I would probably agree with you: keeping it readable is worthwhile.

You could also consider storing it in VARBINARY() and use a fnBinToB36() udf to display it and a corrsponding fnB36ToBin()...

Glad we could help.

Jonathan Kehayias (12/17/2008)

---

Just go read the SQLCLR forums and you will find a whole new level of WOW. I learned a whole lot about what not to do, trying...

That's why they only Talk the Talk.

😛

Actually, you can restrict them to stored procedures, just like an application is supposed to be, but that still has two problems:

1) That is rarely what is wanted for a...

Sorry Jon, I misread earlier.

MG (12/17/2008)

---

Anyone else get a shiver?

All it takes is one person looking over your shoulder and you could be in real deep. I hope one of those jobs wasn't...

MG (12/17/2008)

---

Another method would be to use VBA in Outlook. At one point, I wrote a couple of VBA macros that examined the Subject line of mail addressed to me...

Neat! Thanks for sharing, Jeff.

David Mrazek (12/16/2008)

---

---- because of the queue in second and others front end dosnt work - I didnt send the code what i have in stored procedure (where are recievied,...

Lynn Pettis (12/16/2008)

---

bitbucket (12/16/2008)

---

Jeff

Jeff should I be proud of this...

Looks good to me.

By the way, thanks for taking the time to provide the table definition and sample data, it really...

Here's a start:

Select

id, Rno, Count(*)

From #temp1

Group By id, Rno