sql server - Converting MS SQL float row, rounding to 2 decimals, may we use MS Access for rounding? -


we have legacy financial application running no longer supported important us.

we have overwritten approximateley 250 rows manually in 2 columns "price" , "selling_price" , application crashes @ point calculates reports.

i believe our mistake not round 2 decimals before writing valuies.

my plan use ms access , update values in row.

old values like:

 24.48   6.98 100.10

but wrote values 

 20.19802  99.42882 108.1302

and believe lets crash when sums on them

could idea make ms access query , overwrite rounded values? or on ms sql tabel level more accurate use sql query modifies using t-sql functions? idea overwrite round(108.1302, 2)

someone lot of ms sql experience?

this row of type float, lenght 53, scale 0, allow null = no.

i not quite sure happens internally , application expecting, because float stored in binary, see cannot same internally stored.

in ms access, connect tables using odbc, same function round(108.1302, 2), lead same result?

how should overwritten, seems safest experience?

if you're using access front end sql server end 2 approaches should same.

you check before updating running conversion select statement in access , running sql pass through

select columna, round(columna, 2) roundeda tablename columna <> round(columna, 2)  group  columna order  columna

and checking match


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more