[dba-VB] [dba-SQLServer]More SQL Server 7 Stored Procedure help if possible

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


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-VB mailing list