Forum Replies Created

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

  • RE: Sales puzzle

    Pete Cox (8/15/2013)


    I would have thought the "order by" clause is absoutely necessary to guarantee a match to the sequence supplied as the answer. There is no implicit row order...

  • RE: Sales puzzle

    But why is the result (0, 1) eliminated?

    Does the engine first pick cp.pkey=0 from row 1 and 2 then looks at row 3-4 to check if up.pkey matches 1 and...

  • RE: Weird package creation error

    Registering the dll worked for me too! Tanks a lot!!!

    It also solved an issue I had with not being able to save maintenance plans.

  • RE: Normalizing-Denormalized Tables

    The function CombineGroupNames() can be optimzed using this concat-logic:

    DECLARE @Groups VarChar(MAX)

    SELECT @groups = coalesce(@groups +'|' + G.GroupName. G.GroupName)

    ...

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