Hear Hear, Jeff!

And to add another catch phrase ... "You catch more flies with honey than with vinegar" 😀

My opinion is the INNER JOIN method above is more straight forward, but then again I'm biased 😀

Move this into an INNER JOIN

SELECT SUM(EnrollCnt)

FROM ReportA

INNER JOIN Branch

ON (@ReportType = 1 AND BranchID = '10000023')

...

In SQL 2000 the only practical way to INSERT and UPDATE data in/into a table is with two individual statements. In 2005, the MERGE command can be used. I'm not...

*hint* you can format your SQL by placing

"["code"]"

... your code here ...

"[/"code"]"

OK, if I've read your code correctly, you are updating all of the theText fields to...

While I look at this, here's an answer to your question ....

Well, the rule of thumb is that there is no rule of thumb. :w00t:

Each and every problem has many...

zamiran,

First of all, welcome to the site!

Secondly, can you post a bit more on what your wanting to do? In this case, give us the INSERT and UPDATE statements you're...

You will not get an advantage when returning one row. This Hint is used for large (time intensive) result sets.

If you think it through logically, if you had more than one INSTEAD OF trigger, how would the SQL Engine know which one to use? On the other hand, an...

Try reversing the direction of your JOIN.

SELECT

MemDetail.Allocation AS Alloc,

SUM(ISNULL(vwTransactions.ActQuantity, 0)) AS UsedUp,

vwTransactions.MemberID,

MONTH(vwTransactions.TransDate) AS...

It's briefly mention in this article and appears to return the first row of a result set to the user/application without waiting for the entire query to complete.

http://www.sqlservercentral.com/articles/Performance+Tuning/tablehints/667/

No, you can not define the alias in the UPDATE section, you need it defined in the FROM part of the statement.

UPDATE a

SET

a.BI_SSN = b.BI_SSN

FROM CIS_IVR_Master_200712100600 a

...

One difference is that NVARCHAR and VARCHAR store data differently. NVARCHAR uses two bytes per character vs. VARCHAR which stores it as one.

as in my example code ....

DECLARE @varChar VARCHAR(5)

DECLARE...

Well, it's past my bed time. Just gave up on watching the Colts vs. Ravens... GO COLTS!

I can't help you tonight, but play around on your development bax. Look into...