You can use that as your contribution remi as my leitmotif (in case you didn't notice) is - SSC ...

ps: since you seem to...

Jurushia - You can join as many tables as you want (just as you have done)...for inner joins the syntax shouldn't matter between "where" and "join tbl on..." - it'd...

Love reading these "bios"...interesting to see what great minds do for some good ole r&r...definitely did pick up ideas for the next dining event...pamboli anyone ?!?!?!

Steve - if you read...

Just at first glance...it'd be better if you use the ansi compliant syntax of joins...also, you're using aliases for your tables but I don't see tablename.columnname...you have the whole thing...

'kay remi - have a new post dedicated just for you!

contest

I cannot "edit" my post at all...it's now "joined at the hip" with ziggy starlight's post..

I think the "next step" hasn't been implemented at...

Simon - you could check (as remi said) to see if the space that you "see" is indeed one...

declare @Country varchar(15)
set @Country = 'F R A N C E'
print...

DID NOT....all I did was hit the "reply with quote" button...

Hey 6000 posts...how come the "label" still says 5000 ?!?!

I'm checking the display on this one too...testing out a theory!!!

I have no idea why that "funky display" just happened....

what about the sysjobs system table...?!?! I should think that you may be able to directly disable/delete a specific job (without affecting the other jobs) using the job_id...?!?!

mhite - like you I tend(ed) to use the individual forum searches more often though even there...you can select "all forums" for a specific topic since people post all over...

one of these scripts should be able to help you out:

sp to search string

search for text

search all user objects

search for specific string

Well - if you ever find out, do post the result so we can all remain "informed"...

aah - you only do that with people you know well (unfortunately)...I spoke from personal experience when I said that...

However, I should've qualified it...