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

It is the ^3 you have to use the POWER function instead.

/J\

Comment on Re: (OT) MS-SQL error: 'Invalid operator for data type' Select or Download Code

Replies are listed 'Best First'.
Re^2: (OT) MS-SQL error: 'Invalid operator for data type' by Anonymous Monk on Oct 27, 2004 at 14:44 UTC
I am a bit confused about how I would implement POWER(). Time for me to head to the microsoft page I think.	[reply]
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]