Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How can I execute an Immediate IF in a SQL statement? (t-SQL)

Posted on 2007-11-14
3
Medium Priority
?
861 Views
Last Modified: 2010-04-21
I have a file, it has (5) check amount fields. I need to update the record with a field that will give the valid number of checks in the record.  The possibilities are; 2 checks, or 5 checks.  I can assume that if "check amount 3" has a zero value, expressed as '000.00' then it is a (2) check record, and if it is not '000.00' then it is a (5) check record.

I need to do this query along with several other updates at the same time.  Is there a way to do something along the lines of a (iif check_number_3 = '000.00,'2','5')? inside an update statement?
0
Comment
Question by:TommyMac501
[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
3 Comments
 
LVL 23

Assisted Solution

by:Snarf0001
Snarf0001 earned 200 total points
ID: 20284993
update <<tablename>> set <<columnname>> = case when check_number_3 = '000.00' then 2 else 5 end
0
 
LVL 70

Accepted Solution

by:
Scott Pletcher earned 300 total points
ID: 20285083
Best is to use a computed column, which SQL will not store but will automatically (re)compute every time you need to use the value.  For example:

ALTER TABLE tableName
ADD CheckCount AS CASE WHEN [Check Amount 3] = 000.00 THEN 5 ELSE 2 END

From then on, you can use CheckCount just like any regular column.
0
 

Author Closing Comment

by:TommyMac501
ID: 31409249
Thank you both, this solution worked great.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

598 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