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...
3400
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...
4870
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...
1620
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...
2,9830
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 =...
2030
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...
540
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...
820
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...
390
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...
350
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...
3100
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...
5010
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...
180
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...
2660
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...
780
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...
350
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-...
4,3790
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...
1610
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...
1540
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...
580
1