I understand...

Wow. Took me trying this on my end to see whic column you're talking about. Here's one way to do what you're looking for:

Select (

...

chrono34 (5/28/2008)

---

I gave that a try, but now it returns total results that are way off from what I need... And by way off, I mean the results *should* be...

I believe you only get those if you don't give a column an alias, or if you have duplicate aliases. Make sure that those columns have actual names (or...

The fact there there might be open transactions open at any given time isn't the problem. The problem would be if it's the SAME transaction that's never getting committed....

chrono34 (5/28/2008)

---

AnswerID will never be null. AnswerID is an index that looks up against SurveyChoices. Maybe I didn't make the layout totally clear... wouldn't be the first time...

Using the parameters...

You will likely want to enable TCP/IP and/or named pipes. That's done from within the Surface Area Configuration tool.

I would personally tell the client NOT to use Shared Memory...

Believe it or not - you should be able to do all of that in a single query statement these days, using an AVERAGE() OVER on the summed expressions.

Something like:

;with...

Stef Evans (5/28/2008)

---

With T-SQL, can one use the results of a stored procedure within an expression inside a SELECT statement? Or would a table-valued function be in order?

Here’s a...

Jeff Moden (5/27/2008)

---

There are exceptions, especially amongst friends. But some of these folks' arrogance is just beyond me... like I said, it must just be a difference in language...

Anirban Paul (5/28/2008)

---

Loner (5/28/2008)

---

I heard a lot of managers said IT was not a profit generating department, not liked sales. So when the company is not doing good, it...

Anirban Paul (5/28/2008)

---

Well said Jeff. I am lucky to be in a good co (Till now) and with a good boss. But I also have bad experience. One of my...

Jeff Moden (5/28/2008)

---

Doesn't matter... I have some fellow Americans that I can't understand sometimes... I do just like I would do with anyone else... I say "I heard you, but...

majorbloodnock (5/28/2008)

---

Robert Hermsen (5/27/2008)

---

Being in a DBA role which supports a lot of customers...

we used to have a great test for anyone interviewing for a position. over the phone...

GilaMonster (5/27/2008)

---

By default triggers cannot fire themselves. (recursive triggers disabled) so 2 rows will go in, but the second won't fire the trigger

If you have recursive triggers enabled then the...