are those the only possible combinations?

What if a number is missing?

What if the country code is more than one digit, ex: UK = 44?

...

Yes I know but I posted that I didn't understand the rules neither

You are trying to perform the ordering now on this fashion:

(level),...

Definitely you have hit a bug in SS.

As far as I can tell the status bit IS updated correctly but the code generator is NOT generating the appropriate value...

OK now that you have specified the problem you can modify my solution as:

select number as n into #T1 from master..spt_values where number < 100 and type ='P'

select Replace (...

here is something to get you started:  

select number as n into #T1 from master..spt_values where number < 100 and type ='P'

select dbo.fn_varbintohexstr( t1.n +...

you said:

"It Cannot contain the Letter A,I or numbers  1, 0"

but in the examples

AAAAA2, AAAAA3, AAAAA4, AAAAA5, AAAAA6, AAAAA7, AAAAA8, AAAAAA9,

B22236,

 you used the letter "A"...

This is what I would do

Select Name, Sales, round(100*Sales/TotalSales,0) [% os Sales]

from

(Select Department as Name, Sum(Amount) as Sales

from SalesTable

Group by Department ) dt1

cross join (Select Sum(Amount) as TotalSales from SalesTable...

Ah...

Try:

Select * from yourTable

ORDER BY Len(level)-len(replace(level,';','')), type, ProductDesc

Cheers,

[EDIT]: Wait a minute but if the level (for ordering purposes) is the number of items then, how come

"a;b;a5;a51" is before "a;b;a3" ...

and to add a bit more ...

UPDATE FROM is not supported by DB2 that's a MS extension

Cheers,

There are things still not clear for me.

You said: "The tree structure needs sorting based on tree level + type of material + description"

Then on the example why :

Just to complement abit more govinn solution. Make sure "dateadded" does not contains NULLs and change

datepart(yy, dateadded)     for    year ( dateadded )

datepart(mm, dateadded)    for    month ( dateadded )

datepart(day, date...

EM is using sysindexes and therefore does not need to be equal. Try executing

DBCC UPDATEUSAGE (0) on the DB that you are quering and you'll see the numbers match...

Like PW said change pkey in the join for your primary key column(s)

CREATE TRIGGER Q_U on dbo.Quarter

FOR UPDATE

AS

BEGIN

if @@rowcount = 0 return

UPDATE Q SET LastModified = getdate()

FROM Quarter Q join...

rowcnt is the one that you should be using because:

1. rowcnt is bigint, (rows is only int)

2. rows is provided only for backward compatibility

Cheers,

>> Either we have been extremely lucky or timestamps are incremented in a uniform manor as I believe/hope they should be! <<

My point is that they may have been behaving...