Assuming column is required, the following 98 results were found.
-
If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). All SQL -- Add a column to an existing table (giving...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
DECLARE @mySearchString varchar(50); SET @mySearchString = 'dnya'; DECLARE MyCursor CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column1 FROM ' + (TABLE_SCHEMA + '.' + TABLE_NAME) + ' WHERE SOUNDEX(' + COLUMN_NAME +...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column that's different. So for example, I have data like the following: SELECT DATENAME(dw, StartDate) AS 'Day' FROM Timetable ORDER...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases and you have their full schemas. Use a comparison tool to compare the outputs. Method...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel stop understanding what a NUMBER was? I...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
scenario is that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
named "Profile 1", "Profile 2", etc. Scan the preferences file for JSON key "name" and extract value. Hide the first column in the list view (contains "Profile 1", "Profile 2",...) Sort the second column (contains "Joes Personal Profile", "Joes Work...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
new Object(); // get some values beforehand which allows us to compare to the rows already present in the subform // first column to add in this row is start date (retrieved from field "Actual Start Date" on this record) var v_StartDateValue =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
. '=42') ->order('date_modified ASC'); Single Value Result This type of query is for when you want just one value from one column and one particular row. $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('email')...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM GENERAL DOGSBODY...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
any day. I use this quite a lot so I thought I'd put an article here somewhere. Based on the following concept: RowID column_to_return_as_string --------- -------------------------- 1 Me 2 Myself 3 I -- to be returned as RowID my_field_name ---------...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
scan for files. The 3rd button simply reloads the app (used mostly for testing/development). Lastly, a listview that has 2 columns: the 1st lists the files in that directory, the 2nd displays the new filenames of the files. ; ; Language: English ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
in your line items, alongside the product name, list price, quantity, tax, etc. In the example below, we have added a column called "Group Name" in the CRM Quote module as per the following screenshot: How? Again at the time of this article, this is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
in the FTP details as per your configuration, then click on "Next": Step 2 of 2: specify whether first row are headers/column/field names. If necessary, specify the format of the data per column (in this example, I highlight the Date column, it then...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
info r_Analytics; // // add to analytics m_Header = Map(); m_Header.put("ZANALYTICS-ORGID",v_AnalyticsOrgID); m_Columns = Map(); m_Columns.put("columns", m_Data); m_Params = Map(); m_Params.put("CONFIG", m_Columns.toString()); // // in analytics, browse...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours only...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *