Sunday January 21st 2018




‘SQL Server 2000’ Archives

Correlated subquery

Correlated subquery (also known as a repeating subquery) is a subquery where selection criterion of inner query refers to values in the outer query. One of the restriction is that inner query cannot return more than one row matching the outer row; Example; USE pubs SELECT au_lname, au_fname FROM authors WHERE 100 IN (SELECT royaltyper [...]

Pivot Table with Excel 2007 with data from Sql Server

This post is about using pivot table with excel 2007 with invoice payments received data from sql server. In this case company’s payment mechanism was changed from full 1 payments to breakup in 4 to 5 payments. We created a new table named payments received and linked it to the Invoices table. Whenever payment for certain invoice received it [...]

Business Intelligence – Layout-led and Data-led discovery

Layout-led discovery When we know the questions we want answered and have a good idea where that answer is going to be found, we can use the printed reports to deliver our business intelligence. This is the most common form of business intelligence. For example we want to know employee productivity for bonus calculations we know where to [...]

Data Scrubbing / Cleansing

Data Scrubbing / Cleansing

Data scrubbing also called data cleansing, is the process of amending or removing incorrect data in a database. Sometimes data incomplete, improperly formatted like postal code should be in this format "N9B 1W7" not in “N9B1W7"or first name and last name in 1 field, instead separate fields or duplicated. Sometimes zip codes are missing or in [...]

Data Architect – Overview

Data Architect – Overview

Many times in the job descrition a title Data Architect is used. According to DAMA (Data Management Association) , Data Architect is often interchangeable with, but includes enterprise architecture considerations. A DAMA recognized Certified Data Management Professional would have a wide range of such skills. Translating this to Data [...]

Using Derived tables

In Sql language this is very common to use views instead of tables directly, for example we can create view; View_MarketingEmployees ;  CREATE VIEW View_MarketingEmployees AS   SELECT * FROM Employee   WHERE department = "marketing"  GO Then If we wanted to see all of the Employees from Marketing with the First name John, ordered [...]

 Page 2 of 2 « 1  2