powershell tips, ccna tips, tech videos, learn tech
Here is the question: How do you round milliseconds to seconds using SQL? Here is the CODE “ CONVERT(VARCHAR,DATEADD(ms, ROUND(duration$ms, -3), 0),108) AS Duration” As you can see we use CONVERT, VARCHAR, DATEADD, ROUND, to do this and you can change the duration$ms column to your open so it changes 1350 to 00:00:01. Please let me [...]
Okay I used this SQL Script to join two tables but a certain amount of rows has to be joined with another table, here is how i did it with a join and union operation
UPDATE tbl_grocery_inventory set col_curry_qty = col_curry_qty – 1 WHERE col_ID in (select col_id from tbl_fruit where col_id=2)
This is a SQL SELECT Statement that is joining 3 tables. Please tell me what do you think to make it quicker and faster. Let me know what you think about this confusing subject of SQL joins! Thanks Scott @ http://scottalvarino.com