• benkoskysa (3/3/2010)


    With the given SQL, @temp is an empty table, therefore count(1) will always return 0.

    Not if you replace DATALENGTH with LEN in this query 😉 I have to try everything myself, take NOBODY's word for anything... yes, I am a trusting soul...

    --Mileage may vary--

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems