Assuming inner is required, the following 22 results were found.
-
and deductions. This is the parent table which refers to the employee record. SELECT ad.* FROM "Allowances / Deductions" ad INNER JOIN "Employee" e ON ad."Employee" = e."ID" INNER JOIN "Legal Entity" le ON e."Legal Entity (Company)" = le."ID" WHERE...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
Notes', c.[Name] AS 'Contact', c.[Company] AS 'Dept', c.[Phone] AS 'Phone' FROM [CMISdata].[cmisuser].[SLOTDETAILS] sd INNER JOIN [CMISdata].[cmisuser].[TIMETABLE] tt ON tt.[SlotId] = sd.[SlotId] and tt.[SetId] = sd.[SetId] INNER JOIN...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
@new_jos_admin_id AS created_user_id, b.date AS created_time, '*' AS `language` FROM `my_old_database`.jos_categories c INNER JOIN `my_old_database`.jos_banner b ON b.catid=c.id WHERE c.section='com_banner'; --...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
':|joe|:', c.`id`) AS new_name, a.`title`, a.`rules` FROM `v25_db`.`v25_assets` a INNER JOIN `v25_db`.`v25_content` c ON c.`asset_id`=a.`id` WHERE a.`name` LIKE 'com_content.article.%'; -- Articles INSERT INTO `v34_db`.`v34_content` ( `id`, `asset_id`,...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
e.TimeEnd) [Total Time] ,RANK() OVER (ORDER BY e.[TimeStart] DESC) [Rank] FROM [ReportServer].[dbo].[ExecutionLogStorage] e INNER JOIN [ReportServer].[dbo].[Catalog] c ON e.ReportID = c.ItemID WHERE e.[ReportID] = @ReportParameter1 union all SELECT TOP...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
EventFinish, CONVERT(VARCHAR(2), tt.[Status]) AS Status, 'Details and other information' AS Tooltip FROM [SLOTDETAILS] sd INNER JOIN [TIMETABLE] tt ON tt.[SlotId] = sd.[SlotId] and tt.[SetId] = sd.[SetId] INNER JOIN [CONTACT] c ON c.[ContactId] =...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
DATEADD(day, 6, GETDATE()), 103) AS 'WeekEnd', SD.[SetId] AS 'Set' FROM [pretendDatabase].[pretendSchema].[SLOTDETAILS] sd INNER JOIN [pretendDatabase].[pretendSchema].[TIMETABLE] tt ON tt.[SlotId] = sd.[SlotId] and tt.[SetId] = sd.[SetId] INNER JOIN...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
VARCHAR), 3) AS EmployeeNo, RIGHT('000' + CAST(q.Employee AS VARCHAR), 3) + '01' AS QualificationRef FROM Qualifications q INNER JOIN Employee e ON RIGHT('000' + CAST(e.ID AS VARCHAR), 3)=q.Employee -- yields EmployeeNo QualificationRef...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
AS ActivityWeek, CASE COUNT(*) WHEN 1 THEN '(1 Event)' ELSE '(Multiple Events)' END AS DataAccuracy FROM StaffActivities s INNER JOIN Users u ON u.UserID=s.StaffUserID INNER JOIN Resources r ON r.ThisResourceID=s.CategoryID INNER JOIN Teams t ON...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
a slideshow from scratch. How? The idea is: Use two main div layers, I'm going to refer to them as "window_slide" and "inner_window". Slide divs to be added inside the "inner_window". Move the slides in from right to left with a transition. Push...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
the equipment 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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
WeekRun, 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...
- 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
-
THEN 5011 WHEN emp.ContributionValue=3 THEN 5012 ELSE 9999 END FROM [dbo].[DMExtractEmployeeTable] emp INNER JOIN [dbo].[DMExtractReferenceTable] ref ON RIGHT(emp.[PayCode],3) = ref.RefMappedValue AND ref.[RefSheet] = 'myPayrollCategory' AND...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
$start = '(^|)'; $end = '($|)'; return preg_replace( "/$start(.*?)$end/se", "StripSlashes('\\1').". "search_highlight_inner(StripSlashes('\\2'), \$terms_rx).". "StripSlashes('\\3')", $text ); } # highlight terms within search results function...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
thumbnail size formats. v0.2 (29/06/2011) - Resize GUI feature enabled - "Take a picture" now only takes a screenshot of the inner GUI. - Added credits: Sean (ScreenCapture.ahk) v0.1 (28/06/2011) - Added documentation and help 2.0 (auto-troubleshoot). -...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
One theoretical way around this could be that I restyle the "::after checked", hide the circle line and somehow style the inner dot to overlay or serve as background on the tab. But that was a bit too much CSS for my head so instead, I'm going to add...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
PageCategory, (SELECT GROUP_CONCAT(TRIM(REPLACE(ccg.GroupName_Friendly, '_', ' '))) FROM custombu_category_restrictions ccr INNER JOIN custombu_category_groups ccg ON ccg.BUKBGroupID=ccr.GroupAllowedID WHERE REPLACE(ccr.CategoryName, ' ', '_') IN...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- 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