Or you could wrap the entire process in your stored procedure - by selecting the results of your sp into a temp table and then querying the temp table ?!?!...

oh - yours' is a much better idea darrell!

in the set portion of the update stmt, why is it that u specified "v_polno" instead of "@v_polno"? same for the rest of the vars .. is the use of...

Rats - I just spent the last half an hour typing out the various steps - only to have the whole text "vanish" - ctrl z isn't bringing it back...

nothing wrong with wishful thinking - dream on darrell - !

Well - the (offshore) bubble was bound to burst - just not convinced that its' time has come (foote report or not...)!

If the salaries are indeed up...maybe we won't need...

Ian - one way of doing this would be:

create procedure chkBarCode

@barCode Int

as

declare @salesOrderNumber int

if exists(select salesOrderNumber from tblSales1 where barCode = @barCode)

begin

...

mom - you're right about not worrying too much...I'm (more than a little) apprehensive about being out on the job market again (have too much of a retiring nature to...

Hi Darrell - just out of curiosity - did you manage to get out of the madding crowds into the lush meadows of the countryside ?!

you could "union" the 2 resultsets...

Also the fact that I passed at most 45 minutes in 2 weeks on the site qualifies as staying away from it in my case...

I agree - that's why I...

oops - my bad...didn't read the post carefully enough - yes - dcpeterson did post the exact same solution....rats - can I never be right ?!?!

1 - you're right - that WAS yesterday!

2 - dcpeterson did NOT post the SAME solution - his includes the oldQuoteID

3 - I lost several bets - the most important...

No Bryan - I would never elevate myself to that altitude (compare myself to remi - that would be arrogance on my part indeed!)

...stands...

...most people change job is to get more money or flex time or vacation time..

sometimes they get laid off or their project contracts do not get extended....(something that may happen...