Search - Joel Lipman .Com

1. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... " and it should popup with ...things you can ask me... with one being "Ask ChatGPT" Click on it and then ask away:... Keeping a Conversation So annoyingly, the variable broadcast was unreliab ...; Created on 06 March 2023
2. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... Castle,England\n"; v_DataCSV = v_DataCSV + "11,General Dogsbody,\"Flat 8, House Corner, My Street\",Brummieland\n"; v_DataCSV = v_DataCSV + "64,Elephant Man,\"123 New Street,\nNew York City\",USA\n"; f_CSVfile ...; Created on 26 August 2021
3. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... ms-settings:easeofaccess-speechrecognition Gaming Broadcasting ms-settings:gaming-broadcasting Game bar ms-settings:gaming-gamebar Game DVR ms-settings:gaming-gamedvr Game Mode ms-settings:gaming-gamemode ...; Created on 30 July 2020
4. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... and weather data v??? In Development: - Map: specify weather forecasts for a day - Map: current location response issues - Map: screenshot for offline use - Map: enable news feed on HUD - Map: ...; Created on 24 October 2014
5. T-SQL: Parse an XML value: / Transact-SQL /; ... INSERT 2014-03-27 Extracting the Gender: We're going to extract the value in between the opening and closing XML tags: -- Using .query() SELECT CAST(CAST(Event_XML ...; Created on 27 March 2014
6. Compare two databases using T-SQL: / Transact-SQL /; ... END AS [ColumnDataType], CASE WHEN t1.CHARACTER_MAXIMUM_LENGTH IS NULL AND t2.CHARACTER_MAXIMUM_LENGTH IS NOT NULL THEN CAST(t2.CHARACTER_MAXIMUM_LENGTH ...; Created on 24 September 2013
7. Split a row into multiple rows based on a column value: / Transact-SQL /; ... EmployeeNo , DaysOffSick , DateOfSickness ,'1' + substring(CAST(DaysOffSick AS VARCHAR(10)), 2, 1000) AS Items FROM Employees_Attendance_Table JOIN master..spt_values ...; Created on 23 August 2013
8. T-SQL concatenate an incremental row number: / Transact-SQL /; ... (padded with zeros) How? So how do we do it? In the above example, Joel Lipman has two qualification records. So let's start with a simple query: SELECT RIGHT('000' + CAST(e.ID AS VARCHAR), ...; Created on 24 May 2013
9. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; ... e1 LEFT JOIN DMExtractReferenceTable r1 ON e1.CodeType=r1.MapIn So simply change the "=" to a "LIKE". Scenario #2 So when the above has been addressed or we've tried casting ...; Created on 14 May 2013
10. SSIS Convert a string into a date: / SQL Server Integration Services /; ... + "/" + SUBSTRING((DT_STR,8,1252)StartDate,3,2) + "/" + SUBSTRING((DT_STR,8,1252)StartDate,5,4)) Error: Description: "Invalid character value for cast specification". Exceptions for text file ...; Created on 14 March 2013
11. DataScramble - Randomizing data rows: / Transact-SQL /; ... -- Set variable default values SET @NewVal = ''; SET @OrigLen = LEN(CAST(@OrigVal AS VARCHAR(max))); SET @CurrLen = @OrigLen; SET @LoopCt = 1; SET @DateVal ...; Created on 07 December 2012
12. Generate Academic Calendar using MySQL: / MySQL /; ... (SQL Server 2008 R2) for CMIS Facility SELECT calendar.WeekNumber AS AcademicWeek, CAST(DATEPART(dd, calendar.StartDate) AS VARCHAR(2)) + '-' + SUBSTRING(DATENAME(mm, calendar.StartDate), ...; Created on 27 November 2012
13. Search a database for a value and count matching rows: / Databases /; ... WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + CAST(@p_Value AS VARCHAR) + ', ...; Created on 05 November 2012
14. Search a database with SOUNDEX: / Databases /; ... + COLUMN_NAME + ')=SOUNDEX('''+ @p_SearchString +''') AND LEN(' + COLUMN_NAME + ')=' + CAST(@minStrLen AS varchar(11)) FROM INFORMATION_SCHEMA.COLUMNS ...; Created on 11 October 2012
15. Copy a table with structure and data into a temporary table: / Transact-SQL /; ... types into one string SELECT CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN ',' + COLUMN_NAME + ' ' + DATA_TYPE ELSE ',' + COLUMN_NAME + ' ' + DATA_TYPE + '(' + CAST(CHARACTER_MAXIMUM_LENGTH ...; Created on 03 August 2012
16. DataJumble - Shuffling characters in a data value: / Transact-SQL /; ... Given Value is date (ISDATE does not recognize CAST AS DATE) IF @OrigLen=10 AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2 AND ISNUMERIC(SUBSTRING(@OrigVal, ...; Created on 01 August 2012
17. The ReportServer Database: / Databases /; ... aggregate query. I want the SQL to return just numbers and let the MDX query add the thousand separator. My answer for everything: CAST((TimeEnd - TimeStart) AS TIME) CAST(CONVERT(CHAR, ...; Created on 08 August 2011
18. 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
19. Room with a view E.M. Forster: / Hobbies /; Taking a break from website migrations. Thought I'd share some thoughts I was reminiscing of: "We cast a shadow on something wherever we stand, and it is no good moving from place to place to save ...; Created on 04 February 2011
20. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... AS rgt, 1 AS `level`, CAST(@new_jos_categories_extension_alias AS CHAR) AS path, 'com_banners' AS extension, c.`title`, c.`alias`, CONCAT('Import from J15. PreviousID=catid', ...; Created on 30 January 2011