China,...

OK, all of the people saying that they are in this situation, please confirm that you have done all of the following:

1) checked that your are on SQL 2005

2) checked...

You are going to have to be more explicit about these relationships you are trying to describe, because they are not at all clear so far. Please supply some...

Lotus (11/4/2008)

---

I have a sql 2005 db in which schema_id and principal_id values are the same in sys.schemas view is most cases except for few, these values are different. ...

You cannot disallow NULLS on that column, because there are still rows in the table that have NULL in that column.

Glad we could help!

Try this:

Select b.SalePerson

, b.Cat

, a.SalePerson

, a.Cat

From #BeforeTraining b

full outer join #AfterTraining a

ON b.SalePerson = a.SalePerson

And b.Cat = a.Cat

Try resetting the Cache.

The employee to Groups relationship that you are describing is many-to-many. Many-to-many relationiships must be implemented with a junction or "mapping" table.

This is a Cursor routine. Let's hope that...

Dana (11/4/2008)

---

As explained in my first post, I have similar code in c#, works perfectly for SQL2005, but not SQL 2000.

(more precisely: the xml file is changed,...

OK, here is an example that demonstrates calling subordinate stored procedures as though they were Delegates:

---- GetFoodByID EXEC Switch example ---

----------------------------------------

--====== First Create the subOrdinate procedures:

CREATE Proc GetFoodById_AsFruit( @ID as...

Try this command instead:

ALTER TABLE [Devices]

ADD lastupdate datetime default(getdate())

You can do this with the SMO RegisteredServer class:

Dim rs...

Peter (11/4/2008)

---

As for Case 2, I can create a structure in which I can do away with any IF by using delegates and creating a Dictionary of these delegates using...