Assuming times is required, the following 50 results were found.
-
@GivenDate + ' 08:00:00'; --Last slot of the day (30 minutes before the end) SET @EndTime = @GivenDate + ' 17:30:00'; ; WITH Times([Time]) AS ( --Select First hour in range SELECT CONVERT(DATETIME,@StartTime) AS [Time] UNION ALL --Add a record for every...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
services. There are websites that do this for me? Yay! for free as well, as long as my page isn't loaded more than 100,000 times a month. I don't understand, one website visitor can generate 1000 hits, so thereafter I have to pay every time someone sees...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
an exact number of occurrences of the preceding character or subexpression. For example, to find where 'a' occurs exactly 5 times, you specify the regular expression: a{5} This expression matches: aaaaa The expression does not match: aaaa Interval...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
/XO -- /E makes Robocopy recursively copy subdirectories, including empty ones. -- /XC excludes existing files with the same timestamp, but different file sizes. -- /XN excludes existing files newer than the copy in the source directory. -- /XO excludes...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
chart of your data (eg. movies, music, etc). My aim is to do the following: retrieve data from a table, count the number of times each data exists, sort it in reverse order so that the most frequent is at the top of the list print out each row with the...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
of this rule. No Double Posting or Spamming - You may not post more than once in a row in the same thread. Posting lots of times in a row reduces the quality of the board, is a waste of the board's memory, and provides the culprit with ill earned post...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
description => sort by description date => sort by date added (most recent or oldest first) hits => sort by hits (number of times clicked on) published => obviously by whether they're published or not... no idea why u would checked_out => sort by...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
report (looks like a hexadecimal SSID). It's the unique ID of the report but not unique in the table (can be referenced many times). UserName nvarchar(260) NULL Windows authenticated username and domain of the person running the report (eg....
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
is spent faffing around with design and functionality. We use the ProjectFork extension to manage projects, it helps during times when we can't see face-to-face with colleagues or clients. Startup Meeting For you to discuss: Aims / Objectives Deadlines...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
The Mermaidhttps://www.joellipman.com/component/content/article/the-mermaid.html?catid=96&Itemid=165
skipping up aloft, And the land lubbers lying down below, below, below, And the land lubbers lying down below. Then three times 'round spun our gallant ship, And three times 'round spun she. And the third time 'round they all went down, As she sank to...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
by sinkfaze) Basic Webpage Controls COM Object Reference Last edited by jethrow on Wed Jun 22, 2011 10:18 pm; edited 22 times in total Source: Jethrow @ Autohotkey Forums
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
is using the functions to read data from Zoho CRM and to write data back to the system. Why? I've rewritten this code a few times and want to store the finalized version (following updates) making it as generic as I can in order to apply it to any...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: en-GB
-
to above functions } string generateKidSafeRetrievalCode() { // init v_Output = ""; l_BadWords = {"My","Bad","Words"}; l_TimesTried = {1,2,3,4,5}; // loop through times you will chance it for each v_TimeTried in l_TimesTried { // init b_BadWordFound =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
it later. Why? I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps. How? We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
always recommend locking down your app privileges by checking the scope(s) you have allowed it to have.... However in those times of debugging/testing when you can't seem to access that bit of information Zoho is reluctantly letting you have (such as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
"info": { "count": 200, "more_records": true } } Which isn't what I want because it has returned the same currency several times and thinks they're unique/distinct because the IDs of each quote record are different. Having spoken to Zoho and raised with...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
This is an article to remind me how to calculate various times for an appointment booking system based on the timezones of each party. Why? The use-case scenario is that our Creator server uses the US datacenter but has it's server timezone set to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
A very quick article to document a HTML Entity decoder in Zoho Creator. Why? Sometimes when receiving data from a third-party, we may receive some strings containing "&" or " " and obviously want to display these as decoded HTML entities. (Zoho if...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
behave like this; specifically when there are a lot of line items as per my screenshot here: How? This has been raised a few times by multiple clients but the fix is rather quick as long as you can get to the HTML of the template: Login to ZohoCRM >...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
2 parameters, the first is the string to start with, the second is the number of spaces to pad with. // // set number of times to iterate through loop (plus 1) v_CheckDaysAhead = 7; // // create a string with this many spaces using leftpad...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *