If you don't know how to create stored procedure then check for bellow link
http://technet.microsoft.com/en-us/library/aa174792%28v=sql.80%29.aspx[
^]
Because if you can write Store procedure then later you can create as per your wish.
Here is a sample of your code, please modify as per your requirement
ALTER PROCEDURE [dbo].[stp_Save_Vehicle]
@VehicleID INT
AS
BEGIN
DECLARE @Vehicle TABLE (
VehicleId INT,DatetimeV Datetime,Location NVARCHAR(100));
DECLARE @VehicleFilter TABLE (
VehicleId INT,DatetimeV Datetime,Location NVARCHAR(100));
DECLARE @IdleReport TABLE
(VehicleNo INT,Startdate DATETIME,Enddate DATETIME,Duration NVARCHAR(50),Location NVARCHAR(50))
DECLARE @count INT, @rowCount INT,@Location1 NVARCHAR(100)
INSERT INTO @Vehicle (VehicleId,DatetimeV,Location)
VALUES(1,GETDATE(),'DELHI')
INSERT INTO @Vehicle (VehicleId,DatetimeV,Location)
VALUES(1,GETDATE(),'BOMBAY')
INSERT INTO @Vehicle (VehicleId,DatetimeV,Location)
VALUES(2,GETDATE(),'CHENNI')
INSERT INTO @VehicleFilter
SELECT * FROM @Vehicle V WHERE V.VehicleId=@VehicleID
SET @count = 1
SELECT @rowCount = COUNT(1) FROM @VehicleFilter
WHILE @count <= @rowCount
BEGIN
SELECT @Location1=Location FROM @VehicleFilter
INSERT INTO @IdleReport(VehicleNo,Startdate,Enddate, Duration,Location)VALUES
(1,GETDATE(),GETDATE(),DATEDIFF(MINUTE,GETDATE(),GETDATE()),@Location1)
SET @count = @count + 1
END
END
[edit]Code block added[/edit]