Assuming left is required, the following 88 results were found.
-
EventDate = '11:00:00', EventFinish='12:30:00', Status = '2', Tooltip='Some more details' ) SELECT * FROM Times t LEFT OUTER JOIN Events e ON CONVERT(VARCHAR(8) , t.Time, 108) BETWEEN e.EventStart AND DATEADD(minute, -1, e.EventFinish) --Set the maximum...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
clouds on the background of his photoshop file for his website. They were to be positioned in the top right corner with the leftmost tip aligned to the right of a central content section. I separated off the clouds as another div layer, specified the...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html
extracted data SELECT t2.*, CASE WHEN t2.Day=t3.Day THEN NULL ELSE 'Separator Marker' END as 'Marker' FROM tblDifference t2 Left Outer Join tblDifference t3 On t2.RowNumber=t3.RowNumber-1 ORDER BY t2.RowNumber --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
over it and click on the dropdown arrow to its right Select "Manage" in the dropdown menu Select "Data Sources" in the left menu Specify a "custom data source" and test the connection. Ensure unattended system account scheduled to run and email the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
@StringValue VARCHAR(10) SET @StringInput = RTRIM(LTRIM(@StringInput)) WHILE LEN(@StringInput) > 0 BEGIN SET @StringValue = LEFT(@StringInput, ISNULL(NULLIF(CHARINDEX(' ', @StringInput) - 1, -1), LEN(@StringInput))) SET @StringInput =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
solid #ff7058; border-radius: 20px; width: 140px; margin: 10px; } .onoffswitch-inner { display: block; width: 200%; margin-left: -100%; transition: margin 0.3s ease-in 0s; } .onoffswitch-inner:before, .onoffswitch-inner:after { display: block; float:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
AS `image_src`, json_extract(old.`attribs`, '$.spfeatured_image_alt') AS `image_alt` FROM `new_db`.`new_content` AS new LEFT JOIN `old_db`.`old_content` AS old ON new.`id` = old.`id` UPDATE `new_db`.`new_content` AS new LEFT JOIN `old_db`.`old_content`...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
you can force enable them - Go to Control Panel -> System and Security -> System Click on advanced system settings on the left and then performance settings. Under the visual effects tab you should see that the option “ Let windows choose what’s best...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- 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
-
The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html
SUM(DATEDIFF(MILLISECOND, TimeStart, TimeEnd)) [TimeTakenSum] AVG(DATEDIFF(MILLISECOND, TimeStart, TimeEnd)) [TimeTakenAvg] LEFT(CAST(CONVERT(varchar, CAST(SUM(ByteCount) AS money), 1) AS varchar),CHARINDEX('.',CAST(CONVERT(varchar, CAST(SUM(ByteCount)...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
for Do not use Remote Management as I only want to export/import my database: Connected! Now click on Data Export in the left hand panel: In the screen that appears, select your database, specify to export to a Self-Contained File and click on Start...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Windows 7 Enterprise AutoHotkey (see code for AHK version) What? Someone suggested an app that counts the days I have left serving my notice. I thought I'd go one better and have it calculate to the nearest second. I call this latest app "byeBU" and...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
display: table-row; } ol > li:before { content: counters(myCounter, ".") ". "; display: table-cell; position: relative; left:-12px; } li ol > li:before { content: counters(myCounter, ".") " "; position: relative; left:-15px; } DEMO: See my JsFiddle at:...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
in a screen/viewport in pure CSS (no JavaScript allowed). This CSS centers it by its center point rather than the top/bottom/left/right outline. Why? On a mobile, a client's site uses an external page embedded by iframe. When the app within the iframe...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
with access to ZohoDesk Make a note of the workspace name that your ZohoDesk will sync with. Select Data Sources in the left sidebar Add Data Sources > Select Zoho Desk Do "Next" and select the Zoho Desk Portal Ensure that "Tickets" is selected (I'd...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
http://www.gravatar.com/my-picture), Go to your SharePoint site Click on the “People and Groups” link at the bottom of the left menu Click on the “All People” link at the top of the left menu Find yourself in the list by using the iccle arrow next to...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
smartphones and tablets. Why? Feed back was that the user was unimpressed with the image slideshow. You have to tap on the left and right symbols... How? Some will suggest to load the jQueryMobile library but that started messing up the template layouts...
- Type: Article
- Author: Joel Lipman
- Category: Bootstrap
- Language: *
-
code (below) For this website template: I've added the module-dark classes. Specified float:none to get rid of float:left Specified width of readon-wrap1 to the width of the button Specified margin:0 auto to center readon-wrap1 Original Code: New Code:
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
part of your database. In my example, the team members could have changed and that a person doing most of the jobs suddenly left or moved to another team. To exclude the rest and only show "Series1" Took me a while to figure this out but modify the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
your main Start menu button) As soon as it loads, press DEL to enter the BIOS setup. Navigate to the "Boot" section with the left & right arrow keys Press "Enter" on Boot device priority Press "Enter" on the first boot device Select "CDROM" Press "F10"...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF