Find the row with the most data

  • Luis Chiriff

    Old Hand

    Points: 312

    Comments posted to this topic are about the item Find the row with the most data

  • r5d4

    SSCrazy

    Points: 2499

    Bit of feedback for you, the script doesnt work if you have a 'uniqueidentifier' column >

    Msg 206, Level 16, State 2, Line 1

    Operand type clash: int is incompatible with uniqueidentifier

    r

  • William McQuinn

    SSC Enthusiast

    Points: 179

    Doesn't seem to care for ntext either, even though I can see you're testing for ntext in your script.

    "Msg 206, Level 16, State 2, Line 2

    Operand type clash: int is incompatible with ntext"

  • Luis Chiriff

    Old Hand

    Points: 312

    Thanks for your feedback, I found the culprit and have made a change or two. It now works for ntext and uniqueidentifier. I've put the update on the original script, once it's updated you should see a v1.1 in the comment code at the type of the script, email me for an update if you wish, my email is in the comments.

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

You must be logged in to reply to this topic. Login to reply