Search - Joel Lipman .Com

21. Include a carriage return in a column heading: / SQL Server /; ... on a database on the other side of the world. I want the header in the column "Academic Week" to break across two lines so that the column doesn't expand to the width of "Academic Week" and instead expands ...; Created on 07 July 2014
22. Generate a Timesheet in MySQL: / MySQL /; What? This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with ...; Created on 05 December 2013
23. Client Services: Website Development Agreement: / Static Items /; ... based on the initial requirements up to and including the User Acceptance Testing (UAT) date (not yet agreed, but about a week prior to release date). JoelLipman.Com will make the source files available ...; Created on 15 November 2013
24. MS Excel - Sort pivottable column headings by date: / Excel /; ... column) and the days of the week along the top. Why? The excel report would hit a bug where it couldn't work out that 10 (Wednesday) happened after 8 (Monday). How? See the following screenshot ...; Created on 12 April 2013
25. AwStats Data Parser (ADP): / Product Documentation /; ... of Month (per day this month) Days of Week (per day this month) Hours (per hour this month) Countries (Top 25 this month) Hosts (Top 25 this month) Robots/Spiders (Top 25 this month) visits ...; Created on 03 April 2013
26. Cheat Sheet for mySQL vs t-SQL: / Databases /; ... string,start,length ) SUBSTRING( string,start,length ) String Length LENGTH(string) BIT_LENGTH(string) CHAR_LENGTH(string) LEN(string) DATALENGTH(string) Dates / Times Weekday Name DAYNAME(now()) ...; Created on 31 January 2013
27. Generate Academic Calendar using MySQL: / MySQL /; What? We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article ...; Created on 27 November 2012
28. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; ... 1. Generate query to list all valid users 2. Generate query which will total hours per week per user 3. Combine in a loop to run query against each user. Post-Notes (Update 2012) The performance ...; Created on 27 April 2012
29. T-SQL Record Separator: / Transact-SQL /; ... and room booking system). But I do get given a weekday and the start date of the week... WITH tblDifference AS ( SELECT t1.*, ROW_NUMBER() OVER (ORDER BY t1.Date ASC, t1.Start ASC, t1.Room ...; Created on 11 October 2011
30. SSRS External Images don't displa: / SQL Server Reporting Services /; ... does not exist We don't have photos for all ~20000 students at all times and these get updated/uploaded/added to about once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. ...; Created on 19 September 2011
31. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... WEEKDAY(s.DateTimeCreated) WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday' WHEN 5 THEN 'Saturday' ELSE 'Sunday' END AS ActivityDay, DATE(s.DateTimeCreated) ...; Created on 24 August 2011
32. Before and After, Highs and Lows: / SQL Server Reporting Services /; ... yesterweek, yestermonth, yesteryear and do the layout in PHP. Now let's say I have one RDL or SSRS Solution. I could do a dataset per SQL query but it doesn't seem that ideal. In Theory: SELECT ...; Created on 03 August 2011
33. SSRS / MDX Date Queries: / SQL Server Reporting Services /; ... my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS 2008 R2. The following examples assume today's date is Wednesday 03 August 2011 @ 11:46: This Week: -- Start Date (US format - mm/dd/yyyy) =DateAdd("d", ...; Created on 03 August 2011
34. Unix Date Format Specifiers: / Linux /; ... Specifier Description Values/Example Day %a weekday, abbreviated Mon %A weekday, full Monday %d day of the month (dd), zero padded 04 %e ...; Created on 05 July 2011
35. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; ... = sd.[SetId] INNER JOIN [CONTACT] c ON c.[ContactId] = sd.[Contact] and c.[SetId] = sd.[SetId] INNER JOIN [WEEKMAPNUMERIC] wm ON (wm.[SetId] = tt.[SetId] and wm.[WeekId] = tt.[WeekId]) WHERE ...; Created on 23 March 2011
36. SSRS Expand specific drilldown by default: / SQL Server Reporting Services /; ... particular week. When I open the report, each drilldown row is collapsed (as opposed to expanded). The user can specify the date as it's a report parameter. What we want The user will select a ...; Created on 23 February 2011
37. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... want to add new 3rd-party components. If asked: "how long will it take", do not say 5 minutes. This script runs on average in 15 seconds. The remaining hours, days, weeks will be spent on bringing ...; Created on 30 January 2011
38. SQL Calendar in Business Intelligence Development Studio: / Transact-SQL /; So I find myself searching the web for a way of producing an outlook-style calendar within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally ...; Created on 14 January 2011
39. Parameters not being used in report processing: / SQL Server Reporting Services /; ... bookings for a week based on a given date and campus -- =============================================================================== DECLARE @GivenDate datetime, @GivenCampus varchar(100), @setId ...; Created on 07 January 2011
40. Is it a scam? Gumtree.com's warning sign: / IT Support /; ... only to be refused weeks later. At this point, the bank/building society will take the full cheque amount back out of your account. This would then leave you out of pocket for the amount on the cheque ...; Created on 12 October 2010