I would understand the difference between the collations and the various sorting orders if the order were '1.', '1.w', '1-', '1-w' or '1-', '1-w', '1.', '1.w'. But then I still...

Yes, you pointed me to the right direction. It is a collation thing.

SELECT Id
FROM @s
ORDER BY Id COLLATE Latin1_General_CI_AI
 
SELECT Id
FROM @s
ORDER BY Id COLLATE SQL_Latin1_General_CP1_CI_AI

My database...

Yes, you pointed me to the right direction. It is a collation thing.

SELECT Id
FROM @s
ORDER BY Id COLLATE Latin1_General_CI_AI
 
SELECT Id
FROM @s
ORDER BY Id COLLATE SQL_Latin1_General_CP1_CI_AI

My database...

I got exactly the same result as with using NVARCHAR.

I get the same (wrong) results, VARCHAR or NVARCHAR makes no difference.

Hi Jeff,

Ik don't understand the BuildTestHierarchy stored procedure.

In my database I get the Employee table, but I don't see any column of type hierarchyid.

Do I have to do some additional...

Although you will find views, rules, defaults, etc. with the word "order" in them, you may not find ALL views, rules, etc. with the word "order".

For larger objects the text...

Another variaton, using the MONTH function:

SELECT [Month] = DATENAME(mm,SomeDateTime),

Amount = SUM(SomeAmount)

FROM #MyHead

WHERE SomeDateTime >= '2010'...