Hierarchyid was a new data type in SQL 2008. You posted your question in a SQL 2008 forum, so you got a SQL 2008 solution from Paul. Post your questions...

Unfortunately we don't have a realistic testset (and I'm too lazy now to generate one), but I'm almost certain that Paul's solution outperforms my solution by a factor of 'a...

Before I follow your link to that binary tree thread, I must admit I posted a solution on counting nodes in a binary tree yesterday. I was an awkward one...

Sorry, Paul. But your solutions looks interesting. I have never used Hierarchyid before, so that leaves me something to study on.

Peter

Here's a recursive solution which allow you to vary in combination sizes easily.

DECLARE @MyTable TABLE (ID INT, Name VARCHAR(100), Kf FLOAT, Tf VARCHAR(5))

INSERT INTO @MyTable

VALUES

(1, 'TestName1', 2.5000, 'True'),

(2, 'TestName1', 2.0000,...

Well, then simply remove the group by and use an inner join to get all combinations of 4 values.

SELECT

ROW_NUMBER() OVER (ORDER BY (SELECT 0)) CombinationNo,

T1.ID, T2.ID,...

I'm not sure about your requirements, so this is just a hint. For a combination of four values you can do something like this:

DECLARE @MyTable TABLE (ID INT, Name VARCHAR(100),...

Well, probably not very scalable but maybe this one will do:

if object_id('dbo.user_registration_tbl', 'u') is not null

drop table dbo.user_registration_tbl

create table dbo.user_registration_tbl

(

id int identity,

user_first_name varchar(100) not...

Not at all. And I think it was a great suggestion about upgrading a SQL2000 database...

It's because MIN(ListPrice) for ProductCategoryID 2 < 200 in the rollup row. Try something like

HAVING P.ProductSubcategoryID IS NULL OR MIN(ListPrice) > 200;

It would be nice to see the outcome of an LEFT OUTER JOIN version of the query executed by SSMS 2008. If the Owner column is NULL there is a...

An alternative is using SSIS. It contains components to work with WMI.

Peter

If I open the Tables list in SSMS 2005 the following query is fired:

SELECT

'Server[@Name=' + quotename(CAST(serverproperty(N'Servername') AS sysname),'''') + ']' + '/Database[@Name=' + quotename(db_name(),'''') + ']' + '/Table[@Name=' + quotename(tbl.name,'''')...

You mean quoted strings? From the main menu go to Query|Query Options... and select Grid. There is an option 'Quote strings containing list separators when saving .csv results'.

Peter

I'm not sure why but you have to enlarge the numbers table to get rid of the error. After that the query runs in 82 seconds on my machine.

Num1 (n)...