SELECT RIGHT('0000' + CAST(fsrRequisition.RequisitionID AS varchar(10)), 5) AS RequisitionID, fsrRequisition.strPinkSlipNumber, mstUser.strUserName, fsrRequestType.strRequestType, LEFT(CONVERT(varchar(24), fsrRequisition.dtDate, 120), 10) AS dtDate, fsrRequisition.strRegion, fsrRequisition.strExpense, fsrRequisition.strContactPerson, fsrRequisition.strContactNumber, fsrRequisition.blnDelivery, fsrRequisition.strStatus, fsrRequisition.strInvoiceNumber, fsrRequisition.dtLastEdit, fsrRequisition.strAuthorizedBy, fsrRequisition.txtRequestDetail, ISNULL(tBillTo.strCustomerNo, '') + ' - ' + ISNULL(tBillTo.strCustomerName, '') AS strBillToAccount, ISNULL(tShipTo.strCustomerNo, '') + ' - ' + ISNULL(tShipTo.strCustomerName, '') AS strShipToAccount FROM fsrRequisition INNER JOIN mstUser ON fsrRequisition.refUserID = mstUser.UserID INNER JOIN fsrRequestType ON fsrRequisition.refRequestTypeID = fsrRequestType.RequestTypeID LEFT OUTER JOIN dwdCustomer AS tShipTo ON fsrRequisition.strShipToAccount = tShipTo.strCustomerNo LEFT OUTER JOIN dwdCustomer AS tBillTo ON fsrRequisition.strBillToAccount = tBillTo.strCustomerNo WHERE (fsrRequisition.RequisitionID = @RequisitionID)