Assuming almost is required, the following 23 results were found.
-
AS VARCHAR), 3)=q.Employee -- yields EmployeeNo QualificationRef -------------------------------- 001 00101 001 00101 Almost useful... but the qualification reference has to be unique. We're going to add the ROW_NUMBER() to the employee number to create...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
system AMCharts.com. AMCharts.com provide a flash-based interactive chart which you can zoom in and out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
and to convert images. Autohotkey (my favourite automation tool) to combine the two into an executable and interface (almost as quick as google's chrome :c). Version 0.6 beta is ready. I've left it in BETA stage without an official release because I'm...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
to 244 F4 U+2320 ⌠ top half integral 245 F5 U+2321 ⌡ bottom half integral 246 F6 U+00F7 ÷ division sign 247 F7 U+2248 ≈ almost equal to 248 F8 U+00B0 ° degree sign 249 F9 U+2219 ∙ bullet operator 250 FA U+00B7 · middle dot 251 FB U+221A √ square root...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
my second select query (the one preceded with "open cursor for") didn't match my SSRS report field name mapping. Done! Well almost as you still need to design your report. At least this article should have got you to the part where you're simply...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
work. They even add a note to say that Joomla 1.6 uses a different version of Mootools and handles forms differently. Demo Almost forgot this, you can view my example at:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
the all important clear button. What I found was that no one posted this solution which I found is compatible with almost any site and with all my components without having to modify the below script. Why? The article modal is a much easier way for the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
SUBSTRING(@Haystack, LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)), LEN(@Haystack)) -- yields "3.String4" Almost there, counting backwards and forwards it seems the index is just two characters off (as I don't want to include the period):...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
in nearly all cases, is to use the "conditional split" task and test one of the columns for a length of greater than 1: Almost! A problem not covered by many sites was happening to me when I had blank rows in a flat file, where it appeared to add the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
If you have more than 999 items in the column, then you may need to increment the 3 in the above statement "LEFT(..., 3)". Almost there, but in the above example, the dates are wrong for subsequent days off sick: SELECT EmployeeNo , DaysOffSick ,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
should be prompted to convert to use gold characters: Test the XET export and you should get something like: 5826|England Almost! If the code and it's short name/full name exist in the database, this works accordingly. If however, for some reason the...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
how much time is left before another access token will be generated and how long ago was the last token created. How? So almost pure JS. I'm working out the seconds remaining and seconds elapsed in PHP first then passing these as two variables to the...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
are grouped into the one desktop. If you have a multiple monitor setup (ie. more than 1 monitor), then MS Windows will almost remember which apps were open on which screen but always on Desktop 1. In addition, there are some developments on AutoHotkey...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
data","status":"error"} Solution: The above ALMOST works for API and Deluge Shortcode, but we're missing the colon in the TimeZone value: v_TimeZone = zoho.currentdate.toString("Z"); v_TimeZoneStr = v_TimeZone.substring(0,3) + ":" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
show Tab_Section_6; } else if(input.Tabs == "eBay Preview") { show Tab_Section_7; } else { show Tab_Section_1; } Done! Well almost Set Clicked Tab to Selected One niggling issue I had was that when selecting a tab, the selected tab didn't stay a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
title handle } updatedAt } } } } I found this is the same as the inventoryQuantity so might as well reduce those costs (by almost a half!). Source(s): Shopify Partners - How to Generate a Shopify Access Token (legacy) Shopify Community - API To Search...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_ScheduleMeeting.put("Owner",123456789012345678); // // related to what (in this example, a lead record but can be almost any kind of record) m_ScheduleMeeting.put("What_Id",98765432109876543); // // the subject...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
again, I'm only trying to list ones that produced the desired effect: Famous Shows in the style of... Note that these are almost definitely infringing on copyright/intellectual property and should not be used in a commercial setting. {module title="Joel...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file given some lists and strings and although the same code worked...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
bring up the invoie in ZohoBooks, click on the button, and the Stripe terminal will ask for the amount on the invoice. Well almost. We've gone the extra step in that we added a custom field that can override the full balance, to allow partial payments...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF