Name		Name	Last commit message	Last commit date
Latest commit History 231 Commits
2010_capitalbikeshare_tripdata.csv		2010_capitalbikeshare_tripdata.csv
Aggregating_time_series_data- Basic_Aggregation.sql		Aggregating_time_series_data- Basic_Aggregation.sql
Aggregation Functions over windows -.sql		Aggregation Functions over windows -.sql
Aggregations-Groupings-Strings.sql		Aggregations-Groupings-Strings.sql
Avg_votes.PNG		Avg_votes.PNG
Avg_votes2.PNG		Avg_votes2.PNG
Benefits_of_Creating_a_View.txt		Benefits_of_Creating_a_View.txt
Benefits_of_views.sql		Benefits_of_views.sql
Bulk_Insert.png		Bulk_Insert.png
Bulk_Insert.sql		Bulk_Insert.sql
Bulk_Insert_writeUp.txt		Bulk_Insert_writeUp.txt
CHARINDEX.sql		CHARINDEX.sql
CRUD.sql		CRUD.sql
CTEs.sql		CTEs.sql
Century_calculation.PNG		Century_calculation.PNG
Century_of_Dob.PNG		Century_of_Dob.PNG
Challenge2.SQL		Challenge2.SQL
Challenge_All_voters.png		Challenge_All_voters.png
Charindex_position_a.png		Charindex_position_a.png
Charindex_position_of_a.txt		Charindex_position_of_a.txt
Choose_Function_for_workday.PNG		Choose_Function_for_workday.PNG
Choose_Function_for_workday_AdventureWorks.PNG		Choose_Function_for_workday_AdventureWorks.PNG
Concat_left_Substring.png		Concat_left_Substring.png
Concat_sample_query.sql		Concat_sample_query.sql
Concat_samples.txt		Concat_samples.txt
Converting to dates and times.sql		Converting to dates and times.sql
Copy_as_path.png		Copy_as_path.png
Create_CapitalBike_Trips_Table.png		Create_CapitalBike_Trips_Table.png
Create_Index_view.txt		Create_Index_view.txt
Create_NBA_Player_Statistics_Table.sql		Create_NBA_Player_Statistics_Table.sql
Create_SYNONYMS.txt		Create_SYNONYMS.txt
Create_Stored_Procedure.txt		Create_Stored_Procedure.txt
Create_Stored_Procedure2.txt		Create_Stored_Procedure2.txt
Create_Stored_Procedure3.txt		Create_Stored_Procedure3.txt
Create_Table_From_Table.sql		Create_Table_From_Table.sql
Create_a_blank_table_structure.png		Create_a_blank_table_structure.png
Create_a_stored_procedure.sql		Create_a_stored_procedure.sql
Create_a_table_without_data.sql		Create_a_table_without_data.sql
Create_an_index_view.sql		Create_an_index_view.sql
Create_db_Table_product_transactions.sql		Create_db_Table_product_transactions.sql
Create_fucntion.txt		Create_fucntion.txt
Create_fucntion2.txt		Create_fucntion2.txt
Create_fucntion3_Modify_Function.txt		Create_fucntion3_Modify_Function.txt
Create_function.txt		Create_function.txt
Create_table_from_another_table_with_no_data.txt		Create_table_from_another_table_with_no_data.txt
Create_table_from_anothertable.png		Create_table_from_anothertable.png
Create_table_from_table_sqlserver.png		Create_table_from_table_sqlserver.png
Create_table_from_table_structure.txt		Create_table_from_table_structure.txt
Create_user_defined_function.png		Create_user_defined_function.png
Create_user_defined_function.sql		Create_user_defined_function.sql
Create_user_defined_function2.png		Create_user_defined_function2.png
Create_user_defined_function_with_Parameters.sql		Create_user_defined_function_with_Parameters.sql
Create_view_Join.txt		Create_view_Join.txt
Create_view_Join_table.sql		Create_view_Join_table.sql
Create_view_delete_table.sql		Create_view_delete_table.sql
CreatingEurovisionTablesColumn.sql		CreatingEurovisionTablesColumn.sql
Creating_Bike_Store_datasets.sql		Creating_Bike_Store_datasets.sql
Creating_Capital_Bike_Trips_Table.sql		Creating_Capital_Bike_Trips_Table.sql
Creating_Eurovision_Table.sql		Creating_Eurovision_Table.sql
Creating_Tree_Table.png		Creating_Tree_Table.png
Creating_table_from_table_error.png		Creating_table_from_table_error.png
Creating_tree_table.sql		Creating_tree_table.sql
Database_Design.sql		Database_Design.sql
DateADD_T-SQL.PNG		DateADD_T-SQL.PNG
DateAdd_T-SQL.sql		DateAdd_T-SQL.sql
DateDiff_T-SQL.PNG		DateDiff_T-SQL.PNG
DatePart.PNG		DatePart.PNG
DatePart_Datename.png		DatePart_Datename.png
Datename_DatePart_report.sql		Datename_DatePart_report.sql
Datepart_andDatename_combined.sql		Datepart_andDatename_combined.sql
Datepart_extract_parts_of_date.sql		Datepart_extract_parts_of_date.sql
Declare_delete-insert.sql		Declare_delete-insert.sql
Delete_Truncate_Drop.txt		Delete_Truncate_Drop.txt
Delete_column.sql		Delete_column.sql
Delete_truncate_drop.png		Delete_truncate_drop.png
Deleting a column.txt		Deleting a column.txt
Demerit_of_Views.txt		Demerit_of_Views.txt
EDA,_Variables_&_Date_Manipulation.sql		EDA,_Variables_&_Date_Manipulation.sql
Electric bike store dataset and Bank accounts dataset.sql		Electric bike store dataset and Bank accounts dataset.sql
First_Day_of_Month.sql		First_Day_of_Month.sql
First_day_of_month.txt		First_day_of_month.txt
First_day_of_month_BikeShare.png		First_day_of_month_BikeShare.png
First_letter_Cap.sql		First_letter_Cap.sql
Functions_for_Manipulating_Data_in_SQL_Server.sql		Functions_for_Manipulating_Data_in_SQL_Server.sql
Grouping by roll up, cube and grouping sets.sql		Grouping by roll up, cube and grouping sets.sql
Grouping_Having.sql		Grouping_Having.sql
Handling_invalid_Dates.sql		Handling_invalid_Dates.sql
Handling_missing_values.sql		Handling_missing_values.sql
INITCAP.txt		INITCAP.txt
INTERVIEW.txt		INTERVIEW.txt
Importing_Excel_File.png		Importing_Excel_File.png
Improving Query Performance in SQL Server.sql		Improving Query Performance in SQL Server.sql
Index_view.png		Index_view.png
Index_view2.png		Index_view2.png
Index_view3.png		Index_view3.png
Interview_question3.png		Interview_question3.png
Interview_question4.png		Interview_question4.png
Joins.sql		Joins.sql
Lead&Lag.sql		Lead&Lag.sql
Lead&LagSample_Query.txt		Lead&LagSample_Query.txt

Repository files navigation

T-SQL

This shows some of the queries using Microsoft SQL Server or Transact-SQL

BamideleAdeola/T-SQL

Folders and files

Latest commit

History