Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
h2sut
Starting Member
40 Posts |
 Posted - 2010-03-19 : 19:27:00
|
| I just started sql server and not sure how to code this in sql using case statementBN_401K_ELIG=Y and (BN_DC_401K_EE_CURRENT / PRO_RATE_A_SAL >0 and < .0400 and PRO_RATE_A_SAL < 400,000) or (BN_DC_ROTH_EE_CURRENT / PRO_RATE_A_SAL > 0 AND < .0400 and PRO_RATE_A_SAL < 400,000) then 'Yes' else 'no' |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Query Help