Wrox Programmer Forums
|
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 16th, 2004, 03:23 PM
Registered User
 
Join Date: Nov 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to razmar78
Default need to resolve this.,.

error in this query, can someone help me:

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


 
Old November 23rd, 2004, 01:35 PM
Authorized User
 
Join Date: Aug 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to barmanvarn
Default

What error message are you getting?
 
Old November 23rd, 2004, 01:41 PM
Authorized User
 
Join Date: Aug 2004
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to barmanvarn
Default

Looks to me like you just have an extra ')' after you END command.

Try this:
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





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to resolve IDREF in XSL teahouse XSLT 3 September 15th, 2006 01:14 PM
cannot resolve symbol (struts) tomeksupergosc J2EE 2 November 23rd, 2004 01:19 PM
Need help to Resolve Error ORA-00933 sandeepshivathaya Oracle 0 August 19th, 2004 07:15 AM
Error-cannot resolve symbol Rusk JSP Basics 1 February 18th, 2004 09:20 AM
cannot resolve symbol problem ioda006 JSP Basics 2 July 28th, 2003 06:04 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.