How to remove same data in a table row by javascript.

<table id="tbl" border="1" cellpadding="3" cellspacing="0">
                                        <tr><th>Category</th><th>Product</th><th>Size</th><th>Price</th><th>Shipping</th></tr>
                                        <tr><td>Category-1</td><td>Product-1</td><td>Big</td><td>102</td><td>Free</td></tr>
                                        <tr><td>Category-1</td><td>Product-1</td><td>Big</td><td>132</td><td>Free</td></tr>
                                        <tr><td>Category-1</td><td>Product-2</td><td>Big</td><td>130</td><td>Free</td></tr>
                                        <tr><td>Category-1</td><td>Product-2</td><td>Small</td><td>100</td><td>Free</td></tr>
                                        <tr><td>Category-2</td><td>Product-3</td><td>Big</td><td>130</td><td>Free</td></tr>
                                        <tr><td>Category-2</td><td>Product-3</td><td>Big</td><td>100</td><td>Free</td></tr>
                                        <tr><td>Category-2</td><td>Product-3</td><td>Small</td><td>100</td><td>10</td></tr>
                                        <tr><td>Category-2</td><td>Product-4</td><td>Big</td><td>150</td><td>10</td></tr>
                                        <tr><td>Category-3</td><td>Product-5</td><td>Big</td><td>150</td><td>10</td></tr>
                                        <tr><td>Category-3</td><td>Product-5</td><td>Small</td><td>120</td><td>10</td></tr>
                                        <tr><td>Category-3</td><td>Product-5</td><td>Big</td><td>120</td><td>Free</td></tr>
                                        <tr><td>Category-4</td><td>Product-6</td><td>Big</td><td>120</td><td>10</td></tr>
                                        <tr><td>Category-4</td><td>Product-6</td><td>Small</td><td>120</td><td>10</td></tr>
                                    </table>

-----------------------------------------------------------------------------

 $(function () {
                  
                    function groupTable($rows, startIndex, total) {
                        if (total === 0) {
                            return;
                        }
                        var i, currentIndex = startIndex, count = 1, lst = [];
                        var tds = $rows.find('td:eq(' + currentIndex + ')');
                        var ctrl = $(tds[0]);
                        lst.push($rows[0]);
                        for (i = 1; i <= tds.length; i++) {
                            if (ctrl.text() == $(tds[i]).text()) {
                                count++;
                                $(tds[i]).addClass('deleted');
                                lst.push($rows[i]);
                            }
                            else {
                                if (count > 1) {
                                    ctrl.attr('rowspan', count);
                                    groupTable($(lst), startIndex + 1, total - 1)
                                }
                                count = 1;
                                lst = [];
                                ctrl = $(tds[i]);
                                lst.push($rows[i]);
                            }
                        }
                    }
                    groupTable($('#tbl tr:has(td)'), 0, 3);
                    $('#tbl .deleted').remove();

                });

For Start New Promotion Sale Please Execute it all server

--- Aikhane apni connect er ip likhben r ai block chalaben

GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[USP_Channel_Customer_List]

@ChID INT
AS
BEGIN

if @ChID!=0
BEGIN
IF @ChID=109
BEGIN
UPDATE SYSSETTING SET Channel_POS_BILL_OLD = Channel_POS_BILL, Channel_POS_BILL = 1
SELECT PInt_ID,
Partner_ID+'_'+PartnerName+' ('+[Address]+')' [PartnerName],
ChID,
CAST(ROUND(DiscAllowed, 0, 0) AS INT) AS DiscAllowed
FROM [POSX].[dbo].[PARTNER_MASTER]Where [ChID]=@ChID
END
ELSE
BEGIN
UPDATE SYSSETTING SET Channel_POS_BILL = Channel_POS_BILL_OLD
SELECT PInt_ID,
Partner_ID+'_'+PartnerName+' ('+[Address]+')' [PartnerName],
ChID,
CAST(ROUND(DiscAllowed, 0, 0) AS INT) AS DiscAllowed
FROM [dbo].[PARTNER_MASTER]Where [ChID]=@ChID
END
--109
--[SYSSETTING]
END
ELSE if @ChID=0

BEGIN
SELECT PInt_ID,
Partner_ID+'_'+PartnerName+' ('+[Address]+')' [PartnerName],
ChID,
CAST(ROUND(DiscAllowed, 0, 0) AS INT) AS DiscAllowed
FROM [dbo].[PARTNER_MASTER]Where [ChID] not in(0)
END
END

--uporer ta chalano hole chicher ta chalaben 

--

--- Aikhane apni connect er ip likhben

ALTER TABLE dbo.BILLING_HEADER

ALTER COLUMN INVOICENO nvarchar(100)

----DONE

ট্রানজেক্সন ফেইল হলে এইটা চালাতে হবে।

DECLARE @SLID INT,
     @REFID INT,
@DEVID INT

SELECT @SLID = MAX(LASTSERIALNO) FROM SYSDOCSRNO D
INNER JOIN SYSCREGISTER R ON D.REGID=R.REGISTERID
INNER JOIN SYSBUSINESSDAY Y ON Y.BUNIT_ID=R.BUNIT_ID
WHERE DOCUMENTID='POS';

SELECT @REFID=MAX(REF_ID) FROM SALES_POSSALE_HEADER D
INNER JOIN SYSCREGISTER R ON D.Device_ID=R.REGISTERID
INNER JOIN SYSBUSINESSDAY Y ON Y.BUNIT_ID=R.BUNIT_ID;

SELECT @DEVID=MIN(REGID) FROM SYSDOCSRNO WHERE DOCUMENTID='POS' AND LASTSERIALNO=@SLID;
IF @SLID=@REFID
BEGIN

UPDATE SYSDOCSRNO SET LASTSERIALNO=LASTSERIALNO+1 WHERE REGID=@DEVID AND DOCUMENTID='POS'

END

 --SELECT @SLID [SL] SELECT @REFID [REF] SELECT @DEVID [DEVICE]

Database Suspect হলে এই টা চালাতে হবে।

EXEC sp_resetstatus [POSX];
ALTER DATABASE [POSX] SET EMERGENCY
DBCC checkdb([POSX])
ALTER DATABASE [POSX] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([POSX], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [POSX] SET MULTI_USER