Assuming compare is required, the following 22 results were found.
-
to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without having to download any third-party products. Why? I googled and...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This is a quick article to demonstrate how to compare two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would be run as. The time difference was just one hour but this caused...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
details of properties. It was a quicker way of detecting a change on the record rather than comparing all the fields, compare only 1 value which is a hash or MD5 of all the fields of the record that I want to monitor. An eTag for me is simply an MD5 or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
I've recently written a report for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
v_Pages = ceil(v_MaxCount / v_PerPage); info v_Pages; Call with datetime criteria: NB: You can't compare a date time value to a field that is simply of datatype: date v_PerPage = 200; v_CountCriteria = "((Quote_Stage:equals:" + encodeUrl("Draft") +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
} } // // build response to Shopify m_ResponseHeader = Map(); m_ResponseHeader.put("status_code",401); // // compare our hash vs the received hash if(v_VerifyHash == v_ShopifyHash) { m_ResponseHeader.put("status_code",200); } // // respond return...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
a folder) Run Unduplicater.exe (or if you have AutoHotkey installed, run the Unduplicater.ahk file) FUTURE CONSIDERATIONS: Compare the file sizes and delete based on this Specify to ignore EITHER suffix or prefix SCREENSHOTS: MORE DETAILS AS WELL AS...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
detecting? Currently it just reads the size of packets sent and received. This allows me to test websites for example and compare page loads. It's more fun on a networked computer which is constantly writing back and forth to network shares, user...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
is in the US then this should be zohoapis.com. Additional Additional(s): I haven't done any benchmark tests on this to compare but looking at different ways to exclude elements from a list: info l_FieldApiNames; l_FieldApiNames = {"a","b","c","d","e"};...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
{ v_WebhookBodyHMACSHA256 = zoho.encryption.hmacsha256(v_Webhook_Key,m_Payload.get("body")); } // // compare signatures if(v_WebhookBodyHMACSHA256 == v_ShopifySignature) { v_ResponseCode = 200; } m_Response.put("status_code",v_ResponseCode); // // setup...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
and JSON argument var json_Row = new Array(); var json_Arg = new Object(); // get some values beforehand which allows us to compare to the rows already present in the subform // first column to add in this row is start date (retrieved from field "Actual...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
and whatever else you had to import. So go into a listview of the CRM Contacts and select "Deduplicate Contacts", then say compare by email and the foreign key (3rd-party unique ID for that contact). Error(s) Encountered Could not find a matching parent...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
be zero, then for checking if daylight savings is in effect in the UK, we should be able to take Greenwich Mean Time and compare to UTC. b_IsDSTInEffect = if(zoho.currenttime.toString("HH:mm", "UTC") != zoho.currenttime.toString("HH:mm", "GMT"), true,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
workaround exists where if I added the OR part to all my datasets (so where each one says if studentreference is blank then compare to studentadaccount)… Both solutions have the issue where they will return all rows where studentadaccount is blank (this...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
year (the below examples count all accounts irrespective of being activated or not). It needs to pick up trends as well and compare for example todays, with yesterdays up to the same hour. How? I used to use a lot more PHP but since becoming an analyst,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
But what system doesn't do this (no Microsoft jokes please)? The Solution Eureka! Or duh! for those that it's obvious to... Compare the two timestamps, if the "To date" is less than the "From date" then add 1 day to the date: $thisDateSQL=date("Y-m-d",...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
$didyoumean_words_array=array(); // Note: for some systems you can do a levenshtein on two words soundex value and compare these. // Be warned that it does go off track though in terms of relevance... Sources: iamcal.com Nadeau Software
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why? Consider the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
I'm trying to create an ETag for a synchronization process between Zoho Creator and Zoho CRM. Combining all the fields to compare into a single field can't be done via the documented methods (base64, urlencode or AES) as this exceeds 255 characters (it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB