Sculptures
Sculptures
Error in SQL:Errores en operacion:
1. WITH OrdersRN AS (SELECT ROW_NUMBER() OVER(ORDER BY strTitle) AS RowNum, tblImages.ID, tblImages.Pic01, tblImages.IDProduct, tblImages.pic_num, tblImages.pic_width, tblImages.pic_height, tblImages.pic_dept, tblImages.pic_weight, tblImages.dtmDate, tblImages.pic_IsMain, tblProduct.strTitle, tblProduct.intArtworkValue, tblProduct.strComments, tblProduct.ID as ProductID, tblProduct.intUserID FROM tblImages RIGHT OUTER JOIN tblProduct ON tblImages.IDProduct = tblProduct.ID and pic_IsMain=1 where tblProduct.intWorkProductID=2 ) SELECT * , (Select count(*) from OrdersRN) as CantRows, 1 * 8 as ItemNumber FROM OrdersRN WHERE RowNum BETWEEN (1 - 1) * 8 + 1 AND 1 * 8 ORDER BY strTitle
2. Conversion failed when converting the nvarchar value '">
