paul.hartland at fsmail.net
paul.hartland at fsmail.net
Wed Feb 26 10:47:13 CST 2003
To all, If you read my first email regarding Stored Procedure's you will know that I am quite a novice at the moment. I have a table called tblAvailabilityAll which contains fields PayrollNo and an AvailabilityCode. The Availability codes are A,N,S,H and when an employee leaves, in the first instance we need to update A,N,S,H to 1,2,3,4 accordingly. Anyone have any idea how to do this within one Stored Procedure (or is it possible in a single Stored Procedure.....??? I would be grateful fr any sample code etc... Thanks in advance Paul Hartland __________________________________________________________________________ Freeserve AnyTime - Go online whenever you want for just £6.99 a month for your first 3 months, that's HALF PRICE! And then it's just £13.99 a month after that. For more information visit http://www.freeserve.com/time/ or call free on 0800 970 8890