Get Numbers and Percentages from Tables – Microsoft Sql Server

Bydatapandasadmin October 2, 2016

Sometimes you want to get some numbers and also percentages for quick analysis. This is a quick simple way to get quick overviews

Want more information like this?

Business Intelligence - BI | SQL

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

Bydatapandasadmin November 9, 2016

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 table antrak.dbo.recommender_rankings_copy

insert into antrak.dbo.recommender_rankings_copy

select * from antrak.dbo.recommender_rankings

/*select total number of times a customer has travelled to a specific country*/

select

[First Name]

,Country

, count(*) as [# times visited]

into #travelpercountry

FROM

[Antrak].[dbo].[FlightBookingsMain]

group by

[First Name]

,Country

order by [First Name]

/*total number of times each customer has travelled to all destinations*/

select

[First Name]

, count(*) as [# times visited]

into #totaltravel

FROM

[Antrak].[dbo].[FlightBookingsMain]

group by

[First Name]

----,Country

order by [First Name]

-- lets view by the total bookings

select * from #totaltravel order by [First Name]

-- lets view bookings per country

select * from #travelpercountry order by [First Name]

/*get rating*/

drop table antrak.dbo.recommender_rankings

select

tt.[First Name]

,Country

,cast(round((cast(tpc.[# times visited] as decimal(3,0)) / cast(tt.[# times visited] as decimal(3,0)) * 100), 1) as float) as rating

into antrak.dbo.recommender_rankings

from

#totaltravel as tt

inner join

#travelpercountry as tpc

on tt.[First Name] = tpc.[First Name]

order by [First Name]

select * from antrak.dbo.recommender_rankings

/*lets refresh the temporary tables*/

drop table #totaltravel

drop table #travelpercountry

Want more information like this?

Python | Transact-SQL

Use Python 2 and 3 Pyodbc and Sqlalchemy to connect to SQL Server Client 11.0
ByBernard Adabankah April 18, 2021February 14, 2023

There are several ways you can use Python to connect to SQL Server and one of such ways is to use pyodbc and sqlalchemy Recent search terms:datapandas com Want more information like this?

Read More Use Python 2 and 3 Pyodbc and Sqlalchemy to connect to SQL Server Client 11.0
SQL | Transact-SQL

Great Quick Transact-SQL Server Tutorials – Quick Revision and General Understanding
Bydatapandasadmin August 7, 2016August 7, 2016

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…

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

SQL | Transact-SQL

Pyodbc Sqlalchemy Python 2 and 3 SQL Server Native Client 11.0

Bydatapandasadmin April 18, 2021April 18, 2021

This is a sample code to use Python to connect to SQL Server Native Client.

import sqlalchemy

import pyodbc

try:

import urllib

params = urllib.quote_plus("DRIVER={SQL Server Native Client 11.0};SERVER=.\MSSQLSERVER_ENT;DATABASE=MagicDirect;Trusted_Connection=yes;")

engine = sqlalchemy.create_engine('mssql+pyodbc:///?odbc_connect=%s"' % params)

results.to_sql("clusterSegments", engine, if_exists = 'replace')#

except (RuntimeError, TypeError, NameError):

print('Error in Conneccting')

print(RuntimeError, TypeError, NameError)

finally:

print("connected")

Want more information like this?

Coursera | SQL | Teradata

Teradata Viewpoint – SQL Scratchpad – Writing Queries Dillard’s Department Store Database
Bydatapandasadmin May 8, 2016May 8, 2016

Analysing ‘Big Data’ from a database with real world data requires retrieving data from the database by writing relevant queries. As part of “Managing Big Data with MySQL” by Duke University on Cousera, I dealt with real world data that comprise hundreds to millions of entries/rows. This is the database of Dillard’s Department stores, specifically, the UA_DILLARDS that contains…

Read More Teradata Viewpoint – SQL Scratchpad – Writing Queries Dillard’s Department Store Database
SQL | Transact-SQL

Splitting Values in one Column to Multiple Columns using CASE Expression Statement SQL Server
Bydatapandasadmin November 3, 2016November 3, 2016

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.

Default

1
2
3
4
5
6
7

select
[orderID]
,[itemType]
,[price]
,[quantity]
from
[Antrak].[dbo].[ClothingSale]

Let’s check the result: We can see that the itemType field has different values wheres as the price and quantity…

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

Get Numbers and Percentages from Tables – Microsoft Sql Server

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

Use Python 2 and 3 Pyodbc and Sqlalchemy to connect to SQL Server Client 11.0

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

Pyodbc Sqlalchemy Python 2 and 3 SQL Server Native Client 11.0

Teradata Viewpoint – SQL Scratchpad – Writing Queries Dillard’s Department Store Database

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

Leave a Reply Cancel reply

DataPandas LTS

EXPLORE DataPandas

ImportAnt link

GET IN TOUCH

© 2026 DataPandas

Similar Posts

Leave a Reply Cancel reply

DataPandas LTS

EXPLORE DataPandas

ImportAnt link

GET IN TOUCH

© 2026 DataPandas