in my uwp app I am getting video files from KnownFolder.VideoLibrary and I am using QueryOptions to get them, so taking advantage of that I am trying to use AdvancedQuerySyntax so that I only get video files, but I am actually getting subtitle files…
I'm admittedly fairly new at SQL and learning organically through project requests and reviewing my predecessor's previous processes. One issue I am encountering is the once-per-year password reset rules my company has in place. All current queries…
I have merged data from two tables (Table#1 and Table #2) into single master data table (Table #3) using power query.
Table #4 and Table #5 contain list of column names from Table #1 and Table #2, respectively, that I want to include in Table #3. I…
I am looking to copy a table with employee information from my company's test database, to the production database in Advanced Query Tool. The first thing i did was to export the table data in a csv file, then trying to import the same data into the…
I am using Elementor Pro and Advanced Queries and also ACF for custom date. I have 2 types of posts that are events - event 1 and event 2.
I have an event calendar on the first page showcasing the upcoming event by date (ASC) using custom php and…
I am not an expert in IBM Host tools as I am from development distributed side. Is there anyway that we can see the source code of IBM DB2 stored procedure in AQT tool. I know we can use any emulator tools like Attachmate Extra! X-treme, but the…