of course.

I feel such a fool.

couldn't see the wood for trees.

🙂

sorry, yes.

I'd like to get both sets of results but only using 1 query

so like:

select a

from tablea

where

if z=0

and startdate > '2008-01-31'

and startdate <...

thanks people.

managed to do it in the end, found that none of the activex refences are turned on by default. 

all ok after i...

Nearly...

that's using a SP to push into a word doc table.

All I want to do is build a case statement within a word doc based upon the results of an...

works excellently,

Thanks guys

ok, ok, ok,

it was left joins, thus:

declare @saleid int

set @saleid = 71476

Set nocount on

Print 'Please Rollback:'

Print ''

Print 'System: Production'

select 'Booking:',cast(Sale.SaleID AS VARCHAR)

+ case

when TerminationInfo.TerminationTypeID

= 1000 then...