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

Hi Geoff - please provide three or four lines of source data and then an example of the results that you would like, based on that data.

Sorry about that - I should know better than to leave my replies strewn with Latin phrases.

Ad hoc means "for a specific purpose" - I meant it literally - it is...

SQL Server is a database platform, not a GUI tool.

Access is both a GUI tool and a database platform - it stores, processes and presents data.

To use SQL Server in a...

Could you create a distinct view and run your query against that?

If not, please mention what other restrictions you have to work round.

Regards

Ah - I read that to mean the scheduled execution of a VB.NET app.

Can you specify the user / password in the OLEDB connection string and use that to connect to SQL Server and then just EXEC the stored proc?

Maybe try initialising @variable before the conditions to get rid of possible NULL issues.  Eg

set @variable = ''

if not exists (select * from table where id = 1)

  begin

    set @variable...