paul.hartland at fsmail.net
paul.hartland at fsmail.net
Thu Feb 26 09:31:53 CST 2004
To all,
Im ok with basic stored procedures, however I want to try something just a little more advanced. I have the following SP at the moment:
CREATE PROCEDURE [genesis_insert_AvailabilityAll]
(@PayrollNo_2 [nvarchar](35),
@JobDate_3 [datetime],
@AvailCode_4 [nvarchar](2),
@Type_5 [int])
AS
SET NOCOUNT ON
INSERT INTO [GenesisTest].[dbo].[tblAvailabilityAll]
( [PayrollNo],
[JobDate],
[AvailabilityCode],
[Type])
VALUES
( @PayrollNo_2,
@JobDate_3,
@AvailCode_4,
@Type_5)
The above SP inserts an availability record into tblAvailabilityAll, however the employee has to be given three types of availability 0, 1, 2 I have a Visual Basic FE and have a loop which passes the PayrollNo, JobDate, AvailCode and Type. As Type is the only value that changes, is there a way I could just pass the SP PayrollNo, JobDate and Availcode and have the SP increment the type ?
Thanks in advance for any help received.
Paul Hartland
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month
www.freeserve.com/anytime