-
Junior Member
Pass periodic value into where clause
I want to write a Procedure to insert the data (huge).
Suppose I have insert statement foloowed by a select statement.
But at time i do not want to select whole data.I want to select particular period data,for period i have one column in the table.So i want to pass every time period value to where clause.
What is the best way ?
My Code like :
Procedure name xyz
declaring a cursor to store all periodic dates.
Loop
fetching periodic values
insert statement
select statement where valueseriodic
end loop
Every time i need to pass periodic value into where clause.
PLease post your ideas
-
Re: Pass periodic value into where clause
Kindly post your under lying table structure.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules