After looking at it some more... perhaps the reason you are getting wrong results is that you are trying to do dynamic SQL within dynamic SQL.

Try this instead:

DECLARE @q Nvarchar(max)...

Hi abhas,

Let me ask because it is not clear. Where is "#tempTable" created?

If you are receiving an error, please post the exact error message you are receiving. It...

Good Lord... RAMDisk for Indexing? Are they stupid? I have no words.

Gazareth (9/15/2014)

---

GilaMonster (9/14/2014)

---

Sometimes advice on a blog still scares me. Not often, but sometimes. Like today

Consider using...

It is correct that it does that. However, you shouldn't be afraid to use it! Every xml document must be opened in a likewise manner. You simply...

So 200 columns in a list, and you split it to new lines at what, 80 characters? What is this a Ribbon Printer from 1970? Ah, you leave...

natasha.reiki,

Based on your description "Published Before 1920" OR "a loan before 03/Jan/2004" your code should return correctly.

I recommend to not use RIGHT OUTER JOIN as it can be confusing. ...

I must admit, I find it funny that Mr. Celko sees fit to break ANSI standard when he bashes other people for not adhering to it. Why are you...

You are correct Adam. My brain flubbed.

Adam Hardy-416657 (9/1/2014)

---

Hi again Venoym,

Could I get your advice on an appropriate fix?

The functionality behind this service broker implementation is to log messages occuring from remote sites. Basically the remote...

TomThomson (9/1/2014)

---

Luis Cazares (9/1/2014)

---

Eirikur Eiriksson (9/1/2014)

---

Now he has put the bat aside and instead...

CELKO (9/1/2014)

---

HIPPA. You must record everyone who saw the medical record, not changed it, saw it. I could not carry my own sonogram...

Evil Kraig F (8/29/2014)

---

Anybody with a solid level of experience in Service Broker able to help someone out? He's new to the site but he's definitely providing what we...

I must also smile when I read that bit of code. It seems that Remus's example code is what everyone learns Service Broker on. And it's also the...

The answer is deceptively simple. RECEIVE will only pull back up to 1000 messages from a single Conversation from a queue. You can check by doing a

SELECT conversation_handle,...

Sounds like you have Triggers and (maybe) Nested Triggers disabled on either the table or the database. I'd check the database configuration first. I don't have SQL Server...