T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 tt.[FinishTime] AS 'Finish', sd.[Descrip] AS 'Event Type', sd.[Notes] AS 'Booking Notes', c.[Name] AS 'Contact', CHAR(10)+c.[Owner]+CHAR(10) AS 'Dept', CASE WHEN CHARINDEX('/', c.[Phone]) > 0 THEN REPLACE(REPLACE(c.[Phone], ' ', ''), '/', CHAR(10)) WHEN...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 1234567 jsmith2012 08-MAY-12 sac180786.txt Permissions CREATE PUBLIC SYNONYM sp_get_studentdetails_from_ad FOR base_table_owner.sp_get_studentdetails_from_ad; GRANT EXECUTE ON sp_get_studentdetails_from_ad TO a_more_casual_user; Yay for me So this is...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 credentials in data source) to run this stored procedure. CREATE PUBLIC SYNONYM sp_get_studentdetails_from_ad FOR base_table_owner.sp_get_studentdetails_from_ad; GRANT EXECUTE ON sp_get_studentdetails_from_ad TO my_ssrs_user; Notes: No "SELECT... INTO...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL connected processes as well. Why? For every DBA this is a doddle and doesn't warrant its own article but for those...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 :: what to COPY for files (default is /COPY:DAT). (copyflags : D=Data, A=Attributes, T=Timestamps). (S=Security=NTFS ACLs, O=Owner info, U=aUditing info). /DCOPY:T :: COPY Directory Timestamps. /SEC :: copy files with SECurity (equivalent to...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: en-GB

Zoho Deluge - InvokeConnector and useful snippetshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-invokeconnector-and-useful-snippets.html

23 January 2020 = zoho.crm.getRecords("users"); or a specific user: r_ZohoResponse = zoho.crm.getRecordById("users",r_DealDetails.get("Owner").get("id")); l_MatchingUsers = ifnull(r_ZohoResponse.get("users"),{}); for each r_UserDetails in l_MatchingUsers { info...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 come across forums that are over 10 years old; URLs that were so custom that they didn't apply to you because of the app owner, name, view link name, etc. The fastest way I know how to get to it is to publish the report and right-click on the attachment...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 setup. You will need to give the full path of the custom domain (eg. https://mysubdomain.joellipman.com), I include the app owner and app name. Then you need to give them edit access by doing the following: Go to your Zoho Creator "Access this...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 Location Code if you know it (eg. "GB") Get access to the Shopify Admin Interface: Request access to the Shopify store owner as a developer Login to the Client's Shopify Admin as an invited developer Click on "Apps" > Develop Apps > Create an App Give...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 Integer/Long/Number datatype As the first part of your code, enter the following as code (you'll need to speify your own App Owner and App Name): // // ************************************************** CREATOR...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Amazon Kindle: Send PDFs to your Kindlehttps://www.joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 things might begin to seem a bit complicated in that not many might be aware Amazon allots an email address to every Kindle owner, and that it is unique for every Kindle device. Finding your Kindle email address. That’s assuming you are not aware of...

• Type: Article
• Author: Joel Lipman
• Category: Kindle
• Language: *

Zoho Analytics: Set Up a Widget Displaying Sales Personhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-set-up-widget-displaying-sales-person.html

24 October 2022 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 against a sales person. It adds to the effect on loading the page that a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books: System Values Mapshttps://www.joellipman.com/articles/crm/zoho/zoho-books-system-values-maps.html

07 November 2023 // get sales persons m_SalesPersons = Map(); /* r_SoDetails = zoho.crm.getRecordById("Sales_Orders",p_SoID); v_CRMOwnerID = r_SoDetails.get("Owner").get("id"); v_Filter = "crm_reference_id=" + v_OwnerID; */ // set v_Filter to blank to retrieve all sales...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 in, not_equal, greater_equal, greater_than, less_equal, less_than and between. The supported data types are picklist, id, owner_lookup, user_lookup, lookup, phone, email, date, datetime, text, textarea, integer, currency, decimal and double. You can...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *