count product in sqlserver use PARTITION BY

Question

count product by shape:

 

use this query:

 

select tbl_shape.Shape +' ('+ltrim(str((select COUNT(1) from tbl_Image_Master where tbl_Image_Master.Shape_Id=ShapeId)))+')'

as Shape_Name From dbo.tbl_shape group by tbl_shape.Shape,tbl_shape.shapeId ORDER BY tbl_shape.Shape Asc

 

this is give output like:

        Shape_Name

• Box and Bricks (31)
• Chips (26)
• Coin (19)
• Fancy (11) 

but in this result some product name and image same

i want count only one that have same name and image

 

what it is possible

please solve this query 

 

Answer 1

<b> Report Date:&nbsp;&nbsp; 2016-11-21 &nbsp;&nbsp;Optometrist: &nbsp;&nbsp;start &nbsp;&nbsp;Time:&nbsp;&nbsp; Consultant: &nbsp;&nbsp;Dr.suresh</b>

Answer 2

Hi,

 

Please try below query - 

DECLARE @x XML = '<table WIDTH="100%" CELLPADDING="1" CELLSPACING="1">

<tr style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">
   <td><b>Report Date : </b>2016-11-21 </td>
  <td><b>Optometrist : </b> </td>
  <td><b>Start Time : </b> </td>
</tr>

<tr style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">
        <td><b>Consultant : </b>Dr.Suresh </td>
</tr>

</table>'

SELECT t.c.value('.', 'NVARCHAR(MAX)')
FROM @x.nodes('*') t(c)

 

Reference :

https://stackoverflow.com/questions/38868364/sql-remove-all-html-tags-in-a-string