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 |
|
annamaria
Starting Member
30 Posts |
 Posted - 2007-04-15 : 06:44:19
|
I'M AN ABSOLUTE BEGINNER.WILL ANYONE PLEASE HELP ME DOING A QUERY?MY TABLE IS COMPOSED OF THE FOLLOWING FIELDS: C, I, F, T, PT AND OTHERSI WANT TO SELECT SOME FIELDS AND I WANT QMF TO CREATE A NEW COLUMN,NAMED "RATEO" BY PERFORMING THE FOLLOWING OPERATIONS:IF C = "801" AND PT = "S", THEN: T/2 * (CHOSEN DATE - I)/F - I.IF C = "877" THEN: T/360 * (CHOSEN DATE - I)AND SO ONCHOSEN DATE IS A DATE THAT I WANT TO DEFINE WHENEVER I RUN THE QUERY.PLEASE ANSWER TO ME AS SOON AS POSSIBLE.I LOVE BEING PART OF THIS COMMUNITY. THANK YOU IN ADVANCE.ANNA - VERONA (ITALY)  |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-15 : 06:52:02
|
[code]DECLARE @CHOSEN_DATE DATETIMESELECT @CHOSEN_DATE = <some value>SELECT RATEO = CASE WHEN C = '801' AND PT = 'S' THEN T/2 * (@CHOSEN DATE - I)/F - I WHEN C = '877' THEN T/360 * (@CHOSEN DATE - I) ENDFROM MYTABLE[/code]
KH |
 |
|
|
|
|
|
IF CLAUSE