sql server

| |

Using Subqueries To Join 2 More Tables Which Do Not Have Unique Primary and Foreign Keys

Using Subqueries to join 2 more tables which do not have distinct values in a column We want to find the number of Flight bookings by Country, number of Car bookings by Country and the number of Hotel bookings by Country all appearing in one table with same country on one row. We want to…

|

Rank a Place Visited By a Customer- Microsoft SQL Server – T-Transact

This is a short guide to getting ranking or rating from Microsoft Sql Server customers. Ranking is taken by checking how many times a customer has visited a particular country divided by the total number of travels the customer has made within the database   /*make a back up of the recommender rankings table*/ truncate…

|

Splitting Values in one Column to Multiple Columns using CASE Expression Statement SQL Server

Sometimes, you would want to split values in a column into separate rows  in SQL server.  This is a simple guide. Lets check the fields in the table we will be working with. select [orderID] ,[itemType] ,[price] ,[quantity] from [Antrak].[dbo].[ClothingSale] Let’s check the result:   We can see that the itemType field has different values…

Great Quick Transact-SQL Server Tutorials – Quick Revision and General Understanding
|

Great Quick Transact-SQL Server Tutorials – Quick Revision and General Understanding

I receive a lot of emails about where to get quick and excellent resources for explaining most of the concepts of Transact-SQL (T SQL)  and  Microsoft SQL Server in general What is Transact-SQL or T SQL. T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query…