Assuming tables is required, the following 39 results were found.
-
SQL file. (Export > Custom > Save output to file) Except for configuration.php, delete all files in TEST folder. Drop all tables in TEST database. Copy all files from LIVE to TEST (Do not overwrite configuration.php !!!) Copy database from LIVE to TEST...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
"Series1" displays on my chart because of values that are not matched (not assigned to a current individual) in the joining tables: Return to the Design interface (F8) Right-click on your dataset (in my case: DataSet1) Select 'Dataset Properties' Add a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
@ncount:=@ncount+1), we're stuck with T-SQL. Ask Google how to iterate in T-SQL and you're confined to functions, temporary tables or little subroutines which just overcomplicates basic simple select queries... However set a counter to 1 for each and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
if it wasn't provided to start with. Additionally, the second solution will mean each dataset must at least join both tables that you are using the OR clause against. There must be a solution that executes a query at report execution time and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Oracle 10g. The Stored Procedure Rather than a returned dataset, our Stored Procedure updates a field in one of our Oracle tables and returns nothing. It accepts 3 parameters: The StudentID (reference) varchar2, Username (who's running the report)...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the report would say the process failed but when I check the logs, it successfully ran the stored procedure (updating both tables). The Workaround I want to avoid the workaround, because so far my workaround is a fourth report which will do the select...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the full query to your output panel: CREATE PROCEDURE [usp_GenerateSearchbySoundexQuery] ( @p_SearchString VARCHAR(max), @p_TableSchema VARCHAR(max) ) AS...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
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: TABLE: Employee -------------------------------------------------- ID FirstName Surname 1 Joel Lipman 2 Another Joe...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
listed) Enter credentials if necessary and click on "Test Connection" Expand the data connection you just made and expand "Tables" just to see if the connection is working properly. Create the Data Source Still within Business Intelligence Development...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
MediaWiki CMS used by Wikipedia.org and the like. I like queries against this database because it involves linking a lot of tables and outputting... just articles and their titles. I have another table holding the audit trail of content approvers on the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
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 $t_value =...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
and host location... Done! Additional I wouldn't recommend using Oracle SQL Developer. You have to use mostly SQL to create tables and stuff. Recommend to your bosses that you need the MySQL Workbench as this is FREE and with all the features you'd...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
now "created" date. - Enhancement: Included span tags for individual elements. - Enhancement: Using div layers instead of tables. - Fixed Bug: Switched CSS ID tag to CLASS for W3C Validation. - Fixed Bug: Now allows description inline with popup (strips...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for example,...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
The gist: Login to your Joomla database Go to the #__users database table (where #_ is the prefix to your joomla tables) Find the column password and the row of your known user and Copy the text there Find the row of your forgotten user and Paste the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy all the new files to wiki folder and then...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- 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
-
article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written because it...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB