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…
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…
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…
Get Numbers and Percentages from Tables – Microsoft Sql Server
Sometimes you want to get some numbers and also percentages for quick analysis. This is a quick simple way to…
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…