Based on the logic, yes, the procedure exited prior to attempting the update.

Roland Alexander STL (10/5/2012)

---

The RETURN function can return a value to the caller, but it is up to the caller to capture and process the value:

EXEC @return = dbo.my_procedure;

In this...

The RETURN function can return a value to the caller, but it is up to the caller to capture and process the value:

EXEC @return = dbo.my_procedure;

In this case, (2) is...

If what you are trying to do is get the first day of the following month try this:

DATEADD(month, DATEDIFF(month, 0, getdate()) + 1, '');

Also, you should know that SQL Server...

You're getting an error because the CASE statement needs to be enclosed in parentheses.

norbert.manyi (10/2/2012)

---

Take the following example:

select * from tbl_Users U where U.active = 1 and U.deleted = 0

It seems that the application owner keeps changing the business logic, so I would...

Just as an FYI - anything that can be done from Management Studio can be done from VS, provided you have the Ultimate or Database Edition (you didn't mention your...

An alternate:

create table #tmp (status_id int, status_code char(1), status_sequence int);

insert into #tmp

values

(1, 'A', 1),

(1, 'B', 3),

(2, 'B', 1),

(3, 'C', 1),

(3, 'A', 2);

select

status_id,

status_code

from

#tmp t1

where

status_sequence = (select max(status_sequence) from #tmp t2 where...

Then the short answer is, use the variable with the smallest footprint that meets your requirements: in this case, smallmoney.

As to the one-byte difference, I can't say definitively as I...

So...what's your question?

User seeks and scans are those initiated by stored procedures or ad hoc queries issued by users (such as you), as opposed to those initiated by the system.

Excellent!

According to BOL, datepart Is the part of date to which an integer number is added. The following table lists all valid datepart arguments. User-defined variable equivalents are not valid.

User-defined...

Which is a nice way of saying I may be typing faster than I'm thinking 😉

The thought I...

Oh, now, was that...