Find the row with the most data

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Luis Chiriff » Find the row with the most data

Find the row with the most data

Rate Topic

Display Mode

Topic Options

Author

Message

Luis Chiriff

Posted Friday, July 11, 2008 8:51 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, February 28, 2011 7:14 PM
Points: 14, Visits: 31

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

Post #532933

r5d4

Posted Friday, July 25, 2008 5:16 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, February 11, 2013 7:58 AM
Points: 267, Visits: 662

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

Post #540812

William McQuinn

Posted Friday, July 25, 2008 8:39 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:57 PM
Points: 69, Visits: 121

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"

Post #540970

Luis Chiriff

Posted Monday, July 28, 2008 5:41 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, February 28, 2011 7:14 PM
Points: 14, Visits: 31

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.

Post #541786

« Prev Topic | Next Topic »

Permissions