|
-
Dec 4th, 2000, 02:59 PM
#1
Thread Starter
New Member
I'm trying to write the following stored procedure where the @strStock variable represents a table in the SQL DB:
CREATE PROCEDURE sp_KairosQueryMINMAXstock
@strStock char(4),
@strDate char(10),
@strStartTime char(8),
@strEndTime char(8)
AS
Select MIN(trade), MAX(trade), Count(*) from strStock
where Date = @strDate
and Time > @strStartTime
and Time < @strEndTime
If I run it as a straight query from VB, I have no trouble. But how do I write the query so that the table name variable @strStock is properly inserted into the stored proc.
Thanks
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
|
Click Here to Expand Forum to Full Width
|