Only problem is in this query it just somehow doesn't calculate values (or calculates but update is not doing update towards database ).i have taken the values from temp database and used exactly same "formula" to calculate fields and i got result as it should be but in sql query it just doesn't update anything to database. I have checked that values are inserted correctly to temporary database. I have chain of update commands for that temporary table but they all are working correctly. What do you mean with following update sequence?Are there more updates than you have posted? Is that problem in following update sequence? No, you're never too old to Yak'n'Roll if you're too young to die. You are doing the update on a temp table - you know that? Hi,i got table where i have this field PERCENT numeric (10,2) nullUPDATE VSK5 SETPERCENT = (select isnull((abs(VSK5.purchases) - abs(VSK5.purchases2)) * -1 / (VSK5.purchases3- VSK5.purchases4) * 100.00 ,0))FROM #TESTBASE VSK5but the value doesnt store to database? what i am doing wrong? We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.
0 Comments
Leave a Reply. |