[wanabavbcoder]

Hi all, I am fairly new to sql 2000 and i would like to know if anyone could please help me on writing a stored proc.
I can write a simple one, but this has stumped me.

There are three columns in my table.
Venue_Name, Start_Date, End_Date

I need to use variables because I am going to use values from a Vb.net form
The date columns are going to be populated with a datetimepicker
i need a procedure to check the venue_name to the start_date and end_date.
How do i go about doing that? any ideas?

[wanabavbcoder]

Please assist me where you can with the code as i am not very fluent in sql

[thava]

This is just a skeleton try to utilize this

CREATE PRCO <PROCNAME>
(
@VEnNAme varchar(200)
@SDate datetime,
@EndDate DateTime,
)
as
SELECT * FROM <yourTableNAme> 
Where <Frame your conditon here>

hope you got an idea

[wanabavbcoder]

thava, on 09 October 2012 - 12:14 AM, said:

This is just a skeleton try to utilize this

CREATE PRCO <PROCNAME>
(
@VEnNAme varchar(200)
@SDate datetime,
@EndDate DateTime,
)
as
SELECT * FROM <yourTableNAme> 
Where <Frame your conditon here>

hope you got an idea

You are a star. It worked perfectly and now my code is executing and displaying what it needed to. Brilliant. KEEP IT UP