Not sure, but I think this article may help, give it a read and see if it helps: http://www.sqlservercentral.com/articles/T-SQL/63003/

The problem is here:

"Subquery

returned more than 1 value. This is not permitted when the subquery follows

=, !=, = or when the subquery is used as an expression."....

DHeath (1/27/2009)

---

So my question is this..if you have 64Bit MSSQL Ent Edition why would you need AWE if you are running with 64Bit Ent Edition OS. Considering that the...

Grant Fritchey (1/27/2009)

---

Steve Jones - Editor (1/27/2009)

---

Grant, that was a cheap post, course, I probably have a few as well.

Lynn has a good point. Writing coherently, even giving someone a...

David Jackson (1/27/2009)

---

Lynn Pettis (1/27/2009)

---

I am sure this is in response to the following:

I received a private message...

GilaMonster (1/27/2009)

---

Bob Hovious (1/27/2009)

---

One more post towards 1000.... and close to the original topic here. How many people get annoyed by people who cut and paste data rather...

If the OP's provide us with the information we request (how many times have we as a group pointed OP's to Jeff's article), we usually provide back tested solutions. ...

I'll have to check those out from home. Unfortunately most blog sites get blocked here at work.

Hey, occasionally, yes in character I must be.

For the most part, when actually getting into a discussion with others, I try...

I am sure this is in response to the following:

I received a private message with a question regarding...

And I'm forgetting my manners. Thank you, it makes...

I received a private message with a question regarding my article that I can't answer, so I thought I'd put it here with the hopes that some of the gurus...

noeld (1/27/2009)

---

I liked your article ( a lot ) and it seems that you put a lot of effort into it.

My view of running totals is simple. It is a...

Smendle (1/27/2009)

---

I wish I had a true single processor system (no hyper threading or multiple cores) to have tested this on to see how it worked. Would I have...

The last two articles linked in my signature block may be of help. Give them a quick read and let me know if they do.