Category: MySQL and other databases
MS SQL stored Procedure
Hi
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
3)Duration int
4)StartTime DateTime
5)EndTime DateTime
6)Comments varchar
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.
regards
mahathi.