|
Subject:
|
query...!!
|
|
Posted By:
|
razmar78
|
Post Date:
|
11/16/2004 2:54:07 PM
|
Getting error with this query.. please help
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
WHERE solicitante_dir_ciudad = CASE WHEN @Ciudad='TODOS' THEN solicitante_dir_ciudad ELSE @Ciudad END)
GROUP BY solicitante_dir_ciudad
ORDER BY solicitante_dir_ciudad
|
|
Reply By:
|
stu9820
|
Reply Date:
|
11/17/2004 8:09:15 AM
|
What's the error?
|
|
