SQL Server Performance

problems with query

Discussion in 'SQL Server Reporting Services' started by razmar, Nov 15, 2004.

  1. razmar New Member

    I am getting error bc30201 with this query:

    ="SELECT ISNULL(solicitante_dir_ciudad,'DESCONOCIDO'),COUNT(*) AS [Cantidad de Solicitantes]," &

    "COUNT(*) * 100.00 /(SELECT COUNT(*) FROM dat_datos_importados) AS [Por Ciento%] FROM dat_datos_importados" &

    IIF(Parameters!Ciudad.Value=' TODOS',"","WHERE (solicitante_dir_ciudad=" Parameters!Ciudad.Value & ") ") &

    " GROUP BY solicitante_dir_ciudad ORDER BY solicitante_dir_ciudad"

    please help
  2. Twan New Member

  3. FrankKalis Moderator

    Shouldn't you lock the thread, Twan? [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />-----------------------<br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />-----------------------<br />
  4. Luis Martin Moderator

    Triplicate, I've locked spanish one.

    Luis Martin

    All postings are provided “AS IS” with no warranties for accuracy.

  5. Twan New Member

    I would but am not a moderator of this area... <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br /><br />Twan

Share This Page