exiting a stored procedure 1

[aaronjonmartin]

This may be easier than I realise but if anybody could help me with this I would appreciate it.

I want to build a stored procedure which takes a date and some details about a user. I want it to compare the date with the current date/time and if it is not passes the current date/time insert the details of the user into a table, if it is passed the current date/time I want to exit the stored procedure without inserting anything.

Is this possible? How can this be done?

"It's so much easier to suggest solutions when you don't know too much about the problem."
Malcolm Forbes (1919 - 1990)

 

[cLFlaVA]

use the return statement...

if [i]<condition one>[/i] begin
    return 0;
end else begin
    return 1;
end

*cLFlaVA
----------------------------
[tt]somebody set up us the bomb![/tt]

[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[SQLDenis]

if @date <getdate()
begin
insert into table values(...)
end

--no need for else here

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[aaronjonmartin]

SQLDenis your solution looks like its what im after, i will give it a try. Thankyou

&quot;It's so much easier to suggest solutions when you don't know too much about the problem.&quot;
Malcolm Forbes (1919 - 1990)

 

[bborissov]

One simple question: What do you mean with "Current Date/Time"? Is this includes seconds?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[aaronjonmartin]

yes it includes seconds

&quot;It's so much easier to suggest solutions when you don't know too much about the problem.&quot;
Malcolm Forbes (1919 - 1990)