How to efficiently copy - paste a code
1.add this extention to your web browser (Blackbox - Select. Copy. Paste & Search) https://chrome.google.com/webstore/detail/blackbox-sel...
top of page
07479 744442
Home: SQL
Search
Marek Vavrovic
- Apr 22, 2022
- 3 min
Data Warehouse Dimension Loading Using Lookup and Conditional Split Transformations.
I will be doing incremental dimension loading amoung 3 databases. All 3 of them are on the same server. I have a transactional DB Salome...
1110
Marek Vavrovic
- Apr 16, 2022
- 7 min
Change Data Capture (CDC) In SQL Server
Incremental load for inserts (no updates or deletes) Incremental load for insert, update, delete Overview SQL Server Change Data Capture...
1590
Marek Vavrovic
- Apr 13, 2022
- 1 min
SSRS Loan Statement
Using T-SQL Stored Procedure to create a report in Power BI Report Builder. Data set: Using T-SQL to create a bank loan statement...
410
Marek Vavrovic
- Apr 9, 2022
- 1 min
Connecting to Integration Services Access is Denied in SQL Server
Connection to the Integration Services service on the computer " XXX " failed with the following error: "Access is denied" By default...
5720
Marek Vavrovic
- Apr 6, 2022
- 1 min
Using T-SQL to create a bank loan statement
CREATE PROC sp_LoanAmount ( --Supplying default values @LoanAmount Money = 1000, @RateOfInterest decimal(5,2) = 5, @TimePeriod tinyint =...
750
Marek Vavrovic
- Apr 5, 2022
- 3 min
Update table using join statement
Examples of SQL Update Join RIGHT JOIN LEFT JOIN INNER JOIN WHERE clause CASE statement Computed Columns create table MyTarget (id int...
190
Marek Vavrovic
- Apr 4, 2022
- 5 min
SQL Server Transactions
What is a Transaction in SQL Server? A transaction is a set of SQL statements that should be executed as one unit. That means a...
320
Marek Vavrovic
- Mar 30, 2022
- 4 min
HuffnerTextile - SSIS Initial data load.
Examples of BI joins -Dimensions DimEmployee Select [EmployeeID] [EmployeeKey], case when [EmployeeID] = 2 then 1 when [EmployeeID] in...
280
Marek Vavrovic
- Mar 30, 2022
- 3 min
Huffner Textile - Data Warehouse Design
Files to download: -sql database backup -SQL Server Database Project Types of Data Warehouse Schema STAR SCHEMA The simplest and the most...
70
Marek Vavrovic
- Oct 25, 2021
- 11 min
SSIS - Incremental Load
Data source: http://www.planecrashinfo.com/database.htm. This is an article describing how I have been extracting data from that data...
1420
Marek Vavrovic
- Oct 17, 2021
- 5 min
Calculating Average using T-SQL
Calculating average by week number. Calculating average by month number. Using AVG() OVER() Moving average in T-SQL Weighted Moving...
1490
Marek Vavrovic
- Oct 16, 2021
- 2 min
Window Functions
FIRST_VALUE LAST_VALUE Previous day (Difference between current date and previous date value) LAG() (Calculating price difference...
110
Marek Vavrovic
- Aug 12, 2021
- 2 min
Create a Stored Procedure in SQL Server.
A stored procedure is a group of T-Sql statements. If you have a situation, where you write the same query repeatedly, you can save that...
2010
Marek Vavrovic
- Aug 10, 2021
- 2 min
CREATE VIEW in SQL Server using T-SQL.
A view is a saved query. The following example creates a view by using a simple SELECT statement. A simple view is helpful when a...
420
Marek Vavrovic
- Aug 9, 2021
- 2 min
Grouping in SQL Server
SQL Server GROUP BY clause SQL Server GROUPING SETS SQL Grouping Function 1. SQL Server GROUP BY clause The GROUP BY clause allows you...
220
Marek Vavrovic
- Aug 7, 2021
- 2 min
How to list the most expensive price of items by category in MS SQL Server.
I will use the Northwind database. You can download the db from this page: https://parallelcodes.com/download-sql-northwind-database-bak-...
2,7340
Marek Vavrovic
- Mar 8, 2020
- 3 min
Types of SQL Server Joins With Examples
SQL file to download A JOIN clause is used to combine rows from two or more tables, based on a related column between them. SQL Joins are...
1320
Marek Vavrovic
- Mar 1, 2020
- 3 min
Control-of-Flow
Flow-control statements from T-SQL are rather rudimentary compared to similar commands in other modern programming languages such as...
590
Marek Vavrovic
- Feb 16, 2020
- 2 min
SQL Server - Subquery short overview
Many Transact-SQL statements that include subqueries can be alternatively formulated as joins. There are several ways you can categorize...
410
Power BI
SSIS
Import .CSV files from web site
Data Refresh - Expression.Error column not found
Covid-19 Dashboard
AdventureWorksDW2017 Dashboard
Wide World Importers Dashboard
Slovakia covid-19
DAX measures for Covid-19
Tesla 2009-2020 Financial reports analysis
Covid 19 Dashboard (OWID)
Huffner Textile Dashboard
Northwind dashboard
File System Task
Sequence Container
Execute SQL Task