Database

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

messages wrote:

Is it possible to create a database instead name of a database?

• Easy maintenance (one database, as opposed to 20 clients with 4 years worth of databases)
  
• Easy backups (since all is in one database)
  
• Easier cross-querying (summing the data over multiple years)
  
• Easier to understand (KISS applies to almost everything, everywhere)

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]