Solved

need select with case/exists logic

Posted on 2007-04-09
1
183 Views
Last Modified: 2010-03-19
I need a case or if exists for a select statement:

I have a table with district, districtmanager,division, divisionmanager, region, regionmanager. i'd like to select the all the division, divisionmanager that are not null and for those that are null, replace wtih the region, regionmanager for all non-null districts
0
Comment
Question by:acdagirl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 18875966
not 100% sure, but I assume you are looking for the COALESCE() function:

SELECT COALESCE ( division, region ) , COALESCE ( divisionmanager , regionmanager )
FROM yourtable

0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PERFORMANCE OF SQL QUERY 13 85
SQL Agent Timeout 5 74
Isolation level in SQL server 3 58
Usage Scenarios for Extended Events - Tracking Recompilations 1 50
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question