Assuming table is required, the following 120 results were found.
-
design but the functionality is there. Adding Events Again I've put two rooms as examples in the above script. The "Events" table needs as a minimum the 4 fields "Room", "EventStart", "EventFinish", and "Status" ("Tooltip" was for me so that when the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
I need to change it to a conditional query with the OR statement below: Lets take the following query as an example: SELECT table1.studentID , table2.studentUsername FROM table1, table2 WHERE table1.studentID = capd_table2.studentID AND (...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
affected the reports' performance. What? What I'm trying to do is display a set of results (comparing various reports) in a table and then to color the backgrounds based on whether they are the fastest or slowest in the set. Something like: The DataSet...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
events were hard-coded into the script. I was asked to replace these with events from an actual database. So I just need a table returned with the "EventDate" and the "Note" variables from the other database. If I use the hard-coded examples above, I...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
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? So where does the 'B110' string come from, well...
- 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
-
ID of the student, and then to use this number in a second query which we're hoping will be quicker than a straightforward table join. Syntax CREATE [OR REPLACE] PROCEDURE stored_procedure_name [ (parameter [,parameter]) ] IS | AS [declaration_section]...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
database... ActivityLog...contains activity, staffID, resourceID, 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...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
year for referencing by staff/students. How? Let us assume that we have a system holding a calendar in the following table (called "joes_weekstructure"): ID AcademicSet WeekNumber StartDate --------- ----------------- --------------- ------------------...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your column): SELECT SUM(`total_count`) as `total`, `value` FROM ( SELECT count(*) AS...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
If however, for some reason the code does not exist the code lookup will fail: -- If CODE=0000 and 0000 does not exist in table to lookup name, -- Using &G[COD.SRS:•|•] -- yields: -- But if CODE is not populated, -- Using &G[COD.SRS:•|•] -- also yields:...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- 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
-
for efficiency and comfort in the working environment." So it's pretty important not to be slouching over the coffee table for hours or days on end. I was waiting to move house during 2020 but then a virus capable of locking down the world manifested...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product line items would then print on the second page, with the terms and conditions...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
configuration.php file prior to Joomla! v1.6.x but in the database. Open the database to the Joomla 1.5.x website Browse the table "jos_components" (or "#__components" where "#_" is the site table prefix. default is "jos"). Open the row where name="User...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
fact, this is just a quick list of some regular commands in MySQL that I need in Oracle: Objective MySQL Oracle - See if a table exists SHOW TABLES Select table_name from sys.dba_tables - Return a specific number of rows SELECT * FROM table1 LIMIT 0, 10...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows in a table. This is for Oracle PL/SQL. My List: 1, 2, 3, 4, 5, 6 Yields: 1,2,3,4,5,6 Using this snippet SELECT EXTRACT (VALUE (d),...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
convert a given SQL date to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table WHERE my_id='$this_id'"), 0, "my_date_field"); $this_date_array=explode("-", trim(substr($this_date, 0, strpos($this_date,...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
looking for... always difficult. After a cup of tea the solution was glaringly obvious, just do a primary school mathematics table and it all makes sense (see my 10 mod table below). This article is a quick note (so I never spend as long again) in PHP...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
is the code 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