UPDATE `target_table` SET `dummy_price` = round(`float_price`, 2) WHERE round( `float_price` , 2 ) <> `dummy_price` Well, after that i got all i need. All rounded data from float_price is eq to dummy_price, i think its enough. I think i'll help someone.

Sep 22, 2018 · You should try this one: SELECT * FROM ( SELECT tb1.*, tb3.id AS hasDiscount, tb2.type, tb2.amount, CASE WHEN tb3.id IS NULL THEN tb1.price WHEN tb2.type = 1 THEN tb1.price -(tb1.price * tb2.amount) / 100 ELSE tb1.price - tb2.amount END AS FinalPrice FROM products tb1 LEFT JOIN discounted_products tb2 ON tb1.id = tb2.product_id AND tb2.status = …

Stack Exchange Network. Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Aug 31, 2017 · From the Microsoft documentation concerning T-SQL / SQL Server: Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For ex...

Sep 6, 2016 · Stack Exchange Network. Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Jul 1, 2012 · The suggestions for the more general problem do not work for IDs that have no changes. Could be fixed with adding dummy entries to the original set (something like dbo.Taco UNION ALL SELECT DISTINCT Taco_ID, NULL AS Taco_value, '19000101' AS Taco_date). –

Aug 19, 2018 · Many-to-many tables are typically handled with a "bridge table." This is really just another name for a many-to-many table like you'd use in a transactional database: one column for an FK to the first table, one column for an FK to the second table, and probably a column or two for housekeeping fields.

May 17, 2016 · Stack Exchange Network. Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Apr 27, 2013 · Consider this select statement: SELECT *, 1 AS query_id FROM players WHERE username='foobar'; It returns the column query_id with value 1 along with a player's other columns.

If you succeed, you have fixed the problem and have a functional database. If not, you can try to create an empty database with the same structure and pump the data to it . One of the reasons why backup or restore can fail is if some broken database triggers exist, and prevent connection to the database.