JALB (7/11/2008)

---

Transferring to another school means, the program copies all student related tables that pertain to one student with one click of a button from one school to another. Demographics...

OUTER JOIN WHERE conditions acting like INNER JOIN..ON condiitons is documented and intended behavior, per the ANSI SQL standard. In fact, having the option to use both "inner" and...

You have this check for your re-used conversation handle being either NULL, non-existent or bad state:

IF @dlgId IS NOT NULL

...

Please show us your Sending code.

Uhhhm, .. do you want it in SQL-92 syntax or SQL-89 syntax?

😀

Himm, it only happens on assignments:

declare @sqlfilter varchar(33)

select @SqlFilter = 'a' + 'd' + + 'b'

Acts like the extra "+" is not there.

But

select 'a' + 'd' + + 'b'

Gives...

No. I can give you some examples though:

...

Thanks for the feedback.

still not seeing it.

The way to sort out in your mind how CASE works VS. how IF works is this:

IF is a flow-control statement

however

CASE is a function.

Yes, it does not...

I would not recommend this. As a previous post noted: this is extremely dangerous. There are...

Union combines multiple result sets into one result set. It does not combine multiple records into single records.

There are other methods to combine multiple records into single records, the...

Service Broker tip: make sure your procedures are ending their conversations (both sides)!

Though I've never done it myself, I seem to recall reading that Notification Services was created specifically to do this sort of thing with Reporting Services.

I think this is simpler and more efficient:

ALTER PROCEDURE [dbo].[ProductType_ValidateStartDate](

@ProductTypeID INT,

...