How to Display Report Execution Time in SQL Server Reporting Services 2008 R2
So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular ...
My setup
Windows XP SP3
MS SQL Server Management Studio 2008
SQL Server 2008 R2
Regional Setting: London BST (British Summer Time)
Tuesday the 11th of October 2011 at 06:00am:
CONVERT(CHAR(19), ...
Quick tip or note to self:
How to get yesterday's date irrespective of date format or daylight savings time.
$today=date("Y-m-d");
$yesterday = date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") ...
Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't ...
... We have no intention of creating a new record per file... Saying that, the file name will change every time it is updated as you will see. Also note, I have a form called "Document", a report called ...
... module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user tries to save the ...
... a data table in ZohoAnalytics to hold the attachments
Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created Time, Modified Time
Add a dummy row with ...
What?
An example of code using the new API call "Module Record Count" with some criteria.
Why?
At time of print, I couldn't find an example of how to use this API call with search filters or criteria. ...
... extras
Just making a list of things that at-time-of-print of this article aren't in the official Zoho documentation:
Query the documents folder
r_MyDocuments = invokeurl
[
url: "https://www.zohoapis.com/books/v3/documents?organization_id=123456789"
type: ...
... from a public domain, no user wall. The key here which the official documentation is missing is the .setParamName() but for those who have spent time to find this function, they'll already know this.
...
... that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit.
Why?
My use-case is that I need this done over a dataset of 20k+ contact records ...
What?
A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday.
Why?
I think it's the US system which generally says that a week starts on a ...
... about 4 months until I can confirm this works.
Why?
I've covered this before in a fair few articles on this website but for clients in the US, where there could be 4 different timezones between customer, ...
What?
A super quick article on resolving this issue if it ever appears again.
Why?
At time of print, this error was happening to schedules in Zoho Books, Zoho Inventory, and Zoho Subscriptions. ...
... the following instructions to these instead.
ZohoCRM: Get Details as Zoho User
The values are the same for the CRM app for all organizations, but in case these change since time-of-print of this ...
... if shipped time is specified.
- Only marks shipment as delivered if DHL API checked and status returned is delivered
Date Modified: 2023-03-22 (Joel Lipman)
- On creation of Sales Order, ...
... = Map();
l_DaysCorrectOrder = m_OrgDetails.get("business_days");
for each v_Day in l_DaysCorrectOrder
{
m_ShiftBuildUp.put(v_Day, m_ShiftRow);
}
//
// ok let's get the opening times
if(m_OrgDetails.get("custom_timing" ...
... Ask ChatGPT - Context Handler Function
Trigger: Function executed in ZIA chat when "Ask ChatGPT" button is clicked
Purpose: This will query the OpenAI ChatGPT API but at the same time retain ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.