We're exporting bacpacs from Azure SQL Databases to Storage Accounts via New-AzSqlDatabaseExport. Docs for that command: https://learn.microsoft.com/en-us/powershell/module/az.sql/new-azsqldatabaseexport What's the minimum role required for a SQL user to do this? We're trying to maintain the least privileges rule. Having a single…
I have the following table of inventory stock symbols and want to fetch the highest alphanumeric value which is AR-JS-20. When I say "highest" I mean that the letter order is sorted first and then numbers are factored in, so…
I have 2 tables orders order_id 1 2 3 orders_details order_id sku ordered received 1 abc 10 10 1 xyz 10 10 2 abc 10 6 2 xyz 10 0 3 abc 10 0 4 xyz 10 0 I would…
I would like to ask you for advice as I don't know which method to use: For example with this query in Mysql i have this table: user_Id name age photo 1 Zack 23 Blob[2.1] 1 Zack 23 Blob[3.3] 1…
I am trying to get all customers with their latest payment transaction, including customers without any transaction: SELECT c.customer_id, c.phone_number, c.email , p.transaction_no, p.amount, p.transaciton_datetime FROM tbl_customers c LEFT JOIN ( SELECT customer_id, transaction_no, amount, transaciton_datetime FROM tbl_payment_transactions ORDER BY…
Fiddle i created: http://sqlfiddle.com/#!9/e22eb6/2 Data for each tables I tried below query but its only showing result which particular user has authority/permission assigned on him, i want all records(permission avaialble) in authority_master table along with matched one. SELECT U.first_name, UR.authority_id…
i'm quite new to postgressql, so i have a table called public.dim_products with a column called weight_kg what i would like to do is given some weight in the weight ranges below to set up a new column called weight_class…
I have the following table: car score description Opel 30 43 Volvo 500 434 Kia 50 3 Toyota 4 4 Mazda 5000 4 How I can delete all the content of table column score without changing the table structure? Expected…
I have data with start date and end date (Say 20th Feb 2018 to 20th Feb 2020), I want to find out the total days in every year inside this range. For example: 2018 - x days , 2019 -…
I am using DuckDB and want to process some time-series data that has the following format: ┌─────────────────────┬─────────┬─────────┬─────────┬─────────┬────────┬────────────┐ │ Timestamps │ Open │ High │ Low │ Close │ Volume │ CustomDate │ │ timestamp │ double │ double │ double…