GetCAtalogFilterAjax Error at Line 77 - 1001: GetCatalogByID Error at Line 26 - 1: SELECT C.BRCODE, B.brname, cast(C.PRDCATALOG_ID as decimal(10)) as ID, C.CATDESC, C.CATSTATUS, C.RLSDATE, C.RMVDATE , count(distinct Style) as StyleCnt
FROM soaprod.prdcatalog c
Left outer join Soaprod.catalog_style cs on c.PRDCATALOG_ID = cs.PRDCATALOG_ID
join Soaprod.Brand B on c.brcode = b.brcode

Where c.brcode='VA' and c.CATSTATUS ='Published'
GROUP BY C.BRCODE, C.PRDCATALOG_ID, C.CATDESC, C.CATSTATUS, C.RLSDATE, C.RMVDATE, B.BRNAMe
SELECT C.BRCODE, B.brname, cast(C.PRDCATALOG_ID as decimal(10)) as ID, C.CATDESC, C.CATSTATUS, C.RLSDATE, C.RMVDATE , count(distinct Style) as StyleCnt
FROM soaprod.prdcatalog c
Left outer join Soaprod.catalog_style cs on c.PRDCATALOG_ID = cs.PRDCATALOG_ID
join Soaprod.Brand B on c.brcode = b.brcode

Where c.brcode='VA' and c.CATSTATUS ='Published'
GROUP BY C.BRCODE, C.PRDCATALOG_ID, C.CATDESC, C.CATSTATUS, C.RLSDATE, C.RMVDATE, B.BRNAMe
 
Gender
Age
Shape
Material
Color
Eye Size

Please click on a style image to view color options and details   Print