Assuming table is required, the following 120 results were found.
-
Transact-SQL and MDX expressions" but boy what a mouthful, and it's not really iterating anymore. So it's "SSRS Hide results table if empty" though I will add that if you wanted to put a message instead of hiding the table then following the below will...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
or print format. I have another article for a different client who wants a pretty advanced HTML template (well it's a HTML table with rowspans and the borders need to merge cells). But here we're simply going to use ZohoCreator and its PDF rendering...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
This should give you all the fields that will be pulled from "Goals" and some records with data. Create the Zoho Analytics table Create a blank Excel file / spreadsheet / csv Copy the names of fields you want to store (I'm taking all of it), and paste...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
K2 Items disappearhttps://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html
these pages and the error is at a foreach() line where it's pulling data from the database. I asked to see the jos_k2_items table and it returned the following error: #145 - Table './jos_k2_items' is marked as crashed and should be repaired The Quick...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
What? 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. Why? I have a table that has all the days of sickness of employees. This table contains, which employee, on what date, and for...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
A data type reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. For example, a comment of 500 words should only...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
A quick article to document 2 features in deluge code: a custom related list in ZohoBooks, and a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have a client who uses their purchase orders and sales orders as part...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
a column that's different. So for example, I have data like the following: SELECT DATENAME(dw, StartDate) AS 'Day' FROM Timetable ORDER BY StartDate ASC, AnotherOrderByCol ASC, AndAnotherOrderByCol ASC -- Yields /* Day ---------------- Monday Monday...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
IF OBJECT_ID ( '[Common].[ufn_MyFunction]', 'FN' ) IS NOT NULL DROP FUNCTION [Common].[ufn_MyFunction]; GO -- drop a user table if it exists IF OBJECT_ID ( '[dbo].[myUserTable]', 'U' ) IS NOT NULL DROP TABLE [dbo].[myUserTable]; GO Types for sys.objects...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
to block any character that isn't a letter, a number or an underscore. How? Suppose the following exists as a MySQL database table called my_table_name: What we have: /----------|-------------------|----------------------\ | id | name | url_alias |...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- 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
-
here to remind me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02 myproduct3 TEST03 I'm trying to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
installation wizard. Data Migration using SQL files: Import Categories: export SQL file and amend the insert(s) into the new table `#_categories` where `id` > 7 Add column in #_content just before note called `xreference` VARCHAR(50) allows NULL. Import...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
with collation to 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...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
lists the different datatypes, is_nullable, maxlength and collations side-by-side: -- all columns side by side SELECT t1.TABLE_CATALOG AS [DB1_Name], t2.TABLE_CATALOG AS [DB2_Name], t1.TABLE_NAME AS [DB1_Table], t2.TABLE_NAME AS [DB2_Table],...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
standard SQL we can combine the contents of two tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a UNION...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
so that you could have your own country lookup script. The Download Should contain the following: create_countriesipranges_table.sql: SQL to create a pre-populated table into a MySQL database. iana_ipv4_address_space_registry.csv: comma separated values...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
$result = $db->query(); INSERT using JDatabaseDriver Here's an alternative method to add a record to a table in Joomla: // Create and populate an object. $user_record = new stdClass(); $user_record->name = 'Joel'; $user_record->username = 'jlipman'; //...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
scrambled data (see my articles on DataJumble and DataScramble). How? CREATE PROCEDURE [Common].[usp_ScrambleMultivalue] ( @TableName VARCHAR(MAX), @ColumnName VARCHAR(MAX), @WhereClause VARCHAR(MAX) = NULL ) AS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *