Generate Academic Calendar using MySQLhttps://joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 SELECT calendar.WeekNumber AS AcademicWeek, CAST(DATEPART(dd, calendar.StartDate) AS VARCHAR(2)) + '-' + SUBSTRING(DATENAME(mm, calendar.StartDate), 1, 3) + '-' + CAST(DATEPART(yyyy, calendar.StartDate) AS VARCHAR(4)) AS Monday, CAST(DATEPART(dd,...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Cheat Sheet for mySQL vs t-SQLhttps://joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 BIT_LENGTH(string) CHAR_LENGTH(string) LEN(string) DATALENGTH(string) Dates / Times Weekday Name DAYNAME(now()) DATENAME(dd, getdate()) Weekday Number DAYOFWEEK(now()) DATEPART(dw, getdate()) Month Name MONTHNAME(now()) DATENAME(mm, getdate()) Month...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 DATEADD(day, 1, @specifiedDate)) SELECT @specifiedDate AS 'GivenDate', dateadd(d, tt.[WeekDay] - 1, @baseDate) AS 'Date', datename(weekday, dateadd(d, tt.[WeekDay] - 1, @baseDate)) AS 'Day', tt.[SiteId] AS 'Site', tt.[StartTime] AS 'Start',...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 within the same select query based on a column that's different. So for example, I have data like the following: SELECT DATENAME(dw, StartDate) AS 'Day' FROM Timetable ORDER BY StartDate ASC, AnotherOrderByCol ASC, AndAnotherOrderByCol ASC -- Yields /*...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB