Assuming trick is required, the following 17 results were found.
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
article with the 3 stages can be a little confusing. When I wrote the support documentation which makes use of this little trick for my managers, I explained it as displayed in the following image (apologies for the image but it's still clear as mud in...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
WHERE column1='this_article' Combined with a PHP script this could be a few lines for something really small. The quick trick to this is to do it all in one query: UPDATE table1 SET counter_field_value=counter_field_value+1 WHERE column1='this_article'
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
services are not meant for transactions between strangers. In our experience they’re favoured by fraudsters. One popular trick is to ask you to prove that you have funds by sending money to a friend or relative via these services and show them the...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
an answer, then I just replaced "=NOW()" [yields: 01/01/2011 01:00:00] with "=Today()" [yields: 01/01/2011] and this did the trick. English Ordinal Suffix in T-SQL for MDX Working in the UK my bosses like the English Ordinal Suffix. I haven't seen this...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
that we were trying to execute our stored procedure with the parameters specified just after the name of the procedure. The trick is not to use any of these and to use the GUI dialog of the "Dataset Properties" for that stored procedure. The variable...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
systems can even send the login credentials to the remote machine for you, but does this just open another can of worms? The trick in my opinion is a memory aid. How to use Type a word in the input field and check the "Rule Abiding" variation as a...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
stock. How? So editing the product_details field of an invoice record seems straightforward but it isn't. Undocumented, the trick is to remove the existing ID of the line item and posting the map back to the record. In the following example, we are...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to Zoho Support... And then I started updating multiple fields at the same time. How? Through sweat and perseverance. The trick is to update both the sales order id and to update the invoice line items with their respective sales order item id value....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
and going through the online discussion forums to build this solution. As of May 2020, this is how I do it. How? So the trick is, go over the official documentation, but don't take it as gospel. You only really need the syntax for attaching a document...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
majority of the documentation doesn't refer to OAuth 2.0/json and instead uses the deprecated authtoken v1 and XML. How? The trick in this solution was more about the process and what that process was. Reading the brief, and having written many custom...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
their CRM; I then need the customer from the customer portal in a ZohoCreator app to be able to download this file. How? The trick to doing this is that actually you have to treat it as an attachment. As you may already know, when you queried CRM for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
So this is more of an annoyance then an impossible task... because it is possible, the technique above is simply wrong. The trick and solution is a lot simpler than you might think... Doing the above, I would get a really messy response (I'm targeting...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
that value with a timezone, several calculations happen in real-time making it really difficult to extract and use. The key trick I used was to actually use a single-line text to store the customer's requested time. Let's use the appointment example...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
ran: Balance: " + v_BalanceDue + " Customer Payments: " + r_SearchResults + " Invoice Update" + r_UpdateInvoice ] The trick is all in the workflow settings. This worked for us but may not work for you or may be already working for you without this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts it to a list, then lets you generate an array or list of any...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
if a synchronization process starts to fail, there should be images or icons warning or advising of failures. How? The key trick to use here the ability for Zoho Analytics to display different images based on a criteria or a value within a data table....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
} // yields an incremental count from 0 to 4999 Observation #2: Setting a loop with leftpad limited to 100,000: Our trick of using the leftpad() method to build a list of any number is actually limited to 100000 as you will get an error saying: "Unable...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF