Assuming separate is required, the following 42 results were found.
-
This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
both on popup and email which repeats every day until an end date. We then carry out the last bit of the brief with a separate workflow that runs exactly 4 days after the lead creation time and assigns it to the specified user (full name of user was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
you don't already have it in your Outlook 2007. Similar to you opening a shared calendar, the sharepoint calendar will sit separate to the others. Once it's in your Outlook, you can copy over events. The calendar is separate to your own and to other...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
my Windows browser (I wanted IE7 and the other 2 as standalones but apparently not possible) and then have IE6 and IE7 as separate browsers. If I was at home I'd just use Virtual PC with Windows7 but my customers are on XP and I have to emulate their...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
in the below script to the ones you use!!! -- SKIP MIGRATION: -- -- Each section was written so that it could be migrated separate to the rest. -- -- It is recommended to skip the menu migration and to do this manually. -- -- This script was initially...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Example #2: Using as a Custom Script Component The above will work as a SSIS Script task. At work however, we needed to separate it out so that it could be used in other SSIS packages. If we included an SSIS Script in each package, any change to the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Explain every incremental change will render design less elegant and consistent Ask client to go over documentation (separate technical from layman)
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
$color = array_shift($colors); $temp[] = search_highlight_do($term_html, $color); } return search_pretty_terms($temp); } # separate function for dealing with apostrophes (injection?) function search_final_clean($terms) { $out = array(); foreach($terms...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
it. [Test2 Room] will both appear as a row and have 3 slots taken up (if you left the above to 30 minute slots). Tweaks Separate the field @GivenDate off into an SSRS parameter (note do not declare it in the SQL code if using as a parameter). You could...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
though i had clear:both on the css for my #right div layer). For some reason, it has a more forceful effect in its own separate layer. In a joomla CMS template though, I wanted the "left" div to take over the whole page if there were no modules...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
(something like "000065.bmp"). It won't overwrite existing pictures. If you are batch processing a text file, you need to separate the website address and the given name with a pipe character ("|" - see "TEXT file example" mentioned earlier). It ignores...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
based on User level --- Free-Text Changelog or Auto-generate - Added Admin Section: Manage Files (each version is a separate file) --- Filename (as it is on disk) --- Title (friendly title of this download) --- Version (to override auto-versioning) ---...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
List MediaWiki Articleshttps://joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html
My custom query To list access levels (this needs to check categories with access levels table), I have a separate table containing the wiki categories associated with local wiki groups (required to view the category): Page ID, Title, Content, Category,...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
The DBA responsible for the system asked me to look at ways of reducing the load on the server and the solution was to separate both tables (activities and users) rather than trying to join these, and to let PHP do a bit more of the work: User Query...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
counts of records per staging database ** ** table that contains a specific value. ** ** NOTE: This script can be run separate to a stored procedure by ** ** declaring @p_Value and @p_Column and using only the code ** ** from the BEGIN to the END...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html
License gives no permission to license the work in any other way, but it does not invalidate such permission if you have separately received it. d) If the work has interactive user interfaces, each must display Appropriate Legal Notices; however, if the...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
'Date' TRIM(Date) != "" ? TRIM(Date) : "00000000" -- Derived column task 2: Add as new Column 'DC_Date' -- (note this is a separate task in the data flow to the previous one): (ISNULL(Date) || (TRIM(Date) == "00000000")) ? NULL(DT_DBTIMESTAMP) :...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
A quick article on if you were given a webpage coded in HTML, what methods in AutoHotkey could you use to separate out the HTML Tables into a ListView. Why? I want a snippet of code that replicates any HTML table. How? I've been trying various ways so...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
the tags: Use PHP or JavaScript (avoiding Framework conflicts) You select what words are highlighted what color. Uses separate CSS file for overall look. This is still in development! Currently this plugin is mostly hard-coded and most of the parameters...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
the Carriage Return (CR) or Line Feeds (LF) are being inserted, simply extract the entire row as a column and trim it. I separate out the first column as my index/key field so I can check if this is a valid data row (the blank ones may return special...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB