Database

SkyRunner wrote:

but could you please give the 5 lines of code you are talking about,

INSERT INTO Table1(Column1)
    SELECT  REPLACE(OriginalColumn, '_', '')
      FROM  Table2 t2
            LEFT OUTER JOIN Table1 t1 ON t1.Column1 = REPLACE(OriginalColumn, '_', '')
     WHERE  t1.Column1 IS NULL

SELECT
     REPLACE([ProductName],'_','') AS NewName,
     COUNT(*)
FROM
     [Product] 
GROUP BY
     REPLACE([ProductName],'_','')
HAVING
     COUNT(*) > 1

INSERT INTO [NewProductTable]
(
	[NewProductName],
	[NewCol1],
	[NewCol2]
)
SELECT
	REPLACE([ProductName],'_',' '),
	[Col1],
	[Col2]
FROM
	[Product]
WHERE
        (REPLACE([ProductName],'_',' ') = ProductName) OR
	(REPLACE([ProductName],'_',' ') NOT IN (SELECT [ProductName] FROM [Product]))

yousefshokati wrote:

user that can be mapped to it.

Select Qty, Category From Inv1 Order By Category DESC, Qty DESC

SELECT Qty, t1.cat FROM Inv1 AS t1
INNER JOIN
(SELECT MAX(Qty) AS mq, cat FROM Inv1 GROUP BY cat) AS t2
ON t1.cat=t2.cat
ORDER BY mq DESC, Qty DESC

SELECT Qty, t1.cat FROM Inv1 AS t1
INNER JOIN
(SELECT MAX(Qty) AS mq, cat FROM Inv1 GROUP BY cat) AS t2
ON t1.cat=t2.cat
ORDER BY mq DESC, cat, Qty DESC