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

Adding a column header on count function Expand / Collapse
Author
Message
Posted Wednesday, April 30, 2008 1:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 19, 2009 2:06 PM
Points: 24, Visits: 100
Hi All:

Is it possible to add a column header to a count?

i.e. select count(*) from foo as employeeCnt

Thanks,

Bill
Post #493217
Posted Wednesday, April 30, 2008 1:11 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:23 PM
Points: 2,706, Visits: 3,782
You're close ...

select count(*) as employeeCnt from foo



______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg
Post #493219
Posted Wednesday, April 30, 2008 1:38 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 19, 2009 2:06 PM
Points: 24, Visits: 100
Thanks Jason, that worked

Bill
Post #493241
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse