SET @execSQL = 'DECLARE @BeforeValue sql_variant, @AfterValue sql_variant '+

'SELECT @BeforeValue = D.['+@ColumnName+'], '+

...

Jeff I feel really bad...

unless you have the database recovery Model property set to Full instead of Simple, there is no way to determine this without adding features yourself.

if the database is set to...

ok how about this:

get all the tables in FK hierarchy order; truncate tables with no FK, and for teh rest of the tables that feature foreign keys delete ...

it's just an expansion on the first...you have to join Contacts a second time...to do that, you must ALIAS at least one of the contact table references:

SELECT Stage3.Stage3ld, Issues.IssueDesc, C1.FirstName...

something like this will work, if you still need to send one email for each @taker AND each Taker's commisionless order;

if you want to roll them you'd need to group...

if you have a foreign key reference, it's good practice to use the actual column name from the parent table, instead of an alias.

you never mentioned what the relationships are,...

download SQLRecon from sqlRecon.com

it will survey your network and report a LOT of valuable information about all the servers it finds;

chances are it will find development servers you didn't know...

i should have explained...that is not for a trigger!

run that in QA...it should find the sample record you said you created.

if it works, then you can throw away the trigger,...

ok try this: i think the sql below will find everything that has a zero commission, all in one shot.

fromt here, you could construct a single email, or a bunch...

ok here's my idea:

there's a statement that gets this value:

SELECT @Commission = min(commission_cost)

FROM oe_line

WHERE order_no = @OrderNo

i'm thinking that the lines here get inserted into the table oe_line AFTER the...

this code with the minor changes required passes syntax for SQL2005: i think the issue was there was select min(select somevalue) instead of select min(somevalue)

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

CREATE TRIGGER...

by default SQL server treats anything between single quotes as a varchar; it' doesn't try to determine whether the varchar may also be a date...that's the behavior you are seeing.

so...

ADODB is part of the microsoft Data Access Components (MDAC)

here's more info and the download:

Download details: MDAC 2.8Microsoft Data Access Components (MDAC) 2.8 contains core Data Access components such as...

syntax wise, there was an extra single quote near SessionComplete, and the @startDate/E@Enddate were not declared inte snippet you posted. no problem there.

the statement you pasted only references one table,...