PDA

View Full Version : MS SQL stored Procedure



mahathi
08-11-2006, 07:28 AM
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.