Questions tagged [advanced-query-tool]

Questions related to the "Advanced Query Tool"

Homepage: http://querytool.com/

6 questions
1
vote
1 answer

uwp app AdvancedQuerySyntax for video file types

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…
Muhammad Touseef
  • 4,357
  • 4
  • 31
  • 75
0
votes
0 answers

What is the best way to reference a login file in an autorun SQL query via Task Scheduler? Multiple Database schemas and a yearly password reset

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…
0
votes
1 answer

Power BI Query: Need to Select Columns in Table 1 based on list of column names in Table 2

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…
0
votes
0 answers

Copying a table with employee info from test database to production in Advanced Query Tool

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…
user8506273
-1
votes
0 answers

Sort posts by category and date using php and custom query

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…
-1
votes
1 answer

Can we see IBM DB2 stored procedure content in AQT(Advanced Query Tool)?

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…
Sibeesh Venu
  • 18,755
  • 12
  • 103
  • 140