problems with query | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

problems with query

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
This is a duplicate post… seehttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6188 Cheers
Twan
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 />
Triplicate, I’ve locked spanish one.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
I would but am not a moderator of this area… <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /><br /><br />Twan
]]>