MS SQL stored Procedure
I have an application that reserves computers for the user. I require a stored procedure that inserts multiple computers into the database. Each row contains the following fields:
1) ServiceTagId varchar
2) UserId int
The input is in the form '6XXC81S,HVXC81S',20,20,'08/12/2006','It is a sample query'.
The output is of the form
ServiceTagId UserID StartTime EndTime Comments
6XXC81S 20 08/11/2006 11:52:10 AM 08/12/2006 11:52:10 AM It is a sample reservation
HVXC81S 20 08/11/2006 11:52:10 AM 08/12/2006 11:52:10 AM reserved by me.
I will be thankful to any help provided. Please send the reply fast.