Another information that has been asked for is the actual execution plan.

As a pot shot I would probably extract the relevant data from Medication and Allergy into a temp table...

GilaMonster (9/16/2011)

---

I suspect this got lost in all the 'helping Grant abuse SQL' posts...

Another request:

I'm bunking tonight and starting the rewrite of my rather old (and second-ever) article Managing Transaction...

Here's what Rusanu answered:

Some internal tasks follow a pattern of starting a transaction, looking for work to do, exit if no work. When they do so they are causing the...

What exactly is the problem? Is there any error message?

What is the output of select * from @qtttab in the "problem section"?

If there are more than one row in @qtttab...

As per Remus Rusanu the increase of the counter is harmless and is no indication of a problem. Once I have permission I'll post his reply.

His explanation and what you've...

That doesn't really answer the questions.

There are several things wrong with the table design as well as the concept in...

Just leaves a few more questions to answer 😉

What exactly is your question?

And what is the purpose of this table? To me it seems a little strange....

Grant Fritchey (9/14/2011)

---

Changing the topic for a moment, I'd like to beg some ideas from the group, again.

I'm tasked with writing another article. This one is all about the scary,...

First of all, please provide the table def for #CustomerInfo so your script can actually be used (we would have to guess the data type you're using).

Also, please note that...

Unfortunately, the dummy data are still not valid.

But here's an example of what you might look for (as a side note: please notice how I present the sample data...

Very well deserved, Jeff!!

Thank you for you continous help. I've learned a lot from your posts and...

Please be a little more specific.

Usually, you would use SELECT col1, col2 ... FROM YourTable.

But that sounds too basic to be the question here... Or are we talking about homework?

Unfortunately, SQL 2000 doesn't offer that many options.

One solution I can think of is to use a function.

An example can be found at Adam Machanics blog

David Walker-409102 (9/13/2011)

---

Thank you, Lutz for your quick reply. I'm reading the two articles on cross-tabs and they look promising. I'm not sure what you mean by having...