Home Discussion Discuss: MySQL Case

  • Mysql CASE statementSatya May 21, 2012 at 10:24 AM

    Hi, I have a problem while using MYSQL case Statement In SSRS 2008 R2. My scenario is: I am passing hardcoded values in parameter dropdown (County, State). And i am using another parameter depending on If i select the "county" in by dropdown, I need get all county values in dropdown or if select state i need to get all state values in my dropdown. What i am writing in my code select case when parameter.geolevl.value = "County" then "select distinct county_name from county" when parameter.geolevl.value = "State" then "select distinct state from county" is this code will work in SSRS 2008 R2 Please help me with this Issue

Post your Comment



Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Related Articles
RUP Questions

Business case
Business case  hii, For which phase of RUP the "business case" for the project established ?   hello, Inception phase of RUP the "business case" for the project established 

Java Beginners

test case
test case  Hi Can you explain me how to write test case in java. regards kennedy 

Java Beginners

Matching Case
Matching Case  Hi, i want some code for matching case from an text file. i.e if i give an query called Java from the user,i need to get an output searching the text file all the names in that without case sensitive 

Java Beginners

switch case
switch case  program to input 2 numbers and a choice.Using switch case we need to perform all the mathematical operation.Print a suitable error message if the choice is wrong 

Java Beginners

switch case
switch case  program to input 2 numbers and a choice.Using switch case we need to perform all the mathematical operation.Print a suitable error message if the choice is wrong 

Java Beginners

case study
case study  Chocolate Manufacturer Case Study CDA Company is in the business of manufacturing chocolates. The company delivers various chocolate products like- chocolate bars ,chocolate powder ,chocolate gift box and chocolate 

Mobile Applications Questions

uisearchbar case sensitive
uisearchbar case sensitive  uisearchbar case sensitive 

UML Questions

UML CASE Tools
UML CASE Tools  What requirements should a UML CASE tool meet 

Java Beginners

switch case instead of if else
switch case instead of if else  How to write code in switch case instead of if else in Java 

XML Questions

XML case-sensitive
XML case-sensitive  Hi please anyone tell me Which parts of an XML document are case-sensitive? Thanks 

XML Questions

XML is case-sensitive
XML is case-sensitive  hello, can some body can tell me that Is XML case-sensitive or not ?   HELLO MAN, YEAH, XML IS A CASE SENSITIVE LANGUAGE 

Java Beginners

Java is case sensitive
Java is case sensitive  hello, Why Java is case sensitive?   hii, Java is Platform Independent Language, so its used widely in very big... that huge no of variables,Java is Case Sensitive 

SQL Question

CASE IN UPDATE IN MYSQL
CASE IN UPDATE IN MYSQL  I WANT THE SYNTAX FOR USING CASE IN UPDATE STMT IN MYSQL.ANY ONE PLEASE HELP.   Hi Friend, Visit here Thanks 

MySQL

Mysql Lower Case
Mysql Lower Case       Mysql Lower Case is used to convert the Upper Case letter to the Lower Case... 'Mysql Lower Case. To understand this example we create a table 'employee1 

SQL Tutorial

Mysql Lower Case
Mysql Lower Case       Mysql Lower Case is used to convert the Upper Case letter to the Lower Case. Understand With Example The section of this Tutorial illustrate 

SQL Question

using case in update statement
using case in update statement  i want to use case in update clause. i have used case in select stmt referring answer in this site. but the same syntax is not working for update stmt.my problem is update emp set case deptno 

Java Beginners

Switch case + condition??
Switch case + condition??  I try to use a switch case with condition...(down.getSelectedIndex()) { case 0: Tambo(); if( label.equals...")){ search();} break; case 1: Nyqeni 

JUNIT Questions

test case - JUNIT
test case  Hi i am doing project on online reservation i want to know how to write the test case template for this online reservation 

UML Questions

UML case tools
UML case tools  Research available UML case tools. Test one of the UML case tools that you researched. Select one of the free tools, or one that is currently used in your workplace. Install the tool and try to input at least 

Java Beginners

indexof case insensitive java
indexof case insensitive java  Hi, I have to use the indexOf function on String class in Java. I am looking for indexof case insensitive java example. Share the code with me. Thanks   Hi, You can convert both 

Java Beginners

using switch case
operation depending upon the users choice using switch case 1)print square root...){ case 1: System.out.println("Square Root of "+num+" is: "+(Math.sqrt(num))); break; case 2: System.out.println 

Java Beginners

Change case in C language
Change case in C language  I want to right in .dat file through... (B)in second formate i always wants to write data in upper case for example... how is it possible to change case before writing in .dat file I tried through 

Java Beginners

Switch case in Jsp page
Switch case in Jsp page  <table> <tr><td>Enter Distance :</td> <td><input type="text" name="dis"/></td>... using switch case in jsp page 

Java Beginners

caller tunes case study
caller tunes case study  Caller Tune Case Study ABC Corp is a new... 1) For Case 1 :the charge is 84 rs per month 2) For Case 2: the charge is 118 rs per month 3) For Case 3: the charge is 217 rs per month When the customer 

Hibernate Questions

Hibernate case sensitive comparison.
Hibernate case sensitive comparison.  How to check for case sensitive in Hibernate criteria?   package net.roseindia.main; import java.util.*; import net.roseindia.table.Employee; import 

Maven Questions

Mockstrutstest case in Weblogic - Maven
Mockstrutstest case in Weblogic  Hello All, I'm testing junits with Maven 2 using MockStrutsTestCase. The web.xml file is not loading even after I set the servlet config file with setServletConfigFile. I get the follwoing 

Java Beginners

broad band case study
broad band case study  Broadband Case Study LKV Company is a new firm which won a Pan India broadband spectrum in the recently concluded broadband... validity date, usage, validity expiry (in case of prepaid customer 

WebSevices Questions

Case study of xyz.com
Case study of xyz.com  Scenario: Online Shopping Portal XYZ.com wants to create an online shopping portal for managing its registered customers... the client side validations using JavaScript. Create the tables using MySQL. Implement 

Java Beginners

dth case study
dth case study  DTH Case Study BNM Corp is a new player in the DTH (Direct to Home) satellite TV business in India. It has a sister concern BNV Corp which is a broadcaster and owns few channels. BNM corp entered into the DTH 

Java Beginners

logistic case study
logistic case study  Logistics Case ABC is an upcoming logistics company .The company offers air cargo services from Bangalore Airport office to 10 international locations and vice versa. They can handle cargo up to 40 kilos 

DMCA.com