... ,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 ...
... AS YearRun,
COUNT(Catalog.Name) AS Counter
FROM
ExecutionLogStorage
INNER JOIN
Catalog ON ExecutionLogStorage.ReportID = Catalog.ItemID
WHERE
(Catalog.Type = 2)
AND ...
... 300x200, and 1:1 as output 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 ...
... expression as the one we use to get the equipment information:
SELECT
DISTINCT
re.[RoomId]
,re.[SiteId]
,re.[EquipId]
,eq.[Description]
FROM
[ROOMEQUIPMENT] re
INNER ...
... 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] ...
... INNER JOIN `my_old_database`.jos_banner b ON b.catid=c.id
WHERE
c.section='com_banner';
-- -----------------------------------------------------------------------------
-- Step 3) ...
... AS 'Booking 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 ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.