Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Find the row with the most data Expand / Collapse
Author
Message
Posted Friday, July 11, 2008 8:51 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 11:48 PM
Points: 15, Visits: 61
Comments posted to this topic are about the item Find the row with the most data
Post #532933
Posted Friday, July 25, 2008 5:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 9:10 AM
Points: 267, Visits: 686
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
Posted Friday, July 25, 2008 8:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 12:08 PM
Points: 69, Visits: 133
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
Posted Monday, July 28, 2008 5:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 11:48 PM
Points: 15, Visits: 61
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 »

Add to briefcase

Permissions Expand / Collapse