Split a row into multiple rows based on a column value
This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table.
Knowledge base / Since 1999
Scripts, systems & field notes.
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search342 entries / matching Data
Clear filters
Modifying columns in a table
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 it datatype char(2) and allowing NULL) ALTER TABLE myTable ADD myCol...
Reorder Columns in a Table
Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns Method: phpMyAdmin So in the phpMyAdmin interface, apparently, you can d...
T-SQL concatenate an incremental row number
This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist:
T-SQL Conversion failed when converting the varchar to data type int
A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How?
Improve Default Joomla Search
So I can't stand the way the default "Search" component in Joomla works. The default is to sort the results by popularity (hits) or by most recently added (depending on your version) which I have never seen in any other system. I've googled and binged but could not find anything that documents how to bring it into line...
SSIS Skip Blank Rows in Flat File Source
This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "MyDerivedColumns" (4228)" failed because...
MS Excel - Sort pivottable column headings by date
This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top.
SSIS Skip Rows in Excel Source file
A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource.
Loading more notes...
No more notes to load.