Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Case Statement

Status
Not open for further replies.
cschristian78

cschristian78

Technical User
Nov 3, 2004
23
0
0
US
Is it possible to have the follow?
(CASE when [AcctTIV] = 0 or case when [BLANLIMAMT] = 0
THEN 0
ELSE [StateTIV]/[AcctTIV]*[BLANLIMAMT]
END) AS ProRata

Or is this the only way?
(CASE when [AcctTIV] = 0 THEN
case when [BLANLIMAMT] = 0
THEN 0
ELSE [StateTIV]/[AcctTIV]*[BLANLIMAMT]
END
ELSE [StateTIV]/[AcctTIV]*[BLANLIMAMT]
END) AS ProRata

Thanks,
Scott
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Case sensitive request 1
Replies
3
Views
68
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
Create Function Within IF statement. 1
Replies
4
Views
190
mikrom
mikrom
ms901Boss
  • Locked
  • Question
Joining two select statement into one
Replies
1
Views
51
kray4660
kray4660
Bomac8
  • Locked
  • Question
Convert IIF with switch statement to Case
Replies
3
Views
70
dhookom
dhookom
ms901Boss
  • Locked
  • Question
Join two select statements and collecting data from both
Replies
13
Views
85
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top