Re^2: (OT) MS-SQL error: 'Invalid operator for data type'

I am a bit confused about how I would implement POWER(). Time for me to head to the microsoft page I think.

Comment on Re^2: (OT) MS-SQL error: 'Invalid operator for data type'

Replies are listed 'Best First'.
Re^3: (OT) MS-SQL error: 'Invalid operator for data type' by edan (Curate) on Oct 27, 2004 at 15:14 UTC
Assuming I counted parens correctly, then: `(1-1/(9((SUM(C.Person_count)+1)))+1.96/(3sqrt((SUM(C.Person_count)+1 +))))^3` [download] becomes: `POWER((1-1/(9((SUM(C.Person_count)+1)))+1.96/(3sqrt((SUM(C.Person_co +unt)+1)))),3)` [download] HTH -- edan	[reply] [d/l] [select]