So, users actually need unused ID's, not used ones?

:hehe:

Why don't you want to...

And, how do you think it is sorted?

Actually HOST_NAME() is a system function.

As well as DB_NAME(), USER, SYSTEM_USER, etc.

You can use it in any SELECT statement.

Look for details in BOL.

If HOST_NAME() is what you need?

If to assume that "hits" is a positive integer number then this should work:

SELECT {blah}

FROM {sometable}

ORDER BY CASE WHEN @sort = '{whatever}' THEN STR(2147483647-hits, 10) ELSE name END ASC

I guess it's a wrong forum for this question.

SQL Server 7,2000 don't support such constructions.

You may create procedure as system procedure in master database.

Then it will be executed in context of current database.

You may enclose whole nasty part in a view.

At least it will be hidden from your eyes. 🙂

[Code]

SELECT

cc.vchrCustomer

,tintWeekNo

...

Video games are OK.

But when after competion of 4th year in University we were invoilved in checking enrolling exams...

Gosh! Just 4 year ago we all completed similar tasks! And completed...

Any chance it can cause?

Another very useful thing is BCP utility.

Look in BOL for complete description.

Can anybody give me one simple reason for those RTRIM functions you guys put everywhere?

Not quite Russian...

In Russian it would be "Sergey".

😉

But key word is "living in".

Of course. 🙂

http://tvnz.co.nz/view/page/1180693

In our country it's "I am NOT smarter than 10 years old".

But it still true....

Well, procedure is doing the same thing to the same object (or, better, "object").

If this...