Abu Dina (9/5/2013)

---

That's not what Koen meant but never mind it appears that you're choosing the name based on descending alphabetical order.

Try the below:

SELECT

A.[ITEMID]

, A.[LabelCode]

,(select top...

I can't say i completely understand this issue.

The while statement dont not stop because @i will never be equal to 1

So how come the following select return 1 ?

DECLARE @i...

You are right, to put a limitation is always good.

But by the way, tempdb doesn't have to be in the same drive as the operation system you can change the...

Tempdb suppose to be growing until there is no more space available.

So there are two options:

1. some definition are wrong - check if tempdb deifintions are set to autogrow.

2....