Assuming columns is required, the following 52 results were found.
-
table with this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column widths match. How? I've adapted my real working product with an example. As my work was for a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
= 'Lansdowne Campus' SET @specifiedDate = (SELECT @GivenDate) SET @specifiedCampus = (SELECT @GivenCampus) -- Get columns SetId and WeekNumber from the weekstructure table based on the given date SET @setId = (SELECT TOP 1 SetId FROM WEEKSTRUCTURE WHERE...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I want to convert a start and end date to a single time value (hours minutes seconds mseconds) I want to total 3 of the columns (which measure in milliseconds) and convert to a time value with milliseconds showing. Now why don't these match? Using in an...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
** Example: ** ** EXEC [usp_GenerateSearchbySoundexQuery] 'Not Available', 'dbo'; ** ** ** ** Return Values : Table of two columns: ** ** - Value: Your search term and matching variations ** ** - Source: The table_name.column_name it found this value...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
(eg. Customer_ID) ** ** - Column: the column name which will contain this value. ** ** ** ** Return Values : Table of three columns: ** ** - myValue: value specified in parameter 1 (matched in database to search) ** ** - myTable: table in which the...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts];...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
start time, end time... Report Specification PivotTable Report...resources in row (along the side)......staff in columns (along the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Stick to the Bottom of the Page Aim: Header Left Right Footer Situation The header displayed fine. The left and right columns finally got them side by side. But the footer that has a background image was under the left and right columns... The main...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
%ReturnedHTMLTableRows0% { RowIndex++ ReturnedHTMLTableColString:=ReturnedHTMLTableRows%RowIndex% ; split the row into columns StringReplace,ReturnedHTMLTableColString,ReturnedHTMLTableColString, ,|,A IfInString,ReturnedHTMLTableColString,...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why? Consider the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
Typographyhttps://joellipman.com/articles/else/e-commerce/woocommerce/typography.html
at the coast of the Semantics, a large language ocean. A small river named Queequeg flows by their place and supplies. Columns 1/2 Сolumn A wonderful serenity has taken possession of my entire soul, like these sweet mornings of spring which I enjoy with...
- Type: Article
- Category: Uncategorised
- Language: *
-
in full; apologies for the mess coding but it's a mix between HTML and autohotkey syntax (note we're making a table with 9 columns and 6 rows - there's a spacing column on either side): htmlText:="" htmlText:=htmlText " " htmlText:=htmlText ""...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
on the attachment to see what the link should be: Ensure a report exists with your form and that one of the fields/columns viewable is the file upload or attachment field In Zoho Creator, in the "Edit" mode, go to "Settings" Under "Users and Control"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
I have quite a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name, and ID. What I want is a HTML table now with the headers and data but without using a for loop. What...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
addresses which in turn contained commas. Saving this as a CSV and asking Deluge to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
+ " "; input.Note_Attachments = v_NoteAttachments; Here's the code at the end of the parent form to hide the columns I don't need the user to see (I'll populate these by code): hide Attachments.Parent_Record; hide Attachments.Document_Name; hide...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
every employee's record. My employee record form is called "Staff" and the subform is called "Usual Shift" containing the columns "Day", "Start Time", and "End Time": // // select applicable staff l_ApplicableStaff = Staff[ID != 0]; for each c_Employee...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
text, textarea, integer, currency, decimal and double. You can search for a maximum of 10 criteria (with same or different columns) with equals and starts_with conditions. The only operator that is supported for encrypted fields is equals. When you use...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
me synchronize every hour. Then I'll write the SQL queries to get the individual responses into a table with labels and columns that can help me group them (and identify which responses belong to which survey attempts). Then I'll write the SQL to sum up...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
of db->query() $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->insert($db->quoteName('#__my_users')) ->columns(array('name', 'username')) ->values(implode(',', array($db->quote('Joe'), $db->quote('jlipman')) )); $db->setQuery($query);...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB