Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: SELECT ONLY ONE ROW FROM MANY

    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...

  • RE: SET ROWCOUNT and table variable

    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...

  • RE: Handling Tempdb space full situtation?

    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...

  • RE: Handling Tempdb space full situtation?

    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....

Viewing 4 posts - 1 through 4 (of 4 total)