![]() ![]() There should be a single LON table and a single ADV table, with the relevant date stored against each record. NB: This seems like a poor database design. SELECT a.BrCode, a.Code, CONCAT(a.BRCODE, a.CODE, RIGHT(''000000'' + CAST(a.Acno AS VARCHAR(6)), 6)) AS ACNO, c.Name, c.PAN, a.CustNo, a.LIMITAMT, a.SECVALUE, (a.ClearBal + a.AccumuInt + a.clgamt) AS BALANCE, a.NPACode, a.NPADt, a.OverdueAmt, a.UnreserveInt, a.INTIND7AMT, a.PENALINTIND7AMT, a.AcSts, a.Limit, ''0'' as DueInst, ''0'' as InstAmt FROM MIS.dbo.' + QuoteName( + N ' a INNER JOIN c ON a.custno = c.Code WHERE AcSts != 9 AND ClearBal < 0' ĮXEC sp_executesql sp_executesql (Transact-SQL) - SQL Server | Microsoft Docs The conversion from STRING or BLOB into REAL or INTEGER is performed even if it is lossy and irreversible. ![]() An optional column list can be provided after the alias. WHERE SCHEMA_NAME(schema_id) = ' dbo' And name = N ' SELECT l.BrCode, l.Code, CONCAT(l.BRCODE, l.CODE, RIGHT(''000000'' + CAST(l.Acno AS VARCHAR(6)), 6)) AS ACNO, c.name, c.PAN, l.CustNo, l.LIMITAMT, l.SECVALUE, (l.ClearBal + l.AccumuInt + l.clgamt) AS BALANCE, l.NPACode, l.NPADt, l.OverdueAmt, l.UnreserveInt, l.INTIND7AMT, l.PENALINTIND7AMT, l.AcSts, l.Limit, l.DueInst, l.InstAmt FROM MIS.dbo.' + QuoteName( + N ' As l INNER JOIN c ON l.custno = c.Code WHERE AcSts != 9 AND ClearBal < 0 With clauses are supported by PostgreSQL, Oracle, SQLite3 and MSSQL. WHERE SCHEMA_NAME(schema_id) = ' dbo' And name = name
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |