CASE sintaxis error in SELECT
In the middle of a large storage procedure I have a working SELECT 01 (see below) which at a couple of points uses CASE statement.I need to expand the most inner CASE to get SQL Server check for several values instead of one. Currently CASE I am talking about looks like (it is in the middle of...
View Answer
| Jul 18 2008 7:46 PM GMT
| asked by
Jzurbo77
CASE statement, SELECT, SQL Server 2005
Order by using case statement SRS 2000
I am using a case statement to order data on a SRS report, when the statement is ran, it returns the correct order, but when I save the RDL and preview it, it returns to ascending order. How do I correct this?
Answer Question
| Jun 11 2008 6:38 PM GMT
| asked by
Wi sundevil
CASE statement, SRS 2000, SQL Server Reporting Services
Using Case Statement Inside SQL Join
Hi,I am trying to convert dynamic sql into static sql due to permission issue, I faced a challange when i am trying to convert this part of code given below-- join to ADDR_DETAIL SET @join_sql = 'inner join ADDR_DETAIL on ADDR_DETAIL.GRP_CONTACT_ID = pm.GRP_CONTACT_ID AND ' IF (@ChannelEntity...
View Answer
| Mar 13 2008 11:08 AM GMT
| asked by
Bmdayal
SQL, T-SQL, JOIN
ms sql case statement
I have written a case statement in MS SQL that is returning a single phone number for a single id. This is valid as the database contains multiple phone numbers attached to the same id number, with differentiation based on phone type. Once I have found the prefered phone number, I do not want to...
View Answer
| Mar 6 2008 7:08 PM GMT
| asked by
Espqueen
SQL, CASE statement
How to use subselect in a case statement
Getting error... "Token EXISTS was not valid...." on case statement...,case when g.GFGSTS = '2' and not exists (select a.GFTSEQ from GFTP010 a where a.GFCSQ# = g.GFCSQ# and a.GFGSTS = '3' ) then count(*) end as Void#
View Answer
| Jan 17 2008 3:11 PM GMT
| asked by
Qpgmr
SQL, SQL Subselect, CASE statement
