Query Issue
Posted: Fri Feb 06, 2026 5:51 pm
This query runs fine in SQL Server Manager but fails in Stimulsoft. Any idea why. It gives a data mismatch error, which is not seen in SQL Server Management. I have tried numerous variations of the query. They all fail. The goal is to get a valid sort on a string of this type AGEAGE000028899, AGEAGE000028607, etc
Thanks John W
------------
Thanks John W
------------
Code: Select all
select OnlineRenewalBuyersCard.LicenseeName,OnlineRenewalBuyersCard.Iden,OnlineRenewalBuyersCard.PermitTypeFee,OnlineRenewalBuyersCard.permitNumber, permitTypeCode, OnlineRenewalBuyersCard.invoiceKey, Cast(transactionDate As Date) AS TransactionDate,
RemittanceDetail.transactionConfirmationID,RemittanceDetail.AmountDue,Cast(RemittanceDetail.PaymentEffectiveDate AS Date) AS PaymentEffectiveDate,RemittanceDetail.invoicekey as remitInvoice
from OnlineRenewalBuyersCard
left join RemittanceDetail on OnlineRenewalBuyersCard.invoiceKey = remittanceDetail.InvoiceKey
where
transactionDate between @dateFrom and @dateTo
AND OnlineRenewalBuyersCard.PermitStatus <> 'Void'
ORDER BY TRY_CAST(
RIGHT(
remittanceDetail.transactionConfirmationID,
LEN(remittanceDetail.transactionConfirmationID)
- NULLIF(PATINDEX('%[^0-9]%', remittanceDetail.transactionConfirmationID), 0) + 1
) AS INT
)