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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-15 : 13:09:33
|
Mala writes "Hi,
I have got dynamic query built as below.
update t_inv_header1 set inv_para1="DIS",inv_per1=4,inv_para2="FGT",inv_para3="INS",
inv_per3=25,inv_para4="LOC",inv_per4=2,inv_para5="TOT",
inv_pamt1=160,
inv_pamt2=0,
inv_pamt3=0,
inv_pamt4=4000-160,
inv_pamt5=4000+4000-160-160+0+0,
where inv_no ="PI0100001" and inv_tcode="pi1"
My problem is values assinged to columns to be compued. But all these things are stored in varchar data type and not allowing me to do so.
eg. inv_pamt4 should be "3840" instead of 4000-160
I can't compute the values before assinging to variables b'coz
I will be stuffing/replaceing the numeric fields depednign other
variable.
Like if I got my column values like this "GRS-DIS+FGT+LOC"
if will go on replacing my values for the same as below.
set @v_pexpfld = replace(@v_pExpfld1,'GRS',@v_amt)
set @v_pexpfld=replace(@v_pexpfld,'DIS',@vpexpfld)
please help me how can I get the desired values.
Bye,
Mala" |
|
|
|
|
|
|
|
Dynamic Sql