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 |
|
hubschrauber
Starting Member
16 Posts |
 Posted - 2005-11-09 : 06:22:14
|
| I get a an error 156: incorrect syntax near '=', the if function is not working within the stored procedure, i hope some can help me...UPDATE f_tbl_openstaande_210_elevering_nb SET f_tbl_openstaande_210_elevering_nb.categorie1 = If([ouderdom]='1',[categorie1]+1,[categorie1])FROM f_tbl_openstaande_210_elevering_nb INNER JOIN r_tbl_el_210_open ON f_tbl_openstaande_210_elevering_nb.netbeheerder = r_tbl_el_210_open.netbeheerder WHERE (((r_tbl_el_210_open.bakje)='ECH_1' Or (r_tbl_el_210_open.bakje)='ECH_3')); |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2005-11-09 : 06:28:17
|
| if can not be used in the queries use case for the same.. Try out this.. PDATE f_tbl_openstaande_210_elevering_nb SET f_tbl_openstaande_210_elevering_nb.categorie1 = Case When [ouderdom]='1' Then [categorie1]+1 Else [categorie1]) End FROM f_tbl_openstaande_210_elevering_nb INNER JOIN r_tbl_el_210_open ON f_tbl_openstaande_210_elevering_nb.netbeheerder = r_tbl_el_210_open.netbeheerder WHERE (((r_tbl_el_210_open.bakje)='ECH_1' Or (r_tbl_el_210_open.bakje)='ECH_3'));Hope this works for you..Complicated things can be done by simple thinking |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-09 : 06:32:23
|
| ReplaceIf([ouderdom]='1',[categorie1]+1,[categorie1])byCase When [ouderdom]='1' Then [categorie1]+1 Else [categorie1] End MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
if function in stored procedure!!!