Thanks. This will give me plenty to chew on!
>Kevin,
>
>Here's a very simple stored proc to return the entire customer record for a customer PK...
>
>
>CREATE PROCEDURE GetCustomerByPK (@nCustomerPK int)
> AS
>
> SELECT * FROM Customer WHERE CustomerPK = @nCustomerPK
>GO
>
>
>You may want to check BOL (books online) for more details on creating SPs.
>
>Kevin
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people