[dba-SQLServer] Crosstabs - Pivots

Stuart McLachlan stuart at lexacorp.com.pg
Thu Jul 15 03:40:36 CDT 2004


On 15 Jul 2004 at 16:52, Haslett, Andrew wrote:

> Greetings all.  The infamous crosstab question!
> 
> A few samples on the net show you how to do it, but they all require a
> numeric value to pivot on so you can use an aggregate function.
> 

Must use an aggregate function, but it doesn't have to be numeric,  just use  
Min().

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.






More information about the dba-SQLServer mailing list