Interesting. I can't reproduce it in this way. Apparently, I'm going insane. 🙁

Interesting. We're seeing evidence that when the table variable is used directly in the stored procedure assigned to the SB queue, the data does not get cleared out. We experienced...

What do you think about using this in a trigger to find what has actually changed during a DML statement?

Did you ever find a solution for this problem?

Thanks. I've already got a request in to VMWare for such testimonials. From the links provided by the search result, which would you say is a real-world testimonial? I see...

That's all well and good, but I need to be able to adjust to a parameter that specifies a maximum number of records per file. In other words, the number...

Hey, thanks for the smart-*** remark. I'm looking for alternatives to using a cursor here. If you have an idea, I'd like to hear it.

Yeah, thanks. This isn't like my production code. I was just trying to generalize an example while I was on the train home from work. Sorry if it wasn't perfect....

Hey thanks for the compliment. I was doing my best, trying to type it in on my phone on the train home from work. But thanks again. Also, Lynn's cross...

Yep, exactly. Thanks.

Forget about the table I initially mentioned. I generalized it down to those in my last post (and, actually, I'm going to generalize it even further to get rid of...

Ok, let me give the whole picture.

I have three tables - Queue, Tasks, and QueueTaskLink

CREATE TABLE Queue

(

QueueId INT NOT NULL PRIMARY KEY IDENTITY(1,1),

MaximumQueueLength INT...

Ok, right..but if I have multiple queues, each with a different MaximumQueueLength, how would I use TOP without using either a cursor or dynamic SQL?

Oh! I see! I will try that out, thanks!

Yeah, there is a reason for it. There's also a reason why I'm doing these through SSIS and not a command line. We developed a rather sophisticated queueing and throttling...