Please post your query, an example of the results you are getting and an example of the results you would like to get.

Presumably the data model was created by the programmers, who knew when they were creating it that they would always create at least one ORDER_LINE row for every ORDER row? ...

As far as I can think, this is best left to the application.  There is no standard way of enforcing this - nor can I envisage one.

Of course, it would...

Stored procedures do not just return resultsets.  Check BOL for info on OUTPUT parameters in stored procs.

Edison was actually more emphatic than this:

"Genius is one per cent inspiration and ninety-nine per cent perspiration. Accordingly, a  'genius' is often merely a talented person who has done all...

OK.  Have a look at the results of running

SELECT Billing.AcctID, Family.AcctID

from Billing inner join Family

on Billing.Student = Family.Student

Which will presumably correlate with the BILLING records that are being updated.

You...

Are there any NULLs in the CHARGE or PAYMENT entries in BILLING?

It's all about how the compiler works as it tries to optimise the code.  God knows what's going on in detail though.

That was my guess too ... I just wan't going to say it yet

So are you saying that something like the statement

update user_master

set field = 'x'

would cause the trigger to fire as many times as there are rows in the table?  If...

Please do not cross post.  Use this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=249168

This is one way:

where username = IsNull(@param1, username)

if @param1 is NULL, the IsNull function returns username, which is, of course, always equal to itself.

Check out 'DTSRun' in Books Online, it will help you set up the command line that you need to run a DTS package.

To run this command line from within a...

When you run the export wizard, you get the option to save the package.

Once you have saved the package, just go into the Data Transformation Services section of EM, right-click...

select a.apartment_id, p.description

from apartment a left outer join

 presentation p on a.apartment_id = p.apartment_id left outer join apartment_tour t on a.apartment_id = t.apartment_id