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

preview_player
Показать описание
This video training about how to create dynamic report by on formula with one function BS_SQL only. Report very fast by executing T-SQL language on Excel. There is no superfluous formula, No need filter to hide. The formula is sufficient to display data, which is self-stretching when conditions change on sheet.
  1. Nguyen Duy Tuan - Bluesofts
  2. excel
  3. vba
  4. addin
  5. a-tools
  6. atools
Рекомендации по теме
Advanced SQL Tutorial 0:06:15

Advanced SQL Tutorial | Stored Procedures + Use Cases

SQL Window Functions 0:10:13

SQL Window Functions in 10 Minutes

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

79 What are 0:11:57

79 What are user defined functions in sql server

Stored Procedures vs 0:01:00

Stored Procedures vs functions - practical demo #shorts #sql #sqlqueries #coding #sqlinterview

Data Analysis SQL 0:01:00

Data Analysis SQL Interview Questions | Running SUM | Who Hit the Sales Target First

SQL Tutorial - 0:08:27

SQL Tutorial - Using functions

SQL Window Functions 0:07:52

SQL Window Functions | Clearly Explained | PARTITION BY, ORDER BY, ROW_NUMBER, RANK, DENSE_RANK

dhy-dbmy-wdg 2:10:46

dhy-dbmy-wdg

SQL indexing best 0:04:08

SQL indexing best practices | How to make your database FASTER!

Function that parses 0:00:58

Function that parses the string and return number in PL/SQL | Functions in Plsql | TechnonTechTV

SQL Stored Procedures 0:06:16

SQL Stored Procedures | CREATE PROCEDURE Statement| SQL Server Tutorial for Beginners

How To Create 0:12:29

How To Create Multi Statement Table Valued Functions | Microsoft SQL Server 2017 for Everyone

From Slow to 0:00:58

From Slow to Fast: Optimize Your SQL Queries Efficiently | Explain Plan

Run SQL queries 0:07:13

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

PL/SQL tutorial 39: 0:06:15

PL/SQL tutorial 39: How To Create PL/SQL Functions in Oracle Database By Manish Sharma

SQL Server DBA 0:10:21

SQL Server DBA Tutorial 58- How to Create Database Role in SQL Server

How to create 0:10:36

How to create Azure Function to interact with SQL Database

Scalar user defined 0:19:07

Scalar user defined functions in sql server Part 30

SQL Window Function 0:24:55

SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial

SQL Tutorial for 0:44:57

SQL Tutorial for Beginners

Learn Basic SQL 0:17:40

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

Functions Or Stored 0:08:10

Functions Or Stored Procedures in Database #Postgresql #PL/SQL

How to write 0:21:01

How to write SQL Functions in PostgreSQL

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

Atools is the best add-in for excel in Vietnam until now (in my viewpoint). Your pronunciation is not good, however, I believe it will be better soon (y)
Can you explain to me why we have to use " &Left(B3&D3, 0)?

datdat
visit shbcf.ru