ùìåí àåøçäúðú÷åú

äúçáøåú  |  äøùîä

LawData_PsakDin_Search.Search==>Set_Find_Res("","","","","","","","","","","","","","","451536906","","","","0","","","","","","","","*&*","*&*","","","","","","","","îåøéä ôøéîï","","","","","","99999","","","","","","","","","","","","","","0","1","","") LawData_PsakDin_Search(Result)==> <-->SearchMofaim=<-->strMilaCol=<-->swSearchTxt=False<-->sFind_Res=Find_Res_<-->sql_WWWW=<-->sqlTblWrite=insert into Find_Res_ with (rowlock) (Type, C,Screen,SessionId,Shura) select top 10005 1, q2.C,'1',451536906,q2.shura from ( select top 10005 p.c,min(P2.Shura) as shura,p.fromdate from PsakDin p (nolock) left join Thum on Thum.C=p.Thum left join PsakDin_Type on PsakDin_Type.C=p.PsakDin_Type left join Ezor on Ezor.C=p.Ezor left join Tik_Type on Tik_Type.C=p.Tik_Type left join Arkaa_Type on Arkaa_Type.C=p.Arkaa_Type inner join (select -2 as Shura) as P2 on 1=1 where ( (p.OrechDin1 LIKE '%îåøéä ôøéîï%' or p.OrechDin2 LIKE '%îåøéä ôøéîï%') or ( p.OrechDin1 LIKE '%îåøéä%' and p.OrechDin1 LIKE '%ôøéîï%') or ( p.OrechDin2 LIKE '%îåøéä%' and p.OrechDin2 LIKE '%ôøéîï%')) group by p.C,p.fromDate order by p.fromdate desc) q2 <-->strMilaCol_Mof=<-->strMilaCol_NColor=<--> SQL ==== select count(*) as cn from Find_Res_ (nolock) where isnull(Type,0)=1 and SessionId=451536906 13............01:08:45
ôñ÷é ãéï -
çéôåù úåöàåú ÷øåáåú
òåøêãéï: [

îåøéä ôøéîï

]