As far as naming conventions go, I have one thing to say.  BE CONSISTENT.

cl

I paid US$2.43 for a gallon of gas today, predicted to rise to US$3.00 by the end of summer.  I realize that this is low compared to what a lot...

Good stuff...good stuff.  I posted the article to slashdot...it's their type of humour.  They've got a bunch of funny crap today:

Davidlost writes "A PC-to-human virus, known as Malwarlaria.B is...

You managed to confuse me as well.  I have no idea if this is helpful, but a generalized "Sequence" table can make a lot of "incrementing" processes set based.  Insert...

You shouldn't need to do a delete/insert to get these results, use a derived table with unions instead.

select officeID, sum(tSum) as TotalSum

from

 (

 select  officeid,sum(Sales) as tSum

 from Salesrecord_Prouct_A

 group by officeid

 union all

 select officeid,sum(Sales)

 from...

If Grokster looses this case expect there to be serious reprocussions in the tech world.   However, it does look promising, the Supreme Court does seem to grok the technical issues,...

"Starting from MySQL 3.23.44, InnoDB features foreign key constraints." NOTE: Current recommended production version is 4.1

http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html

The mySQL version of a check constraint is called a "set" or "enum" constraint...

mySQL offers a fairly high level of compliance:

http://dev.mysql.com/doc/mysql/en/compatibility.html

http://dev.mysql.com/doc/mysql/en/differences-from-ansi.html

I don't know why you think mySQL doesn't offer constraints, cause it does:

http://dev.mysql.com/doc/mysql/search.php?q=constraints&from=%2Fdoc%2Fmysql%2Fen%2Fdifferences-from-ansi.html&lang=en

mySQL is a work in...

SQL CLR is Microsoft specific (right now), while SQL/PSM is an accepted SQL Standard.  I grant that support for SQL/PSM has been sparse, but I don't see that as a...

Joe is a bit of a reactionist, but he's right on the money here.

By accepting the CLR into SQL you are no longer going to be writing SQL.  I mean,...

declare @Table table (dtDate datetime, ID int)

declare @ID int

select @ID = 0

While @ID < 1000

 BEGIN

 --Replace with table lookup (preferably on PK)

 --Select top 1 @ID = ID

 --From Table

 --Where ID > @ID int

 --Order by...

You probably didn't get an answer because this is a super hard problem.  Really, you are looking at what can only be called a bug (functionaly challenged, if you will).

Here's...

You are right.

Use staging tables to load data from DTS, making sure the data conforms to what is needed, then do the Insert/Updates against the live tables as one transaction.

Or...

"there are three tables available to you": 

Actually, all tables are available, plus the inserted and updated tables.

"You must use the deleted table to determine what the value was before...

Bill,

The only way I've been able to do this is:

Procedures:  Get the count and return it to DTS using an Output parameter (into a global variable).  This can be tricky...