[Dev.BigBear]

دلوقتى انا عملت كل حاجه علشام الانفى يظهر و برضو مفيش فيده غيرت النست كذه مره
و كانت من داتا الفورجتين شغاله فيها ميه ميه
بس لما بجرب عندى مفيش فيده




جربت الكويرى ده

USE [SRO_VT_SHARD]
GO --/*Fix Envy By MyOwnJ3lood*/
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41540'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41550'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41560'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41570'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41580'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41590'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42460'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42470'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42480'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42490'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42500'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42510'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42520'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42530'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43420'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43430'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43440'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43450'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43460'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43470'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43480'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43490'

جربتو كتير اووى و مفيش اى حاجه و حولت اجرب و غير ال1 لى 2 و 3 بردو مفيش حاجه بتظهر و اتاكت ان الانفى مفتوح
من الداتا و استخدمت الكويرى ده علشان اتاكد انو مفتوح

SELECT*FROM _REFOBJCOMMON
WHERE CODENAME128 LIKE '%ENVY%'

و بردو شوفت ال_RefNest و TacticsID
و استخدمت الكويرى ده علشان اتاكد انو مربوطيب ببعض و بردو مفيش فيده

select*from Tab_RefNest
where dwTacticsID in (43420,
43430,
43440,
43450,
43460,
43470,
43480,
43490)

و مع العلم انى DB D11 Clean
Client VSro.188 Vitnam

ممكن حلول تنيه لو فى بقى علشان انا تعبت من الموضوع ده بقالو كتير اوووى