|   
Home    |    Contact Us    |    Service Center    |    Customer
select ROW_NUMBER() OVER (order by products.Porder,Pmakat ) as RowNumber, isnull(PWeight,0) as PWeight, isnull(Pscreen,0) as Pscreen,isnull(Pmemory,0)as Pmemory,isnull(Pdisk,0)as Pdisk,Pname,PnameEN,PID,Pmakat,Pprice,PCprice,POprice from [productsView] as products where (Ponline = 1) AND PID in ( select pid from [productsView] as products where (Ponline = 1) AND (Pmakat like N'%' + @searchStr + '%' OR PnameEN like N'%' + @searchStr + '%' OR Pname like N'%' + @searchStr + '%' ) AND PID IN (Select PID from productCategory where PcatID in (SELECT SonCatID FROM [Products_GetAlllPcat](700,1))) union all select pid from [productsView] as products where (Ponline = 1) AND PID IN (Select PID from productCategory where PcatID in (SELECT SonCatID FROM Products_GetAlllPcat(700,1) AS p INNER JOIN dbo.Pcat ON p.SonCatID = dbo.Pcat.PcatID where dbo.Pcat.pcatKey like N'%' + @searchStr + '%'))) ORDER BY Porder,Pmakat

Code: DUSTMATIC 2000
0.34 | 0.62 | 0.62 | 17.50
+
Code: DUSTMATIC 2001
0.00 | 0.00 | 0.00 | 0.00
+
  • Page :
  • >
  • <
   |   
Home      |      Contact Us
Service Center      |      Customer