Recent IT Questions

1 - 5 of 5
<<PREVIOUS 1 NEXT>>

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


1 - 5 of 5
<<PREVIOUS 1 NEXT>>