SQL does have the SQL Server Health & History (SQLH2) tool that is opensource now.

http://www.codeplex.com/sqlh2

Try this. If a coulumn is not in the group by, it must use an aggregate function like sum.

Select ref, design, sum(qtt) sumqtt, armazem

FROM SL

GROUP BY ref, design, armazem

Here are a couple of different ways.

--You can force the lenght to be 9 by concatenating and then compare.

SELECT MAX(CustNo) as MaxCustNum

FROM Account

WHERE LEFT( RIGHT('000000000' + CustNo,9),...

You can always create a batch file and call the batch file from xp_cmdshell.

This should work. You have to replace any tick marks with double tick marks. One thing I usually do is use the print statement to help debug string...

Try this. You can use the isnumeric function to test the value.

Select Count(*) NumericCount

From Table1

Where isnumeric(ordernumber) = 1

Select Count(*) NonNumericCount

From Table1

Where isnumeric(ordernumber) = 0

This should get you close. You are going to have to add something in the column that has the query to identify a person like...

And A.CustomerID = B.CustomerID

Right Now...

This is what I came up with.

Declare @ssn varchar(20)

--Test1

Set @ssn = '1-111-1--111-1'

Select stuff(stuff(replace(@ssn,'-',''),4,0,'-'), 7,0,'-')

--Test2

Set @ssn = '111111111'

Select stuff(stuff(replace(@ssn,'-',''),4,0,'-'), 7,0,'-')

As long as it is the only column in the query meaning no other columns will cause the cities to duplicate you should be able to use the Distinct...

Here is what I use to create a data dictionary using T-SQL.

http://www.mssqltips.com/tip.asp?tip=1499

If you add an Identity column with a name like RowID it will resolve the issue. You can also use this column as the Primary Key.

Try this. You have to use a having clause in order to check the count.

Select AccountDescription,

Count(1) AS LineItemCount,

SUM(InvoiceLineItemAmount) AS Line_Item_Sum

From InvoiceLineItems

JOIN...

Here is a great example.

http://www.mssqltips.com/tip.asp?tip=1487

For a user database it would be something like this.

USE [master]

GO

ALTER DATABASE [DatabaseName] COLLATE SQL_Latin1_General_CP1_CI_AS

GO

You can change it on the user databases, but in order to change it on the system databases you have to reinstall SQL.