Search - Joel Lipman .Com

1. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... r_CheckIfDocumentAlreadyExists.ID]; v_DateAdded = r_NewDocumentRecord.Added_Time.toString("E, d MMM yyyy HH:mm"); } else { r_Document = insert into Document [ Added_User=zoho.loginuser Document_Name=r_Attachment.get("File_Name") Document_File=r_Download Downloaded="Downloaded" Parent_Record=v_CrmContactID.toString() ]; r_NewDocumentRecord ...; Created on 11 March 2022
2. Split a row into multiple rows based on a column value: / Transact-SQL /; ... + row(1) = 26th when the person was off the 25th): SELECT EmployeeNo , '1' + substring(CAST(DaysOffSick AS VARCHAR(10)), 2, 1000) AS DaysOffSick , DATEADD(d, ROW_NUMBER() ...; Created on 23 August 2013
3. Cheat Sheet for mySQL vs t-SQL: / Databases /; ... getdate())) Seconds to Time SEC_TO_TIME( seconds ) CONVERT(varchar, DATEADD(ms, seconds * 1000, 0), 114) Add/Subtract Date DATE_ADD(date,INTERVAL number datepart) DATE_SUB(date,INTERVAL number datepart) ...; Created on 31 January 2013
4. Generate Academic Calendar using MySQL: / MySQL /; ... 1, 3) + '-' + CAST(DATEPART(yyyy, calendar.StartDate) AS VARCHAR(4)) AS Monday, CAST(DATEPART(dd, DATEADD(d, 1, calendar.StartDate)) AS VARCHAR(2)) + '-' + SUBSTRING(DATENAME(mm, DATEADD(d, 1, calendar.StartDate)), ...; Created on 27 November 2012
5. T-SQL Record Separator: / Transact-SQL /; ... ASC, t1.Finish ASC) as 'RowNumber' FROM ( SELECT DATENAME(dw, tt.[WeekDay]-1) AS 'Day', dateadd(d, tt.[WeekDay] - 1, (SELECT TOP 1 StartDate FROM [pretendDatabase].[pretendSchema].[WEEKSTRUCTURE] ...; Created on 11 October 2011
6. The ReportServer Database: / Databases /; ... DATEADD(millisecond, [TimeDataRetrieval]+[TimeProcessing]+[TimeRendering], '00:00:00'), 121) AS TIME) Unaccounted time. SUM(DATEDIFF(MILLISECOND, TimeStart, TimeEnd)) [TimeTakenSum] AVG(DATEDIFF(MILLISECOND, ...; Created on 08 August 2011
7. Before and After, Highs and Lows: / SQL Server Reporting Services /; ... my question: SELECT Catalog.Name AS ReportName , MIN(ExecutionLogStorage.TimeStart) AS [First] , MAX(ExecutionLogStorage.TimeStart) AS [Last] , CAST(CONVERT(CHAR, DATEADD(millisecond, ...; Created on 03 August 2011
8. 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
9. Set default parameter dates to start and end of month: / SQL Server Reporting Services /; ... Date (european format - dd/mm/yyyy) =CDate("01/" + cstr(month(today.now())) + "/" + cstr(year(today.now()))) -- To Date (european format - dd/mm/yyyy) =dateadd("d",-1, CDate("01/" + cstr(month(today.now())+1) ...; Created on 05 April 2011
10. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; ... AS ( --Select First hour in range SELECT CONVERT(DATETIME,@StartTime) AS [Time] UNION ALL --Add a record for every half-hour in the range (change based on slot times) SELECT DATEADD(MI, ...; Created on 23 March 2011
11. 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
12. Parameters not being used in report processing: / SQL Server Reporting Services /; ... on the given date SET @setId = (SELECT TOP 1 SetId FROM WEEKSTRUCTURE WHERE StartDate BETWEEN DATEADD(day, -6, @specifiedDate) AND DATEADD(day, 6, @specifiedDate)) SET @weekNumber = (SELECT TOP 1 WeekNumber ...; Created on 07 January 2011