Assuming column is required, the following 98 results were found.
-
If-then-else IF( expression,value_if_true,value_if_false ) IIF( expression,value_if_true,value_if_false ) If Null IFNULL(column_name,value_if_null) ISNULL(column_name,value_if_null) Rank/Rownum (@rownum:=@rownum+1) AS Rownum LIMIT from_index,...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
on. [Order] = DENSE_RANK() OVER (ORDER BY d.[Date]), -- date used in all calculations for date d.[Date], --generates matrix columns [WeekDay] = DATEPART(WEEKDAY, d.[Date]), --used to display day of month on calendar [Day] = DATEPART(DAY,d.[Date]),...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data Not Yet Available". Unfortunately the end-user reported these...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
on DataJumble and DataScramble). How? CREATE PROCEDURE [Common].[usp_ScrambleMultivalue] ( @TableName VARCHAR(MAX), @ColumnName VARCHAR(MAX), @WhereClause VARCHAR(MAX) = NULL ) AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
in and out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If you want to remove the...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
addresses which in turn contained commas. Saving this as a CSV and asking Deluge to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
A quick article to display a value in a column in a widget in Zoho Analytics. Why? Because I keep forgetting how to do it. How? I've done this for a query that amalgamated all the deals against a deal owner and needed to repeat this for all the invoices...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
m_Header.put("ZANALYTICS-ORGID",v_ZA_OrgID); m_Params = Map(); m_Params.put("responseFormat","json"); // note how criteria column is denoted by double-quotes and a value is by single-quotes. m_Params.put("criteria","\"SO ID\"='" + v_SalesOrderID + "'");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
two for the rest of the report. [The second example is what I use most frequently]. Additional: Suppose you have lots of columns, you don't want to have to click on each cell to specify this so just do it to the first column then bring up the properties...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts];...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
('Unable to generate random value'); END UFN_DATASCRAMBLE; Usage SELECT -- UFN_DATASCRAMBLE(DATE_CREATED, 'DATE') scramble_column, -- testing inputted column UFN_DATASCRAMBLE(0123456789012345, 'INT') random_integer, -- testing 16 digit number...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
%ReturnedHTMLTableRows0% { RowIndex++ ReturnedHTMLTableColString:=ReturnedHTMLTableRows%RowIndex% ; split the row into columns StringReplace,ReturnedHTMLTableColString,ReturnedHTMLTableColString, ,|,A IfInString,ReturnedHTMLTableColString,...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
- Parameter: Use Access Levels - Enhancement: AutoDebug: Display module parameters. - Fix Bug: Removed check for "approved" column in weblinks. - Applies to PHP v5.3 or less - Date Uploaded: Fri, 21st Jun 2013 2.2 - Removed popups option - Added...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
(NOTE the "More Options" button) Click on OK to sort the values Note: Office 2010: If items did not sort, then remove the column from the PivotTable altogether, hit the Data Refresh button Add the column back to the "Row Labels" Move the field back into...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
in and out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If you want to remove the...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
then "Parent Group..." Specify the "Group by" (in my case "Day"), the grey part will display a grouping icon Now select the column that has just been created (usually "Group1") by clicking the grey part above it Delete this column. Check that the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
in full; apologies for the mess coding but it's a mix between HTML and autohotkey syntax (note we're making a table with 9 columns and 6 rows - there's a spacing column on either side): htmlText:="" htmlText:=htmlText " " htmlText:=htmlText ""...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
- Added subtext to inform user at each stage of the process. - Added resize capabilities to the program. - Added more column details in the review list. v1.0 (17/05/2010) - Program to cycle through a folder of files to KEEP and check they already exist...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
= Map(); m_CrmFields.put("My_MultiPicklist": l_MyMultiPicklist.toString(",")); // Yields ERROR: Failure, Invalid column value \"Options 2, 3\" specified // i.e. Cannot match picklist option in Creator (Options 2 is split from 3) Solution: In the Creator...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Deals where ((Amount=0) and (Stage != 'Cancelled')) limit " + v_PerPage + " offset " + v_PageOffset; Sort Order: ORDER BY column_name ASC/DESC: v_CoqlQuery = "select id, Deal_Name from Deals where ((Amount=0) and (Stage != 'Cancelled')) order by id...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *