pastebin - Unnamed - post number 660673

Unnamed
Thursday, August 16th, 2007 at 11:15:01pm MDT

function ProcessTimeSlip($slipid){
//return and aray called $tresults
// Transfer Process is Broken up into 2 sections , if successful on transfering the data to Tigerpaw, it will transfer the information to payroll to be processed.
$query = "SELECT *,
cast(datediff(mi, StartTime, EndTime)/60 as int) as Hours,
datediff(mi, StartTime, EndTime) - (cast(datediff(mi, StartTime, EndTime)/60 as int) * 60) as Minutes
FROM dbo.TimeSlipDetail
INNER JOIN dbo.Employees 
ON dbo.Employees.Employenum = dbo.TimeSlipDetail.EmployeNum
WHERE SlipID = '$slipid' 
AND Transfered = 'FALSE'";
$qres = mssql_query($query) or die("<status>Unable To Retrieve Associated Details: ".mssql_get_last_message()."</status></dataset></pagedata>");
$count = mssql_num_rows($qres);
if($count==0){
        $tresult['TPCode'] = NULL;
        $tresult['TPMsg'] = "Time Slip Not Found";
        $tresult['TPError'] = TRUE;
        return $tresults;
        }
for($i=0;$i<$count;$i++){
        mssql_select_db("TimeLogsSQL");
        $detail = mssql_fetch_assoc($qres);
        mssql_select_db("BBCTest");
        $true = 1;
        $false = 0;
        $null = null;
        print_r($detail);
        $inttime1 = strtotime($detail['StartTime']);
        $inttime2 = strtotime($detail['EndTime']);
        $Date1 = date("Y-m-d h:i:000",$inttime1);
        $Date2 = date("Y-m-d h:i:000",$inttime1);
        echo "$Date1";
        /* prepare the statement resource */
        $stmt = mssql_init("tsp_CreateSOLog") or die("<status>Unable To Intialize RSP: ".mssql_get_last_message()."</status></dataset></pagedata>");
        /* now bind the parameters to it */
        mssql_bind($stmt, "@StartDateTime",    $Date1,    SQLINT4,    FALSE);
        mssql_bind($stmt, "@EndDateTime",  $Date2,  SQLVARCHAR, FALSE);
        mssql_bind($stmt, "@LogReason", $detail['Job'], SQLVARCHAR, FALSE);    
        mssql_bind($stmt, "@RepNumber", $detail['TPRep'], SQLINT4, FALSE);
        mssql_bind($stmt, "@ActualHours", $detail['Hours'], SQLINT2, FALSE);
        mssql_bind($stmt, "@ActualMinutes", $detail['Minutes'], SQLINT2, FALSE);
        mssql_bind($stmt, "@Mileage", $detail['Mileage'], SQLFLT8, FALSE); 
        mssql_bind($stmt, "@SONumber", $detail['SONumber'], SQLINT4, FALSE);
        mssql_bind($stmt, "@Billable", $true, SQLBIT, FALSE);
        mssql_bind($stmt, "@Chargable", $false, SQLBIT, FALSE);
        mssql_bind($stmt, "@LogComment", $null, SQLVARCHAR, FALSE);
        mssql_bind($stmt, "@Tolls", $null, SQLFLT8, FALSE);
        mssql_bind($stmt, "@Meals", $null, SQLFLT8, FALSE);
        mssql_bind($stmt, "@MiscExpenses", $null, SQLFLT8, FALSE);
        mssql_bind($stmt, "@Fuel", $null, SQLFLT8, FALSE);
        mssql_bind($stmt, "@Parking", $null, SQLFLT8, FALSE);
        mssql_bind($stmt, "@Accomodations", $null, SQLFLT8, FALSE);
        mssql_bind($stmt, "@LaborRate", $null, SQLFLT8, FALSE);
        mssql_bind($stmt, "@SOLogKeyID", $SOLogKeyID, SQLINT4, FALSE);
        mssql_bind($stmt, "@ReturnCode", $ReturnCode, SQLINT4, FALSE);
        
        /* now execute the procedure */
        $result = mssql_execute($stmt) or die("<status>Unable To Execute RSP: ".mssql_get_last_message()."</status><error>TRUE</error></dataset></pagedata>");
        $req = mssql_fetch_row($result);
        if($ReturnCode!=0){
        $tresult['TPCode'][$i] = $ReturnCode;
        $tresult['TPMsg'][$i] = "Time Slip Not Found";
        $tresult['TPError'][$i] = TRUE;
        }
        elseif($ReturnCode==0){
        $tresult['TPCode'][$i] = $ReturnCode;
        $tresult['TPMsg'][$i] = "Time Slip Not Found";
        $tresult['TPError'][$i] = TRUE; 
        }
        else{
        $tresult['TPMsg'][$i] = $ReturnCode;
        }
        echo $ReturnCode;
        echo $SOLogKeyID;
        unset($stmt);
        }
}
 
 
 
 
 
/////////////////////////
 
Here is the Stored Procedure
 
 
/////////////////////////
 
/*********************************************************/
/* File written by SQL Server SysComments Decryptor v1.1 */
/* Copyright (C) 2001 dOMNAR                             */
/*********************************************************/
 
USE BBC
go
 
-----------------------------------------------------------
-- Type: Stored Procedure
-- Name: tsp_CreateSoLog
-----------------------------------------------------------
 
 
 
 
CREATE PROCEDURE dbo.tsp_CreateSoLog      (@SONumber       int,
                                                @StartDateTime    datetime,
                                                @EndDateTime       datetime,
                                                @LogComment         varchar(3000),
                                                @LogReason           varchar(50),
                                                @RepNumber            int,
                                                @ActualHours        int,
                                                @ActualMinutes    smallint,
                                                @Billable              bit,
                                                @Chargable            bit,
                                                @Mileage                real,
                                                @Tolls      money,    
                                                @Meals      money,
                                                @MiscExpenses      money,
                                                @Fuel         money,
                                                @Parking                money,
                                                @Accomodations  money,
                                                @LaborRate            money,
                                                @SOLogKeyID       int OUTPUT,
                                                @ReturnCode          int OUTPUT)
WITH ENCRYPTION AS 
 
DECLARE @ContractNumber  int,
                @AccountNumber  int,
                @TotalUnits          decimal (10,2),
                @UnitFactor          float,
                @Reason  varchar(50),
                @Basis      varchar(1),
                @TotalTime            float,
                @ElapsedTime        int,
                @ElapsedHours      int,
                @ElapsedMinutes smallint,
                @OrderDateOpened        datetime,
                @TestKeyID            int,
                @AutoOpenOrder  bit,
                @CountOfLogs        int,
                @DefaultOpenStatus      varchar(50),
                @Junk         int,
                @Junk2    float,
                @TotalHours          int,
                @TotalMinutes      int,
                @DateClosed          datetime,
                @LogReasonLaborRate     money
 
/*  Return Codes
 
        0 = Successful Add
        1 = Missing SO Number
        2 = Invalid SO Number
        3 = Missing Start DateTime
        6 = Have End Date but no Log Reason
        7 = End Date/Time < Start Date/Time
        8 = Missing/Invalid Rep
        9 = Invalid Log Reason
             10 = No Log End Date and SO is closed
                11 = Have Actual Time but no End date/time
*/
 
-- initialize return variables
SET @SOLogKeyID = 0
SET @ReturnCode = 0
SET @LogReasonLaborRate = 0
 
If @LaborRate Is Null SET @LaborRate = 0
IF @ActualHours is Null SET @ActualHours = 0
IF @ActualMinutes is Null SET @ActualMinutes = 0
 
-- make sure SO # passed in
IF @SONumber = 0
      BEGIN
        SET @ReturnCode = 1          -- missing SO#
        RETURN
      END
 
SET @TestKeyID = Null
 
-- make sure SO # is valid and get AccountNumber, Contract Number and Date Opened
SELECT @TestKeyID = SONumber, @AccountNumber = AccountNumber, 
        @ContractNumber = ContractNumber, @OrderDateOpened = DateOpened,
        @DateClosed = DateClosed
        FROM tblServiceOrders WHERE SONumber = @SONumber
 
IF @TestKeyID is Null      -- Record not found
      BEGIN
        SET @ReturnCode = 2          -- Invalid SO #
        RETURN
      END
 
IF @StartDateTime = 'Dec 30 1899 12:00AM' or @StartDateTime = '' or @StartDateTime = 0 or @StartDateTime is Null
       BEGIN        
        SET @ReturnCode = 3          -- missing start date
        RETURN  
       END
 
IF @ContractNumber is Null SET @ContractNumber = 0
 
IF @EndDateTime = 'Dec 30 1899 12:00AM' or @EndDateTime = '' or @EndDateTime = 0 or @EndDateTime is Null
       BEGIN        -- no end date passed in
        -- if Service Order is closed, they can't have a log without an end date/time
        IF @DateClosed is Not Null
              BEGIN
                SET @ReturnCode = 10        -- SO Closed but log has no end date 
                RETURN
              END
 
        IF @ActualHours > 0 OR @ActualMinutes > 0 
              BEGIN
                SET @ReturnCode = 11        -- Have actual time but no end date
                RETURN
              END
 
        SET @EndDateTime = Null
        SET @ActualHours = 0
        SET @ActualMinutes = 0
        SET @ElapsedHours = 0
        SET @ElapsedMinutes = 0
        SET @TotalUnits = 0
       END
ELSE       -- have an end date/time
      BEGIN
        IF @LogReason is Null or @LogReason = ''
               BEGIN        
                SET @ReturnCode = 6          -- have an end date/time but no Log Reason
                RETURN
               END
 
        -- make sure End date is not < Start date
        IF @EndDateTime < @StartDateTime
               BEGIN
                SET @ReturnCode = 7          -- End date/time < start date/time
                RETURN
               END
      END
 
IF @RepNumber = 0             
       BEGIN
        SET @ReturnCode = 8          -- missing rep number
        RETURN  
       END
 
-- make sure it's a valid rep
SET @TestKeyID = Null
 
SELECT @TestKeyID = RepNumber FROM tblReps
        WHERE RepNumber = @RepNumber
 
IF @TestKeyID is Null      
      BEGIN
        SET @ReturnCode = 8          -- invalid rep number
        RETURN
      END
 
-- calculate elapsed time
IF @EndDateTime is not Null
      BEGIN
        SET @ElapsedTime =  datediff(mi, @StartDateTime, @EndDateTime)
        SET @ElapsedHours = cast(@ElapsedTime / 60 as int)
        SET @ElapsedMinutes = @ElapsedTime - (@ElapsedHours * 60)
      END
ELSE
      BEGIN
        SET @ElapsedHours = 0
        SET @ElapsedMinutes = 0
      END
 
SET @UnitFactor = 0          -- initialize
 
IF @LogReason is not Null and @LogReason <> '' 
-- make sure log reason is valid and get unit factor
      BEGIN
        SET @Reason = Null
        SELECT @Reason =  LogReason, @UnitFactor = UnitFactor, @LogReasonLaborRate = StandardRate FROM tblLogReasons
                WHERE  LogReason = @LogReason
        
        IF @Reason is Null      
              BEGIN
                SET @ReturnCode = 9          -- invalid log reason
                RETURN
              END
       END
 
IF @LogReasonLaborRate is Null SET @LogReasonLaborRate = 0
 
-- get total time as a decimal
SET @TotalTime = @ActualHours + (@ActualMinutes / 60.0)
 /*  NOTE: Must use 60.0 so that the devisor is not an integer otherwise, if both dividend and devisor 
      are integers, the result will be an integer  */
IF @TotalTime > 0 
      BEGIN
        SET @TotalUnits = @TotalTime * @UnitFactor
      END
ELSE  SET @TotalUnits =  0
 
IF @LaborRate = 0 SET @LaborRate = @LogReasonLaborRate
 
INSERT INTO tblSOLogs 
                (AccountNumber,
                 SONumber,
                 StartDateTime,
                 EndDateTime,
                 LogComment,
                 TimeLogReason,
                 Tech,
                 LogHours,
                 LogMinutes,
                 ElapsedHours,
                 ElapsedMinutes,
                 Billable,
                 Chargable,
                 ContractNumber,
                 UnitFactor,
                 TotalUnits,
                 Mileage,
                 Tolls,
                 Meals,
                 MiscExpenses,
                 Fuel,
                 Parking,
                 Accomodations,
                LogReasonLaborRate) 
        VALUES 
                    (@AccountNumber,
                @SONumber,
                @StartDateTime,
                @EndDateTime,
                @LogComment,
                @LogReason,
                @RepNumber,
                @ActualHours,
                @ActualMinutes,
                @ElapsedHours,
                @ElapsedMinutes,
                @Billable,
                @Chargable,
                @ContractNumber,
                @UnitFactor,
                @TotalUnits,
                @Mileage,
                @Tolls,
                @Meals,
                @MiscExpenses,
                @Fuel,
                @Parking,
                @Accomodations,
                @LaborRate) 
-- Return the key id to test the success of the insert.
SET @SOLogKeyID = @@Identity
 
IF @OrderDateOpened is Null     -- If the order is not already open
      BEGIN
        --  check system value to see if first log opens the ticket
        SELECT @AutoOpenOrder = AutoOpenOrder FROM tblSysSOSettings
 
        IF @AutoOpenOrder = 1      -- first log opens order
              BEGIN     
                -- see if this is the first log
                SELECT @CountOfLogs = COUNT(SOLogKeyID)   FROM tblSOLogs 
                        WHERE SONumber = @SONumber
 
                IF @CountOfLogs = 1          -- this is the first log
                      BEGIN          
                        -- get the default open SO status
                        SELECT @DefaultOpenStatus = DefaultOpenOrderStatus 
                                FROM tblSysSOSettings
 
                        -- Get received time of order and make sure start of log is after the received date
 
                        -- open the so with the log start date/time and default open order status
                        UPDATE tblServiceOrders 
                                SET DateOpened = convert(varchar(25),@StartDateTime, dbo.tf_GetDateFormat()),  TimeOpened =  convert(varchar(25),@StartDateTime, 8),
                                                Status = @DefaultOpenStatus, StatusChangedIndicator = 1
                                WHERE SONumber = @SONumber
                      END
              END
      END
 
-- if there is a contract number, see if it is an hourly or units basis and update the contract
IF @ContractNumber > 0
       BEGIN
        SET @Basis = Null
        SELECT @Basis = Basis FROM tblContracts WHERE ContractNumber = @ContractNumber
 
        IF @Basis =  'U' or @Basis = 'H'
              BEGIN
                EXEC tsp_AdjustContractTime @ContractNumber 
              END
       END
 
SET @Junk = 0      -- we don't need some of the values returned
SET @Junk2 = 0
SET @TotalHours = 0
SET @TotalMinutes = 0
 -- get total time logged against the ticket
EXEC tsp_TallySOLogs @SONumber, 0, 
        @Junk output, @Junk output, @Junk output, @Junk output, 
        @Junk output, @Junk output, @TotalHours output, @TotalMinutes output, 
        @Junk2 output, @Junk2 output, @Junk2 output, @Junk2 output
 
 
-- Now update the SO for the new total time logged
UPDATE tblServiceOrders SET TotalHours = @TotalHours, TotalMinutes = @TotalMinutes
        WHERE SONumber = @SONumber

advertising

Update the Post

Either update this post and resubmit it with changes, or make a new post.

You may also comment on this post.

update paste below

/////////////////////////

Here is the Stored Procedure

/////////////////////////

/*********************************************************/
/* File written by SQL Server SysComments Decryptor v1.1 */
/* Copyright (C) 2001 dOMNAR                             */
/*********************************************************/

USE BBC
go

-----------------------------------------------------------
-- Type: Stored Procedure
-- Name: tsp_CreateSoLog
-----------------------------------------------------------

CREATE PROCEDURE dbo.tsp_CreateSoLog      (@SONumber 		int,
						@StartDateTime		datetime,
						@EndDateTime 		datetime,
						@LogComment 		varchar(3000),
						@LogReason 		varchar(50),
						@RepNumber		int,
						@ActualHours		int,
						@ActualMinutes		smallint,
						@Billable		bit,
						@Chargable		bit,
						@Mileage		real,
						@Tolls			money,	
						@Meals			money,
						@MiscExpenses		money,
						@Fuel			money,
						@Parking		money,
						@Accomodations	money,
						@LaborRate		money,
					 	@SOLogKeyID 		int OUTPUT,
						@ReturnCode		int OUTPUT)
WITH ENCRYPTION AS

DECLARE	@ContractNumber 	int,
		@AccountNumber	int,
		@TotalUnits	   	decimal (10,2),
		@UnitFactor	   	float,
		@Reason		varchar(50),
		@Basis			varchar(1),
		@TotalTime		float,
		@ElapsedTime		int,
		@ElapsedHours		int,
		@ElapsedMinutes	smallint,
		@OrderDateOpened	datetime,
		@TestKeyID		int,
		@AutoOpenOrder	bit,
		@CountOfLogs		int,
		@DefaultOpenStatus	varchar(50),
		@Junk			int,
		@Junk2		float,
		@TotalHours		int,
		@TotalMinutes		int,
		@DateClosed		datetime,
		@LogReasonLaborRate	money

/*  Return Codes

0 = Successful Add
	1 = Missing SO Number
	2 = Invalid SO Number
	3 = Missing Start DateTime
	6 = Have End Date but no Log Reason
	7 = End Date/Time < Start Date/Time
	8 = Missing/Invalid Rep
	9 = Invalid Log Reason
             10 = No Log End Date and SO is closed
            	11 = Have Actual Time but no End date/time
*/

-- initialize return variables
SET @SOLogKeyID = 0
SET @ReturnCode = 0
SET @LogReasonLaborRate = 0

If @LaborRate Is Null SET @LaborRate = 0
IF @ActualHours is Null SET @ActualHours = 0
IF @ActualMinutes is Null SET @ActualMinutes = 0

-- make sure SO # passed in
IF @SONumber = 0
      BEGIN
	SET @ReturnCode = 1		-- missing SO#
	RETURN
      END

SET @TestKeyID = Null

-- make sure SO # is valid and get AccountNumber, Contract Number and Date Opened
SELECT @TestKeyID = SONumber, @AccountNumber = AccountNumber, 
	@ContractNumber = ContractNumber, @OrderDateOpened = DateOpened,
	@DateClosed = DateClosed
	FROM tblServiceOrders WHERE SONumber = @SONumber

IF @TestKeyID is Null		-- Record not found
      BEGIN
	SET @ReturnCode = 2		-- Invalid SO #
	RETURN
      END

IF @StartDateTime = 'Dec 30 1899 12:00AM' or @StartDateTime = '' or @StartDateTime = 0 or @StartDateTime is Null
       BEGIN		
	SET @ReturnCode = 3		-- missing start date
	RETURN	
       END

IF @ContractNumber is Null SET @ContractNumber = 0

IF @EndDateTime = 'Dec 30 1899 12:00AM' or @EndDateTime = '' or @EndDateTime = 0 or @EndDateTime is Null
       BEGIN		-- no end date passed in
	-- if Service Order is closed, they can't have a log without an end date/time
	IF @DateClosed is Not Null
	      BEGIN
		SET @ReturnCode = 10		-- SO Closed but log has no end date 
		RETURN
	      END

IF @ActualHours > 0 OR @ActualMinutes > 0 
	      BEGIN
		SET @ReturnCode = 11		-- Have actual time but no end date
		RETURN
	      END

SET @EndDateTime = Null
	SET @ActualHours = 0
	SET @ActualMinutes = 0
	SET @ElapsedHours = 0
	SET @ElapsedMinutes = 0
	SET @TotalUnits = 0
       END
ELSE 		-- have an end date/time
      BEGIN
	IF @LogReason is Null or @LogReason = ''
	       BEGIN		
		SET @ReturnCode = 6		-- have an end date/time but no Log Reason
		RETURN
	       END

-- make sure End date is not < Start date
	IF @EndDateTime < @StartDateTime
	       BEGIN
		SET @ReturnCode = 7		-- End date/time < start date/time
		RETURN
	       END
      END

IF @RepNumber = 0 		
       BEGIN
	SET @ReturnCode = 8		-- missing rep number
	RETURN	
       END

-- make sure it's a valid rep
SET @TestKeyID = Null

SELECT @TestKeyID = RepNumber FROM tblReps
	WHERE RepNumber = @RepNumber

IF @TestKeyID is Null		
      BEGIN
	SET @ReturnCode = 8		-- invalid rep number
	RETURN
      END

-- calculate elapsed time
IF @EndDateTime is not Null
      BEGIN
	SET @ElapsedTime =  datediff(mi, @StartDateTime, @EndDateTime)
	SET @ElapsedHours = cast(@ElapsedTime / 60 as int)
	SET @ElapsedMinutes = @ElapsedTime - (@ElapsedHours * 60)
      END
ELSE
      BEGIN
	SET @ElapsedHours = 0
	SET @ElapsedMinutes = 0
      END

SET @UnitFactor = 0		-- initialize

IF @LogReason is not Null and @LogReason <> '' 
-- make sure log reason is valid and get unit factor
      BEGIN
	SET @Reason = Null
	SELECT @Reason =  LogReason, @UnitFactor = UnitFactor, @LogReasonLaborRate = StandardRate FROM tblLogReasons
		WHERE  LogReason = @LogReason
	
	IF @Reason is Null	
	      BEGIN
		SET @ReturnCode = 9		-- invalid log reason
		RETURN
	      END
       END

IF @LogReasonLaborRate is Null SET @LogReasonLaborRate = 0

-- get total time as a decimal
SET @TotalTime = @ActualHours + (@ActualMinutes / 60.0)
 /*  NOTE: Must use 60.0 so that the devisor is not an integer otherwise, if both dividend and devisor 
      are integers, the result will be an integer  */
IF @TotalTime > 0 
      BEGIN
	SET @TotalUnits = @TotalTime * @UnitFactor
      END
ELSE  SET @TotalUnits =  0

IF @LaborRate = 0 SET @LaborRate = @LogReasonLaborRate

INSERT INTO tblSOLogs 
        	(AccountNumber,
		 SONumber,
		 StartDateTime,
		 EndDateTime,
		 LogComment,
		 TimeLogReason,
		 Tech,
		 LogHours,
		 LogMinutes,
		 ElapsedHours,
		 ElapsedMinutes,
		 Billable,
		 Chargable,
		 ContractNumber,
		 UnitFactor,
		 TotalUnits,
		 Mileage,
		 Tolls,
		 Meals,
		 MiscExpenses,
		 Fuel,
		 Parking,
		 Accomodations,
		LogReasonLaborRate) 
	VALUES 
	            (@AccountNumber,
		@SONumber,
		@StartDateTime,
		@EndDateTime,
		@LogComment,
		@LogReason,
		@RepNumber,
		@ActualHours,
		@ActualMinutes,
		@ElapsedHours,
		@ElapsedMinutes,
		@Billable,
		@Chargable,
		@ContractNumber,
		@UnitFactor,
		@TotalUnits,
		@Mileage,
		@Tolls,
		@Meals,
		@MiscExpenses,
		@Fuel,
		@Parking,
		@Accomodations,
		@LaborRate) 
-- Return the key id to test the success of the insert.
SET @SOLogKeyID = @@Identity

IF @OrderDateOpened is Null	-- If the order is not already open
      BEGIN
	--  check system value to see if first log opens the ticket
	SELECT @AutoOpenOrder = AutoOpenOrder FROM tblSysSOSettings

IF @AutoOpenOrder = 1		-- first log opens order
	      BEGIN	
		-- see if this is the first log
		SELECT @CountOfLogs = COUNT(SOLogKeyID)   FROM tblSOLogs 
			WHERE SONumber = @SONumber

IF @CountOfLogs = 1		-- this is the first log
		      BEGIN		
			-- get the default open SO status
			SELECT @DefaultOpenStatus = DefaultOpenOrderStatus 
				FROM tblSysSOSettings

-- Get received time of order and make sure start of log is after the received date

-- open the so with the log start date/time and default open order status
			UPDATE tblServiceOrders 
				SET DateOpened = convert(varchar(25),@StartDateTime, dbo.tf_GetDateFormat()),  TimeOpened =  convert(varchar(25),@StartDateTime, 8),
			        		Status = @DefaultOpenStatus, StatusChangedIndicator = 1
				WHERE SONumber = @SONumber
		      END
	      END
      END

-- if there is a contract number, see if it is an hourly or units basis and update the contract
IF @ContractNumber > 0
       BEGIN
	SET @Basis = Null
	SELECT @Basis = Basis FROM tblContracts WHERE ContractNumber = @ContractNumber

IF @Basis =  'U' or @Basis = 'H'
	      BEGIN
		EXEC tsp_AdjustContractTime @ContractNumber 
	      END
       END

SET @Junk = 0		-- we don't need some of the values returned
SET @Junk2 = 0
SET @TotalHours = 0
SET @TotalMinutes = 0
 -- get total time logged against the ticket
EXEC tsp_TallySOLogs @SONumber, 0, 
	@Junk output, @Junk output, @Junk output, @Junk output, 
	@Junk output, @Junk output, @TotalHours output, @TotalMinutes output, 
	@Junk2 output, @Junk2 output, @Junk2 output, @Junk2 output

-- Now update the SO for the new total time logged
UPDATE tblServiceOrders SET TotalHours = @TotalHours, TotalMinutes = @TotalMinutes
	WHERE SONumber = @SONumber

details of the post (optional)

Note: Only the paste content is required, though the following information can be useful to others.

Name / Title: Save name / title?
Description / Question:
Tags: (space separated, optional)
Content Type:
Expire this post in:
Encrypt this paste. Password:

Please note that information posted here will expire by default in one month. If you do not want it to expire, please set the expiry time above. If it is set to expire, web search engines will not be allowed to index it prior to it expiring. Items that are not marked to expire will be indexable by search engines. Be careful with your passwords. All illegal activities will be reported and any information will be handed over to the authorities, so be good.

worth-right

pastebin - Unnamed - post number 660673

Stuff to Do

Paste Actions

Information

Paste Details

Quick Search

Recent Posts

Unnamed
Thursday, August 16th, 2007 at 11:15:01pm MDT

advertising

Update the Post

pastebin - Unnamed - post number 660673

Stuff to Do

Paste Actions

Information

Paste Details

Quick Search

Recent Posts

UnnamedThursday, August 16th, 2007 at 11:15:01pm MDT

advertising

Update the Post

Unnamed
Thursday, August 16th, 2007 at 11:15:01pm MDT