Need help

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  June 20, 2011 at 4:32 am

  #104074

  ;WITH xmlnamespaces (default 'http://schema.cvent.com/surveys/XMLSchema.xsd')

  SELECT count(*) FROM dbo.EVENT_ANSWER

  WHERE answer_detail.value('fn:count(/ANSWERS/Answer/@answ_text)', 'int')

  getting below error

  Msg 4145, Level 15, State 1, Line 3

  An expression of non-boolean type specified in a context where a condition is expected, near ')'.

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  June 20, 2011 at 4:41 am

  #1341034

  Bhuvnesh

  Looks like you've left a "=" or a "LIKE" or some such out of your WHERE clause.

  John