I work on sql server 2012 i have error message display when run query
message error
error timeout expired the timeout period elapsed prior to completion the operation or the server is not responding
query give this error
- SELECT '' AS AccountCode, '' AS AccountName, sub, SubLdgAraName,
- SubLdgLatName,
- case when SUM(ttt.Credite)-SUM(ttt.Debite)>0 then SUM(ttt.Credite)-SUM(ttt.Debite) else 0 end AS Credite ,
- case when SUM(ttt.Debite)-SUM(ttt.Credite)>0 then SUM(ttt.Debite)-SUM(ttt.Credite) else 0 end AS Debite,
- 0 AS PrevCredit, 0 AS PrevDebit, 0 AS trxserial, 0 AS linenum, '' AS GlTrxDate, 0 AS TrxJorCode, '???? ??????' AS DescAra, '' AS MyKey, '' AS SubLdgCode1, '' AS SubLdgAraName1,
- '' AS SubLdgCode2, '' AS SubLdgAraName2, BranchCode, 0 as TrxYear /*dbo.VAllSubLedgerTrxCash.TrxYear*/ , 0 as TrxType /*dbo.VAllSubLedgerTrxCash.TrxType*/
- ,0 as TypeTrxSafeCode, 0 as Year,
- 0 as Serial,'' as TrxName, '' as AccAraName, '' as AccengName, BranchAraName, BranchEngName ,'' as docno
- , '' as CheckNo ,CheckDueDate, CheckStutas,
- ChkStatusAraName, ChkStatusLatName , 0 as closingRec , 0 as OpeningRec , 0 as FirstRec /* dbo.VAllSubLedgerTrxCash.closingRec , dbo.VAllSubLedgerTrxCash.OpeningRec, dbo.VAllSubLedgerTrxCash.FirstRec */
- , '' AS GlTrxDateH
- from ( SELECT '' AS AccountCode, '' AS AccountName, dbo.AllSubLedgerCode.SubLdgCode AS sub, dbo.AllSubLedgerCode.SubLdgAraName,
- dbo.AllSubLedgerCode.SubLdgLatName,
- case when SUM(dbo.VAllSubLedgerTrxCash.EqCredit)-SUM(dbo.VAllSubLedgerTrxCash.EqDebit)>0 then SUM(dbo.VAllSubLedgerTrxCash.EqCredit)-SUM(dbo.VAllSubLedgerTrxCash.EqDebit) else 0 end AS Credite ,
- case when SUM(dbo.VAllSubLedgerTrxCash.EqDebit)-SUM(dbo.VAllSubLedgerTrxCash.EqCredit)>0 then SUM(dbo.VAllSubLedgerTrxCash.EqDebit)-SUM(dbo.VAllSubLedgerTrxCash.EqCredit) else 0 end AS Debite,
- 0 AS PrevCredit, 0 AS PrevDebit, 0 AS trxserial, 0 AS linenum, '' AS GlTrxDate, 0 AS TrxJorCode, '???? ??????' AS DescAra, '' AS MyKey, '' AS SubLdgCode1, '' AS SubLdgAraName1,
- '' AS SubLdgCode2, '' AS SubLdgAraName2, dbo.VAllSubLedgerTrxCash.BranchCode, 0 as TrxYear /*dbo.VAllSubLedgerTrxCash.TrxYear*/ , 0 as TrxType /*dbo.VAllSubLedgerTrxCash.TrxType*/
- ,0 as TypeTrxSafeCode, 0 as Year,
- 0 as Serial,'' as TrxName, '' as AccAraName, '' as AccengName, dbo.Branches.BranchAraName, dbo.Branches.BranchEngName ,'' as docno
- , '' as CheckNo /*dbo.VAllSubLedgerTrxCash.CheckNo */ ,dbo.VAllSubLedgerTrxCash.CheckDueDate, dbo.VAllSubLedgerTrxCash.CheckStutas,
- dbo.VAllSubLedgerTrxCash.ChkStatusAraName, dbo.VAllSubLedgerTrxCash.ChkStatusLatName , 0 as closingRec , 0 as OpeningRec , 0 as FirstRec /* dbo.VAllSubLedgerTrxCash.closingRec , dbo.VAllSubLedgerTrxCash.OpeningRec, dbo.VAllSubLedgerTrxCash.FirstRec */
- , '' AS GlTrxDateH
- FROM dbo.VAllSubLedgerTrxCash INNER JOIN
- dbo.AllSubLedgerCode ON dbo.VAllSubLedgerTrxCash.BranchCode = dbo.AllSubLedgerCode.BranchCode AND
- dbo.VAllSubLedgerTrxCash.code = dbo.AllSubLedgerCode.SubLdgTypeCode AND dbo.VAllSubLedgerTrxCash.Sub = dbo.AllSubLedgerCode.SubLdgCode INNER JOIN
- dbo.Branches ON dbo.VAllSubLedgerTrxCash.BranchCode = dbo.Branches.BranchCode AND dbo.AllSubLedgerCode.BranchCode = dbo.Branches.BranchCode
- WHERE 1=1 AND (dbo.VAllSubLedgerTrxCash.BranchCode in( 1)) And ((dbo.VAllSubLedgerTrxCash.OpeningRec = 0) OR (dbo.VAllSubLedgerTrxCash.OpeningRec IS NULL)) AND ((dbo.VAllSubLedgerTrxCash.closingRec = 0) OR (dbo.VAllSubLedgerTrxCash.closingRec IS NULL)) /* Mohamed Refaat Stoped in Prev only 17 07 2017 */ And VAllSubLedgerTrxCash.SubLdgCode not IN ( SELECT subCode FROM PerSubLedgerCode WHERE (UserID = 'Admin') And (Subtype =8)) and AccountCode not IN (SELECT AccCode FROM dbo.PerAccounts AS PerAccounts_1 WHERE (UserID = 'Admin')) and year ( GLTrxDate) = year ( '01/01/2018') and GLTrxDate < '01/01/2018' and Code = 8
- GROUP BY dbo.AllSubLedgerCode.SubLdgCode, dbo.AllSubLedgerCode.SubLdgAraName, dbo.AllSubLedgerCode.SubLdgLatName, dbo.VAllSubLedgerTrxCash.BranchCode,
- /*dbo.VAllSubLedgerTrxCash.TrxYear, dbo.VAllSubLedgerTrxCash.TrxType , */ dbo.Branches.BranchAraName, dbo.Branches.BranchEngName
- /* , dbo.VAllSubLedgerTrxCash.CheckNo*/ ,dbo.VAllSubLedgerTrxCash.CheckDueDate, dbo.VAllSubLedgerTrxCash.CheckStutas,
- dbo.VAllSubLedgerTrxCash.ChkStatusAraName, dbo.VAllSubLedgerTrxCash.ChkStatusLatName /* , dbo.VAllSubLedgerTrxCash.closingRec , dbo.VAllSubLedgerTrxCash.OpeningRec, dbo.VAllSubLedgerTrxCash.FirstRec , CONVERT(varchar, VAllSubLedgerTrxCash.GlTrxDate, 111)
- having abs (sum (Debit ) - sum (Credit ) ) != 0 /*???? ???? ???? ?? ???? ?? ???? ?????? ????? ??????*/ */ union all SELECT '' AS AccountCode, '' AS AccountName, dbo.AllSubLedgerCode.SubLdgCode AS sub, dbo.AllSubLedgerCode.SubLdgAraName,
- dbo.AllSubLedgerCode.SubLdgLatName,
- case when SUM(dbo.VAllSubLedgerTrxCash.EqCredit)-SUM(dbo.VAllSubLedgerTrxCash.EqDebit)>0 then SUM(dbo.VAllSubLedgerTrxCash.EqCredit)-SUM(dbo.VAllSubLedgerTrxCash.EqDebit) else 0 end AS Credite ,
- case when SUM(dbo.VAllSubLedgerTrxCash.EqDebit)-SUM(dbo.VAllSubLedgerTrxCash.EqCredit)>0 then SUM(dbo.VAllSubLedgerTrxCash.EqDebit)-SUM(dbo.VAllSubLedgerTrxCash.EqCredit) else 0 end AS Debite,
- 0 AS PrevCredit, 0 AS PrevDebit, 0 AS trxserial, 0 AS linenum, '' AS GlTrxDate, 0 AS TrxJorCode, '???? ??????' AS DescAra, '' AS MyKey, '' AS SubLdgCode1, '' AS SubLdgAraName1,
- '' AS SubLdgCode2, '' AS SubLdgAraName2, dbo.VAllSubLedgerTrxCash.BranchCode, 0 as TrxYear /*dbo.VAllSubLedgerTrxCash.TrxYear*/ , 0 as TrxType /*dbo.VAllSubLedgerTrxCash.TrxType*/
- ,0 as TypeTrxSafeCode, 0 as Year,
- 0 as Serial,'' as TrxName, '' as AccAraName, '' as AccengName, dbo.Branches.BranchAraName, dbo.Branches.BranchEngName ,'' as docno
- , '' as CheckNo /*dbo.VAllSubLedgerTrxCash.CheckNo */ ,dbo.VAllSubLedgerTrxCash.CheckDueDate, dbo.VAllSubLedgerTrxCash.CheckStutas,
- dbo.VAllSubLedgerTrxCash.ChkStatusAraName, dbo.VAllSubLedgerTrxCash.ChkStatusLatName , 0 as closingRec , 0 as OpeningRec , 0 as FirstRec /* dbo.VAllSubLedgerTrxCash.closingRec , dbo.VAllSubLedgerTrxCash.OpeningRec, dbo.VAllSubLedgerTrxCash.FirstRec */
- , '' AS GlTrxDateH
- FROM dbo.VAllSubLedgerTrxCash INNER JOIN
- dbo.AllSubLedgerCode ON dbo.VAllSubLedgerTrxCash.BranchCode = dbo.AllSubLedgerCode.BranchCode AND
- dbo.VAllSubLedgerTrxCash.code = dbo.AllSubLedgerCode.SubLdgTypeCode AND dbo.VAllSubLedgerTrxCash.Sub = dbo.AllSubLedgerCode.SubLdgCode INNER JOIN
- dbo.Branches ON dbo.VAllSubLedgerTrxCash.BranchCode = dbo.Branches.BranchCode AND dbo.AllSubLedgerCode.BranchCode = dbo.Branches.BranchCode
- WHERE 1=1 AND (dbo.VAllSubLedgerTrxCash.BranchCode in( 1)) And IsNULL (dbo.VAllSubLedgerTrxCash.OpeningRec ,0) = 1 And IsNULL (dbo.VAllSubLedgerTrxCash.closingRec ,0) = 0 And VAllSubLedgerTrxCash.SubLdgCode not IN ( SELECT subCode FROM PerSubLedgerCode WHERE (UserID = 'Admin') And (Subtype =8)) and AccountCode not IN (SELECT AccCode FROM dbo.PerAccounts AS PerAccounts_1 WHERE (UserID = 'Admin')) and year ( GLTrxDate) = year ( '01/01/2018') and Code = 8
- GROUP BY dbo.AllSubLedgerCode.SubLdgCode, dbo.AllSubLedgerCode.SubLdgAraName, dbo.AllSubLedgerCode.SubLdgLatName, dbo.VAllSubLedgerTrxCash.BranchCode,
- /*dbo.VAllSubLedgerTrxCash.TrxYear, dbo.VAllSubLedgerTrxCash.TrxType , */ dbo.Branches.BranchAraName, dbo.Branches.BranchEngName
- /* , dbo.VAllSubLedgerTrxCash.CheckNo*/ ,dbo.VAllSubLedgerTrxCash.CheckDueDate, dbo.VAllSubLedgerTrxCash.CheckStutas,
- dbo.VAllSubLedgerTrxCash.ChkStatusAraName, dbo.VAllSubLedgerTrxCash.ChkStatusLatName /* , dbo.VAllSubLedgerTrxCash.closingRec , dbo.VAllSubLedgerTrxCash.OpeningRec, dbo.VAllSubLedgerTrxCash.FirstRec , CONVERT(varchar, VAllSubLedgerTrxCash.GlTrxDate, 111)
- having abs (sum (Debit ) - sum (Credit ) ) != 0 /*???? ???? ???? ?? ???? ?? ???? ?????? ????? ??????*/ */ ) as ttt
- GROUP BY ttt.sub, ttt.SubLdgAraName, ttt.SubLdgLatName, ttt.BranchCode,
- ttt.BranchAraName, ttt.BranchEngName
- ,ttt.CheckDueDate, ttt.CheckStutas,
- ttt.ChkStatusAraName, ttt.ChkStatusLatName union all
- SELECT dbo.VAllSubLedgerTrxCash.AccountCode, dbo.VAllSubLedgerTrxCash.AccountName, dbo.AllSubLedgerCode.SubLdgCode AS sub,
- dbo.AllSubLedgerCode.SubLdgAraName, dbo.AllSubLedgerCode.SubLdgLatName, SUM(dbo.VAllSubLedgerTrxCash.EqCredit) AS Credite,
- SUM(dbo.VAllSubLedgerTrxCash.EqDebit) AS Debite, 0 AS PrevCredit, 0 AS PrevDebit, dbo.VAllSubLedgerTrxCash.TrxSerial, dbo.VAllSubLedgerTrxCash.linenum,
- dbo.VAllSubLedgerTrxCash.GlTrxDate, dbo.VAllSubLedgerTrxCash.TrxJorCode, dbo.VAllSubLedgerTrxCash.DescAra, dbo.TrxHeaderSafe.MyKey,
- AllSubLedgerCode_1.SubLdgCode AS SubLdgCode1, AllSubLedgerCode_1.SubLdgAraName AS SubLdgAraName1,
- AllSubLedgerCode_2.SubLdgCode AS SubLdgCode2, AllSubLedgerCode_2.SubLdgAraName AS SubLdgAraName2, dbo.VAllSubLedgerTrxCash.BranchCode,
- dbo.VAllSubLedgerTrxCash.TrxYear, dbo.VAllSubLedgerTrxCash.TrxType, dbo.TrxHeaderSafe.TypeTrxSafeCode, dbo.TrxHeaderSafe.Year,
- CASE WHEN VtargetDetailsKey.TrxSerial IS NULL THEN dbo.TrxHeaderSafe.Serial ELSE VtargetDetailsKey.TrxSerial END AS Serial,
- CASE WHEN VtargetDetailsKey.TrxArbName IS NULL
- THEN dbo.VAllSubLedgerTrxCash.SafeTrxTypeAraName ELSE VtargetDetailsKey.TrxArbName END AS SafeTrxTypeAraName, dbo.VAllSubLedgerTrxCash.AccAraName, dbo.VAllSubLedgerTrxCash.AccengName, dbo.Branches.BranchAraName,
- dbo.Branches.BranchEngName,TrxHeaderSafe.DocNo
- , dbo.VAllSubLedgerTrxCash.CheckNo ,dbo.VAllSubLedgerTrxCash.CheckDueDate, dbo.VAllSubLedgerTrxCash.CheckStutas,
- dbo.VAllSubLedgerTrxCash.ChkStatusAraName, dbo.VAllSubLedgerTrxCash.ChkStatusLatName , dbo.VAllSubLedgerTrxCash.closingRec , dbo.VAllSubLedgerTrxCash.OpeningRec, dbo.VAllSubLedgerTrxCash.FirstRec
- ,replace ( convert(varchar,dbo.VAllSubLedgerTrxCash.GlTrxDate,131), '12:00:00:000AM' , '') AS GlTrxDateH
- FROM dbo.VAllSubLedgerTrxCash INNER JOIN
- dbo.AllSubLedgerCode ON dbo.VAllSubLedgerTrxCash.BranchCode = dbo.AllSubLedgerCode.BranchCode AND dbo.VAllSubLedgerTrxCash.code = dbo.AllSubLedgerCode.SubLdgTypeCode AND
- dbo.VAllSubLedgerTrxCash.Sub = dbo.AllSubLedgerCode.SubLdgCode INNER JOIN
- dbo.TrxHeaderSafe ON dbo.VAllSubLedgerTrxCash.BranchCode = dbo.TrxHeaderSafe.BranchCode AND dbo.VAllSubLedgerTrxCash.TrxYear = dbo.TrxHeaderSafe.Year AND
- dbo.VAllSubLedgerTrxCash.TrxSerial = dbo.TrxHeaderSafe.Serial AND dbo.VAllSubLedgerTrxCash.SafeTrxTypeCode = dbo.TrxHeaderSafe.TypeTrxSafeCode INNER JOIN
- dbo.TrxFooterSafe ON dbo.VAllSubLedgerTrxCash.BranchCode = dbo.TrxFooterSafe.BranchCode AND dbo.VAllSubLedgerTrxCash.TrxYear = dbo.TrxFooterSafe.Year AND
- dbo.VAllSubLedgerTrxCash.TrxSerial = dbo.TrxFooterSafe.Serial AND dbo.VAllSubLedgerTrxCash.linenum = dbo.TrxFooterSafe.TrxLine AND
- dbo.VAllSubLedgerTrxCash.SafeTrxTypeCode = dbo.TrxFooterSafe.TypeTrxSafeCode INNER JOIN
- dbo.Branches ON dbo.VAllSubLedgerTrxCash.BranchCode = dbo.Branches.BranchCode AND dbo.AllSubLedgerCode.BranchCode = dbo.Branches.BranchCode LEFT OUTER JOIN
- dbo.VtargetDetailsKey ON dbo.TrxHeaderSafe.MyKey = dbo.VtargetDetailsKey.myOtherkey LEFT OUTER JOIN
- dbo.AllSubLedgerCode AS AllSubLedgerCode_2 ON dbo.TrxFooterSafe.BranchCode = AllSubLedgerCode_2.BranchCode AND dbo.TrxFooterSafe.SubLdgCodeType2 = AllSubLedgerCode_2.SubLdgTypeCode AND
- dbo.TrxFooterSafe.SubLdgCode2 = AllSubLedgerCode_2.SubLdgCode LEFT OUTER JOIN
- dbo.AllSubLedgerCode AS AllSubLedgerCode_1 ON dbo.TrxFooterSafe.BranchCode = AllSubLedgerCode_1.BranchCode AND dbo.TrxFooterSafe.SubLdgCodeType1 = AllSubLedgerCode_1.SubLdgTypeCode AND
- dbo.TrxFooterSafe.SubLdgCode1 = AllSubLedgerCode_1.SubLdgCode
- WHERE 1=1 AND (dbo.VAllSubLedgerTrxCash.BranchCode in( 1)) And ((dbo.VAllSubLedgerTrxCash.OpeningRec = 0) OR (dbo.VAllSubLedgerTrxCash.OpeningRec IS NULL)) AND ((dbo.VAllSubLedgerTrxCash.closingRec = 0) OR (dbo.VAllSubLedgerTrxCash.closingRec IS NULL)) And VAllSubLedgerTrxCash.SubLdgCode not IN ( SELECT subCode FROM PerSubLedgerCode WHERE (UserID = 'Admin') And (Subtype =8)) and AccountCode not IN (SELECT AccCode FROM dbo.PerAccounts AS PerAccounts_1 WHERE (UserID = 'Admin')) and GLTrxDate >= '01/01/2018' and GLTrxDate <= '03/24/2018' and Code = 8
- GROUP BY dbo.AllSubLedgerCode.SubLdgCode, dbo.AllSubLedgerCode.SubLdgAraName, dbo.AllSubLedgerCode.SubLdgLatName, dbo.VAllSubLedgerTrxCash.AccountCode,
- dbo.VAllSubLedgerTrxCash.AccountName, dbo.VAllSubLedgerTrxCash.TrxSerial, dbo.VAllSubLedgerTrxCash.linenum, dbo.VAllSubLedgerTrxCash.GlTrxDate,
- dbo.VAllSubLedgerTrxCash.TrxJorCode, dbo.VAllSubLedgerTrxCash.DescAra, dbo.TrxHeaderSafe.MyKey, AllSubLedgerCode_1.SubLdgCode,
- AllSubLedgerCode_1.SubLdgAraName, AllSubLedgerCode_2.SubLdgCode, AllSubLedgerCode_2.SubLdgAraName, dbo.VAllSubLedgerTrxCash.BranchCode,
- dbo.VAllSubLedgerTrxCash.TrxYear, dbo.VAllSubLedgerTrxCash.TrxType, dbo.TrxHeaderSafe.TypeTrxSafeCode, dbo.TrxHeaderSafe.Year, dbo.TrxHeaderSafe.Serial,dbo.VAllSubLedgerTrxCash.SafeTrxTypeAraName, dbo.VtargetDetailsKey.TrxArbName, dbo.VtargetDetailsKey.TrxSerial, dbo.VAllSubLedgerTrxCash.AccAraName, dbo.VAllSubLedgerTrxCash.AccengName,
- dbo.Branches.BranchAraName, dbo.Branches.BranchEngName,TrxHeaderSafe.DocNo
- , dbo.VAllSubLedgerTrxCash.CheckNo ,dbo.VAllSubLedgerTrxCash.CheckDueDate, dbo.VAllSubLedgerTrxCash.CheckStutas,
- dbo.VAllSubLedgerTrxCash.ChkStatusAraName, dbo.VAllSubLedgerTrxCash.ChkStatusLatName , dbo.VAllSubLedgerTrxCash.closingRec , dbo.VAllSubLedgerTrxCash.OpeningRec, dbo.VAllSubLedgerTrxCash.FirstRec, CONVERT(varchar, VAllSubLedgerTrxCash.GlTrxDate, 111)
Manish KumarPosted Mar 26, 2018, 3:32 AM
Shahriar NikkhahPosted Mar 24, 2018, 11:08 PM
Nitin SontakkePosted Mar 24, 2018, 10:09 PM