Assuming null is required, the following 67 results were found.
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
of this query for order by) ) AS t1 ) -- Query that will display extracted data SELECT t2.*, CASE WHEN t2.Day=t3.Day THEN NULL ELSE 'Separator Marker' END as 'Marker' FROM tblDifference t2 Left Outer Join tblDifference t3 On t2.RowNumber=t3.RowNumber-1...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
= 0, 1, poi."Quantity") AS "PO Item Tax", poi."Quantity" AS "PO Qty", poi."FCY Tax Amount" AS "PO Line Tax", if_null(pshipping."PO Delivery", 0) AS "PO Total Shipping", if_null(pdiscrepancy."PO Discrepancy Total", 0) AS "PO Total Discrepancy",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
t1 FULL OUTER JOIN [myDB2].[INFORMATION_SCHEMA].[COLUMNS] t2 ON t1.COLUMN_NAME=t2.COLUMN_NAME WHERE t2.COLUMN_NAME IS NULL ORDER BY t1.COLUMN_NAME -- columns in new database but not in old SELECT t2.* FROM [myDB1].[INFORMATION_SCHEMA].[COLUMNS] t1 FULL...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
A really quick article to test when to use isNull and isBlank. Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {......
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
List readFeed(XmlPullParser parser) throws XmlPullParserException, IOException { parser.require(XmlPullParser.START_TAG, null, "rss"); String title = null; String link = null; String date = null; String desc = null; List items = new ArrayList(); while...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
UFN_DATASCRAMBLE ( p_original_value IN VARCHAR2, p_original_datatype IN VARCHAR2, p_original_range_1 IN VARCHAR2 DEFAULT NULL, -- no effect on strings p_original_range_2 IN VARCHAR2 DEFAULT NULL -- no effect on strings ) RETURN VARCHAR2 IS v_char_at...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Days --------------- ------- ------- ------- ------- ------- ------- ------- ------- ----- Me 06:30 08:00 07:30 06:30 07:30 NULL NULL 36:00 4.86 Myself NULL 07:30 07:30 07:30 07:30 NULL NULL 30:00 4.05 I NULL NULL 08:00 08:00 08:00 NULL NULL 24:00 3.24
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Exceptions for text file where I needed two derived column tasks, the first checks if the Date was blank and puts a NULL string. The second takes this string and converts it to a date: -- Assuming EndDate is optional (can be null) and in format...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Reorder Columns in a Tablehttps://joellipman.com/articles/database/reorder-columns-in-a-table.html
it had before the move so I guess this has to be included: ALTER TABLE table_name MODIFY COLUMN misplaced_column BIT(1) NOT NULL DEFAULT b'0' AFTER other_column; -- OR A MORE COMPLETE EXAMPLE -- ALTER TABLE table_name MODIFY COLUMN misplaced_column...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
= 0; public void chooseOrTakePhoto(View view) { final View v = getLayoutInflater().inflate(R.layout.dialog_edititem_photo, null); AlertDialog.Builder b = new AlertDialog.Builder(this); LayoutInflater inflater = this.getLayoutInflater(); b.setView(v);...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
" + v_StripeCustomerKey); // // default to balance due on this Invoice v_AmountToPay = ifnull(invoice.get("balance"),0); // // Get custom Amount to Pay from Invoice l_CustomFields = invoice.get("custom_fields"); if(l_CustomFields.size() > 0) { for each...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
PROCEDURE [Common].[usp_ScrambleMultivalue] ( @TableName VARCHAR(MAX), @ColumnName VARCHAR(MAX), @WhereClause VARCHAR(MAX) = NULL ) AS /***************************************************************************************************************** **...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
string[] exceptionArray_that; // get the value we want to transform string ValueToConvert = p.GetValue(Row, null).ToString(); // PRIMARY transformation: Applies to all words // (lowercases and capitalizes first letter taking into account punctuation...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
// // build the hash based on the payload body v_Data = ifnull(m_Payload.get("body"),""); v_VerifyHash = zoho.encryption.hmacsha256(v_ClientSecret,v_Data,"base64"); // // retrieve Shopify's Hmac SHA256 from the header v_ShopifyHash = "";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the new table `#_categories` where `id` > 7 Add column in #_content just before note called `xreference` VARCHAR(50) allows NULL. Import Content (articles): export SQL file and amend the insert(s) into the new table `#_content` Import Users: export SQL...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
report complains saying "Report #3 parameter cannot be blank!". Before you ask, I have ticked both "Allow Blank" and "Allow NULL". How? This is the tough part. I was reading up on the MSDN page for the closest solution but it still didn't work for me....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
if(r_PackageSlip.get("package") != null) { if(r_PackageSlip.get("package").get("salesorder_id") != null) { v_SalesOrderID = r_PackageSlip.get("package").get("salesorder_id"); } if(r_PackageSlip.get("package").get("shipment_order") != null) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
json_Arg.Start_Date = v_StartDateFormatted; // check if end date is specified and if it is then add to this row v_EndDate = null; v_EndDateValue = ZDK.Page.getField('Actual_Finish_Date').getValue(); if (v_EndDateValue !== null) { var v_LocalEndDate =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
"business_timing": [ "7:00", "18:00" ] }, { "days": "Saturday", "business_timing": [ "09:00", "15:00" ] } ], "daily_timing": null, "week_starts_on": "Monday", "same_as_everyday": false, "id": "123456789000000123456789", "type": "custom" } } Tidied Up...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *