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,...

it's gotta be a translational error instead of a copy/paste error; it's not adobe, like adobe reader.

it should be

Set Conn = CreateObject("ADODB.Connection")

ADODB is the standard way I've always connected to...

results into excel, and getting excel to run a stored procedure or query text is pretty easy.

i made this in an excel worksheet for Excel 2002.

to recreate, simply open excel,...

i was just about to post the same thing as michael did...if the table has definitions for decimal 20,10) for example, it keeps 10 characters...you really want 7 siginificicant digitis,...

i thought float,real and numeric were non-deterministic so you get approximations like 3.99999999999999999994 for the value of 4.00 stored and such...., and it was better to use money or decimal...