Assuming join is required, the following 42 results were found.
-
resort to a query when I get confused with the GUI: Query 1 Due to the limit of sub-query levels we can go down, I want to join this to the contacts data table. So I'm going to make this first query and save it as "Contacts vs Campaigns Pivot": SELECT *...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
information: SELECT DISTINCT re.[RoomId] ,re.[SiteId] ,re.[EquipId] ,eq.[Description] FROM [ROOMEQUIPMENT] re INNER JOIN [EQUIPMENT] eq ON eq.EquipId=re.EquipId WHERE re.RoomId=@GivenRoom AND re.SetId=@setId This seems to have problems because when...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
DATEPART(year, ExecutionLogStorage.TimeStart) AS YearRun, COUNT(Catalog.Name) AS Counter FROM ExecutionLogStorage INNER JOIN Catalog ON ExecutionLogStorage.ReportID = Catalog.ItemID WHERE (Catalog.Type = 2) AND (ExecutionLogStorage.TimeStart BETWEEN...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
,a.[TimeRendering] ,a.[Source] ,a.[Status] ,a.[ByteCount] ,a.[RowCount] FROM [ReportServer].[dbo].[ExecutionLog] a INNER JOIN [ReportServer].[dbo].[Catalog] b ON a.ReportID = b.ItemID The Top 5 Most Frequent -- Top 5 Most Frequent: SELECT TOP 5...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
USING latin1) AS PageTitle, CONVERT(wikimedia_text.old_text USING latin1) AS PageContent FROM wikimedia_page LEFT JOIN ( wikimedia_revision, wikimedia_text) ON wikimedia_page.page_latest=wikimedia_revision.rev_id WHERE wikimedia_page.page_namespace=0...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
version of this query was pretty abysmal and worse if you want to list users who have no associated activities (outer join but all-in-one query). The DBA responsible for the system asked me to look at ways of reducing the load on the server and the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
to login if email not specified - [1.8.0] Factory: 7 random aircraft - [1.8.0] Factory: disabled if offline - [1.8.0] Pilot: join/login auto-selects email - [1.8.0] Pilot: profile page with preferences - [1.8.0] Start: fetches current lat/lng - [1.8.0]...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
{ v_LastName = v_LastName.replaceAllIgnoreCase(v_Exception, v_Exception, false); } v_LastName = v_LastName.trim(); // // join all together v_FullName = trim(v_FirstName + " " + v_LastName); info v_FullName; // // yields: Billie-Jo McDonald-O'Leary II of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
'u.username', 'u.real_name'))); $query->from($db->quoteName('#__user_profiles p')); $query->join('INNER', $db->quoteName('#__users', 'u') . ' ON (' . $db->quoteName('u.id') . ' = ' . $db->quoteName('p.user_id') . ')')...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
appearing in your SQL Server Reporting Service (SSRS) report. I am guessing that Series1 is the data series from an outer join where the joining index value is null. The chart below has 3 series or data fields: Count the total number of incidents logged...
- 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
-
TOP 1 c.Name, e.TimeStart, e.TimeDataRetrieval + e.TimeProcessing + e.TimeRendering AS TotalTime FROM [ExecutionLog] e INNER JOIN [Catalog] c ON c.ItemID=e.ReportID WHERE c.Name='My Amazing Report' -- just change the value here to the name of your...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
'DD-MON-YYYY')) || ')' "p_STUDENT_DETAILS", NVL(a.student_id, b.person_id) "p_STUDENT_REF" FROM student_accounts a INNER JOIN student_details b ON a.student_id = b.person_id WHERE a.student_id = p_STUDENT_REF; -- ending that second begin I had after my...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
--event details to display e.Note --CTEs defined above are used as the queries for the results FROM Dates d LEFT JOIN Events e ON CAST(CONVERT(VARCHAR(10),e.EventDate,101) AS DATETIME) = d.[Date] --Set the maximum times the Dates cte can recurse OPTION...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
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] BEGIN...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
a WHERE YEAR(a.DateTimeStamp)='2010' GROUP BY a.VisitorIP ORDER BY MAX(a.VisitorID) DESC ) t1 LEFT OUTER JOIN wikimedia_user b ON t1.ID=b.user_id GROUP BY t1.IP ORDER BY b.user_name ) t2 GROUP BY MONTH(t2.Date); Notes: I use this in a PHP script so...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
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
-
'//text()'), ' ', n.n), ' ', -1) `value` FROM `mydbprefix_content` t CROSS JOIN ( SELECT a.N + b.N * 10 + 1 n FROM (SELECT 0 AS N UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
two spaces, then we want the field to understand this as "no one entered anything", treat it as empty. this.value.split(' ').join('') -- split this value into an array separated by the delimiter character "" -- join this array back replacing any spaces...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: en-GB
-
attached to Phantom and power cable pulled further out (perhaps a bit too much) 3 plugs in. It came with heat shrinks to join the power cables but I may change this to a plug later. Hmm... maybe I should have painted my Phantom in chrome. My DJI Phantom...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *