Hey - you've been ferreted out...hiding behind the mask of GPF^192 is a member of the "wizards of China's thriving piracy industry" - you must be the one they referred...

maybe you could just have a default of getdate() in your stored procedure and then do the comparison...this way you only have to call the procedure and not pass any...

Renga - this is from BOL - but doesn't really add anything to what remi has already said:

"The select list of a subquery introduced by EXISTS almost always consists of...

but the fact that the book is published shows that someone has liability and stands behind the book, wacky idea or not......don't know about this steve...

chinese translations of "H.P &...

vinny - lesson to be learnt here is "learn to listen to the back of your head" -

This is all remi's fault...

RG - most of the time I don't let on how much I really know!!!

Indigo - a primary key does not allow null values which's why you cannot insert nulls in your column.

I am going to make a few assumptions on your ID column...

steve - your link for "blogs at scc.com" doesn't work...

Hey Mike - no one's offended! Just double checking to make sure!

Glorianni...so your ORP_ORG_ID is not unique ?!?!

How do you decide which number goes into the ORP_PRD_ID column - I know you said it is not dependent on anything...but I'm curious...

mike - isn't this the same as what is being discussed on this other thread..?!?!

other thread

if you browse the forum list - they are separated by topic - "Newbies"; "Administration"; "T-Sql" etc...

pick the category you think that your question falls under..and there is a button...

or..just to take the tedium out of all this...

select DateAdd(yy, 2, getdate())

Glorianni - it'd have been better if you hadn't piggy-backed on this post simply because you stand chances of your post getting overlooked this way...

...and the days of the library are most definitely not numbered as long as there are people who derive immense pleasure from the joy of curling up with a good...