Find the row with the most data

• Luis Chiriff

  Old Hand

  Points: 312

  More actions

  July 11, 2008 at 8:51 pm

  #189397

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

• r5d4

  SSCrazy

  Points: 2523

  More actions

  July 25, 2008 at 5:16 am

  #848303

  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 Veteran

  Points: 202

  More actions

  July 25, 2008 at 8:39 am

  #848434

  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

  More actions

  July 28, 2008 at 5:41 am

  #849092

  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.