Ajamu BamideleCreating Synonyms in SQLGenerally speaking when you hear of the word synonyms, you will want to believe that it is words that are closely related or meant almost…Jan 3, 2023Jan 3, 2023
Ajamu BamideleDATEADD() Function in SQL Server for Logistics Service Sector#QUESTION : 1. #Find 45 days from today. 2. Considering our expected ship date is 20 days after a completed order, find the expected…Nov 3, 2022Nov 3, 2022
Ajamu BamideleLife Comparison: The SQL DATEDIFF() Approach#QUESTION : #How many months, days, hours, minutes and seconds to end the year from today. #SQL #DATEDIFF() FunctionNov 2, 2022Nov 2, 2022
Ajamu BamideleDistinction between DATEPART() vs DATENAME() — SQL Server Approach#QUESTION : #Return the datepart values of today.Nov 1, 2022Nov 1, 2022
Ajamu Bamidele#CHALLENGE : #Return the datepart values of today.If you have got to work with time series analysis, you will understand the importance of dissecting dates into different parts. The…Oct 31, 2022Oct 31, 2022
Ajamu BamideleISNULL vs IS NULL which way?#QUESTION : Replace the NULLs in IncidentState column with values in City Column using #ISNULL() FunctionOct 30, 2022Oct 30, 2022
Ajamu BamideleRunning Total Calculation in SQL#QUESTION : Calculate the #running #total or #cumulative #points of game played in eurovision table.Oct 29, 2022Oct 29, 2022