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 «««123

Using TOP To Rank Columns In a Table Expand / Collapse
Author
Message
Posted Thursday, October 27, 2011 7:44 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:11 AM
Points: 339, Visits: 973
My question is rather why do you want the top 10 columns rather then how
Post #1196921
Posted Wednesday, November 2, 2011 11:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 22, 2012 8:55 AM
Points: 124, Visits: 180
This just smacks of laziness on the developers part, to go to google and look up the API of their language's SQL Data Reader object. Pretty much every DB API allows you to select things based on column ordinal. C# will even allow you to get the name of the column back.

Time for clue-bat application




Post #1199456
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse