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...
5410
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...
8120
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...
2280
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...
4,7240
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 =...
2910
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...
1040
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...
1320
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...
520
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...
450
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...
4290
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...