Dynamic SQL Queries in Excel

preview_player
Показать описание
Dynamic SQL Queries
#sql #excel #powerquery #query #parameters #learnsql #learnexcel #dataliterate #tutorial #data #dataanalysis #datascience #bi
  1. Data-Literate
  2. #sql
  3. #excel
  4. #dataliterate
  5. #datascience
  6. #dataanalytics
Рекомендации по теме
Dynamic SQL Queries 0:10:11

Dynamic SQL Queries in Excel

Dynamic SQL queries 0:04:23

Dynamic SQL queries with Power Query (Can be used for Excel and Power BI) - WHERE Conditions

Run an SQL 0:03:51

Run an SQL Query With Dynamic Parameter from Excel

Querying SQL Server 0:09:27

Querying SQL Server Data in Excel with a Parameter

Excel: Split & 0:00:43

Excel: Split & Group Data with Power Query

how to pass 0:04:49

how to pass dynamic parameters to SQL query from Excel to import the data in it.

Create Dynamic SQL 0:00:53

Create Dynamic SQL Queries #sqlserver #coding

Passing Parameter Values 0:21:47

Passing Parameter Values from Excel to SQL Server

Efficiently Using Excel 0:01:53

Efficiently Using Excel to Track Orders: Dynamic SQL Queries with Customer Names

Power Query parameters 0:12:29

Power Query parameters | Add flexibility to your queries | Excel Off The Grid

Run SQL queries 0:07:13

Run SQL queries in EXCEL (just like a normal Excel formula 🤯)

Power Query Replaces 0:01:00

Power Query Replaces XLOOKUP?!

Function executing SQL 0:04:15

Function executing SQL to create dynamic report in Excel and Add-in A-Tools very fast

Dynamic SQL 0:13:50

Dynamic SQL

Insane Power Query 0:00:57

Insane Power Query Trick 🤯 | Refer to an Intermediate Step from another Query

Excel Power Query 0:20:25

Excel Power Query Parameter from a Cell Value (using a Named Range or a Table)

Power Query Parameters 0:12:14

Power Query Parameters - Dynamically Change the Output of Your Queries Depending on Their Value

SQL dynamic queries 0:17:55

SQL dynamic queries for dynamic excel

Power Query - 0:13:38

Power Query - Faster & Easier Parameters

Filter by Parameter 0:10:50

Filter by Parameter and Dynamic Drop-Downs with Power Query | Everyday Office

Create SQL Statements 0:00:15

Create SQL Statements in #excel #googlesheets #shorts

Run SQL Query 0:05:38

Run SQL Query with Date Range filter in Excel

Build Dynamic SQL 0:11:56

Build Dynamic SQL in SQL Server

Don't Use Basic 0:01:03

Don't Use Basic Vlookup in Excel‼️Instead Use Advanced Vlookup #excel #exceltips #short #excelt...

Комментарии
Автор

Bro this is awesome thanks so much for this video

ericg
Автор

I genuinely realized this is probably the best and easiest video for this. So many other videos are using vba and all these other things

ericg
Автор

WoW! Excellent Video. Thanks for very very useful tips. This will help me to create a dynamic sql query using power query.

venkyr
Автор

Thank you for this video. This is very helpful for me.

gaybarile
Автор

Thanks - First easy and effective solution that I've come across

jacoh
Автор

Really useful, thanks. This is so much easier than using VB.

peterd
Автор

Nice video...Just what I needed. You deserve more likes.

ForUBorn
Автор

Very useful video, and thank you for it. However, it doesn't work for oracle sql, how can i fix this please? it seems it is a format issue..

EPaulofficiel
Автор

Very informative. Is there a way to add say 2 more values/parameters but those can be optional.

BrijeshYadav-vlbj
Автор

Thanks! Was just what I was looking for!

I was wondering about another type of parameter. I am running a SQL behind the scenes in Excel and am trying to pull values that are for example IN (1, 4) is there a way to dynamically change the values within the parentheses based on some table? For instance have checkboxes that when clicked on and off may show IN (1, 2, 5) instead.

twmagaluk
Автор

Thanks for the video. I'm stiull getting conversion errors. Can we Format the date parameter to YYYY-MM-DD so SQL can understand it?

edgarhakobyan
Автор

Nice video...Just what I needed. You deserve more likes.

Greenock