On 28 Nov 2006 at 22:06, Raymond O'Donnell wrote: > Don't you need to declare pCentreGroupPolicyID first? -
Oops, my mistake - you don't of course, because it's an INOUT parameter. --Ray. ---------------------------------------------------------------------- Raymond O'Donnell Director of Music, Galway Cathedral, Galway, Ireland [EMAIL PROTECTED] ---------------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match