: !/bin/sh . tbsserver_vars #tbssql </dev/null < '' BEGIN SELECT @strSQL2 = @strSQL2 + ' AND tInvoice.CustomerID IN (' + @CustomerList + ') ' END END ELSE BEGIN SELECT @InvNo=REPLACE(@InvNo,'$','''') SELECT @strSQL2 = ' AND tInvoice.PlatinumInvoiceNo IN (' + @InvNo + ') ' END SELECT @strSQL1 = 'SELECT tCustomer.*, tInvoiceDetail.AmountExGST, tInvoiceDetail.Period, tInvoiceDetail.BatchID, tInvoice.*, tInvoiceDefault.*, tReportGroup.ReportOrder, line_desc = tInvoiceDetail.Description, ContactName = tARContact.FullName, ContactPhone = tARContact.Phone, ContactEmail = tARContact.Email FROM tInvoiceDefault, tInvoiceDetail (NOLOCK) INNER JOIN tInvoice (NOLOCK) ON tInvoiceDetail.InvoiceID = tInvoice.ID INNER JOIN tCustomer (NOLOCK) ON tInvoice.CustomerID = tCustomer.ID INNER JOIN tElement (NOLOCK) ON tInvoiceDetail.ElementID = tElement.ID LEFT OUTER JOIN tBatchType (NOLOCK) ON tInvoiceDetail.BatchTypeID = tBatchType.ID LEFT OUTER JOIN tARContact (NOLOCK) ON tCustomer.ARContactID = tARContact.ID LEFT OUTER JOIN tReportGroup (NOLOCK) ON tElement.ReportGroupID = tReportGroup.ID WHERE tInvoice.PlatinumInvoiceNo IS NOT NULL AND tInvoice.CreditNoteFlag = 0 ' SELECT @strSQL3 = 'ORDER BY tCustomer.ShipTo, tInvoice.PlatinumInvoiceNo, tReportGroup.ReportOrder, tInvoiceDetail.Description, tInvoiceDetail.BatchID' /* WHERE tInvoiceDetail.AmountExGST <> 0 AND tInvoice.PlatinumInvoiceNo IS NOT NULL AND tInvoice.CreditNoteFlag = 0 ' 'PRINT @strSQL1 + @strSQL2 + @strSQL3 return */ EXEC (@strSQL1 + @strSQL2 + @strSQL3) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SP0