tosscrosby-60625 (1/15/2010)

---

Gail, you know the answer, give the users the ability to kill the offending SPID! Clean and simple solution to keep things quiet while the OP searches madly for...

What would help is if you would post the table definition(s) (CREATE TABLE statement(s)), some sample data (series of INSERT INTO statements for the table(s)), and the expected results of...

Why and how do you feel that an experienced DBA tried to embarrass you during an interview?

Specific examples would be benifical.

Have to agree, who better to evaluate the skills/knowledge of DBA but an experienced DBA? Would you rather a developer (read that as programmer) do the evaluation, or maybe...

It also depends on wether or not you plan on using the view in other procedures. If so, creating the view would make reuse of the select statment easier.

You say your database isn't using transactions. Are you running INSERT, UPDATE, and DELETE statements in the database? If so, you are using transactions. You may not...

The WHERE clause would filter the result set returned from the JOIN of the two tables. Any filtering done on the transaction table would in effect turn the left...

bwillsie-842793 (1/14/2010)

---

Lynn Pettis (1/14/2010)

---

Now you are talking card punches. Used one in high school as well as in the Air Force. Actually ran a Burroughs B3500 for 4...

Nice catch, Gail. My mind is still on my linked server problem and didn't see that.

select

mbd.Trade_ID,

ISNULL(SUM(t.amount), 0) AS Purch

from

...

SUGAR

Give this a try:

select

t.Buyer,

ISNULL(SUM(t.amount), 0) AS Purch

from

dbo.Member_Base_Data mbd

left outer join dbo.Transactions t

...

bwillsie-842793 (1/14/2010)

---

Oh yeah, you...

Curious how you would use a subroutine in T-SQL. Can you show an example of how this would work if it were possible?

How is the code being used, in a stored procedure?

ifila (1/14/2010)

---

david.tyler (1/14/2010)

---

I wouldn't waste time on clowns that are obviously not professionals. This site houses professionals helping other professionals. There are professionals with varying levels of experience and then...