Search - Joel Lipman .Com

21. Android: Replace return key with done, go, send...: / AndroidOS /; ... a phone number datetime // enter a date and time date // selectable date time // selectable time android:imeOptions normal actionUnspecified actionNone actionGo actionSearch actionSend actionNext actionDone actionPrevious IME_ACTION(s) ...; Created on 03 November 2014
22. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... } } } } private void DebugLogEvent(string DebugString) { DateTime now = DateTime.Now; this.ComponentMetaData.PostLogMessage(DebugLogEventName, ...; Created on 04 October 2013
23. SSIS Convert a string into a date: / SQL Server Integration Services /; ... + "/" + SUBSTRING(This_Date,4,2) + "/" + SUBSTRING(This_Date,7,4)) -- if data source column is of datatype string and european date format: return SQL datetime (TRIM(This_Date) == "") ? (DT_DBTIMESTAMP)"1900-01-01" ...; Created on 14 March 2013
24. Delete related records from multiple tables: / MySQL /; ... s, ssf, sst FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON ssf.sessionId=s.sessionId LEFT OUTER JOIN `SessionStudent` sst ON sst.sessionId=s.sessionId WHERE s.dateTime >= '2013-02-01 00:00:00' -- ...; Created on 11 January 2013
25. DataJumble - Shuffling characters in a data value: / Transact-SQL /; This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...; Created on 01 August 2012
26. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; ... this week, 1 for the week before, 2 for the week before that... $timesheet_query_per_user=" SELECT DISTINCT s.StaffUserID AS 'UserID', ( SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) ...; Created on 27 April 2012
27. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... which had seconds as its smallest denominator: ="Execution Time: " + CStr(System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours) + " hour(s)" + " , " + CStr(System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes) ...; Created on 17 November 2011
28. T-SQL Record Separator: / Transact-SQL /; ... perform formatting to extract the minimum data here (eg. datetime into date, etc) * FROM [pretendDatabase].[pretendSchema].[pretendTable] t0 WHERE [pretendField]='elephantastic' -- ...; Created on 11 October 2011
29. 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
30. The ReportServer Database: / Databases /; ... datetime NOT NULL Time report started to run. TimeEnd datetime NOT NULL Time report finished running? Need to check what finished? TimeDataRetrieval int NOT NULL Milliseconds spent retrieving the ...; Created on 08 August 2011
31. Difference between two dates - the midnight hour: / Web-Development /; I might already have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on ...; Created on 06 April 2011
32. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; ... below... hopefully it will be quicker next time now that I noted it all down. The SQL Script: DECLARE @StartTime datetime, @EndTime datetime, @GivenDate datetime; SET DATEFORMAT dmy; SET ...; Created on 23 March 2011
33. SQL Calendar in Business Intelligence Development Studio: / Transact-SQL /; ... @StartDate DATETIME, @EndDate DATETIME --First day of current month SET @StartDate = DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) --First day to display on calendar SET @StartDate = DATEADD(DAY,-DATEPART(WEEKDAY,@StartDate)+1,@StartDate) --Last ...; Created on 14 January 2011
34. Formatting a date in an MDX query: / Transact-SQL /; Thought I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The ...; Created on 11 January 2011
35. 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
36. Returned a data type that is not valid: / Transact-SQL /; ... 1, 0)) 'Smart', SUM(IF(t1.VisitorBrowser='Other', 1, 0)) 'Other', COUNT(t1.VisitorBrowser) 'Total' FROM (SELECT a.DateTimeStamp Date, CASE WHEN INSTR(a.VisitorUAgent, 'MSIE ') THEN 'MSIE' WHEN ...; Created on 06 January 2011
37. SQL Queries for Statistics: / MySQL /; ... via the browser useragent (VisitorUAgent), the User ID (VisitorID, 0 if not logged in) and of course the Timestamp (DateTimeStamp). Here is a page of some MySQL queries I can do based on just those ...; Created on 13 December 2010
38. Transact-SQL Date Format Conversions: / Transact-SQL /; Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx; Created on 19 November 2010
39. MySQL Data Type Reference Table: / MySQL /; ... Date/Time DateTime 'YYYY-MM-DD HH:MM:SS' 8 bytes ...; Created on 15 February 2010
40. Converting SQL date in PHP to European date format and vice-versa: / Personal Home Page /; ... trim(substr($this_date, 0, strpos($this_date, " ")))); $this_time=trim(substr($this_date, strpos($this_date, " ")+1)); $formatted_datetime=implode("/", array_reverse($this_date_array))." ...; Created on 17 September 2009