Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming through is required, the following 141 results were found.

  1. SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to recover the data and present...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  2. SSRS Stop Scrolling Behindhttps://joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

    to work out: Open the Report in Design mode. Check that advanced mode is switched on as per the following image: Cycle through each static object and set FixedData to False (ensure all items are set to false or it will error): Save and test on the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  3. Windows 7: System Clock is constantly going out of synchttps://joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    more often. Note: The following process requires administrator (installation) rights on your computer. Open regedit.exe through the start menu search box, and then find this registry key:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  4. Remove write-protect from USB pen in Windowshttps://joellipman.com/component/content/article/remove-write-protect-from-pen-in-windows.html?catid=80&Itemid=165

    The chap went to www.apacer.com which is just where I’ve been trawling through and I have found a utility that actually works on my pen!!! It said “repaired USB pen” and when I go to check the space, my 30Gb has returned!!! It’s called Urescue and it’s...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB

  5. Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    Execstatus = 1 WHERE Tablename = @tmpTblname END SET NOCOUNT OFF GO MySQL Source: http://kedar.nitty-witty.com/blog/search-through-all-databases-tables-columns-in-mysql - Kedar at Nitty-Witty.com ## Procedure for search in all fields of all databases...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  6. Search a database for a value and count matching rowshttps://joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    table to hold results CREATE TABLE #CountRecordsPerTablePerCol (myValue int, myTable varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @TableToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = '...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  7. DataJumble - Shuffling characters in a data valuehttps://joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    VALUE SET @NewVal = SUBSTRING(LTRIM(RTRIM(CAST(@NewVal AS VARCHAR(30)))), 1, LEN(@OrigVal)); END ELSE BEGIN -- Loop through the characters passed WHILE @LoopCt

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  8. Stored Procedure to List Distinct Values and Countshttps://joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    results CREATE TABLE #ListDistinctValuesAndCounts (myValue varchar(max), myColumn varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @ColToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  9. DataScramble - Randomizing data rowshttps://joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

    AS VARCHAR(30)))), 1, LEN(@OrigVal)); END ELSE BEGIN IF ISNUMERIC(@OrigVal)=1 BEGIN SET @NewVal = ''; -- Loop through the characters passed WHILE @LoopCt

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  10. MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    // Our working week starts on Monday 00:00 and ends on Sunday 23:59. Putting it together Your first query should loop through the users list, within the loop run the activities query and replace the string "STRING_TO_REPLACE_PER_ITERATION" with the User...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  11. Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    (eg. PNG to JPG -> means module has to re-download thumbnails into JPG format) - Fixed Bug: Weblink hit counter now works through Joomla! CMS - Date Uploaded: Wed, 13th Jul 2011 1.3.1 - Modified code to work with Joomla! CMS versions 1.5.x - Removed...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *

  12. Stop Excel Row Height Self-Adjust on Refreshhttps://joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    with this change. Note on "row height": We did not want the customer having to format the report after they've already gone through the hassle of clicking on the big fat refresh button... Keeping It Simple Silly. So the suggestion of selecting all cells...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  13. Is it a scam? Gumtree.com's warning signshttps://joellipman.com/component/content/article/is-it-a-scam-gumtreecoms-warning-signs.html?catid=116&Itemid=165

    company and offers buyer protection or an online payment system. This could be directly in connection with a transaction through someone you’ve met online. Or perhaps the buyer or seller suggests you use a payment or protection service from one of these...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *

  14. Amazon Kindle: Send PDFs to your Kindlehttps://joellipman.com/component/content/article/amazon-kindle-send-pdfs-to-your-kindle.html?catid=121&Itemid=165

    to the Kindle, you can read it via the eBook reader as you would any other reading stuff. It’s true you need to go through an initial set-up process which essentially boils down to getting your email ID added to the approved list as well as finding out...

    • Type: Article
    • Author: Joel Lipman
    • Category: Kindle
    • Language: *

  15. Thank You!https://joellipman.com/component/content/article/thank-you.html?catid=50&Itemid=165

    feedback has been successfully submitted and is much appreciated. This filters through to an account which is checked regularly and you should get a quick response.

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *

  16. Zoho Deluge - Get Current User IDhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-current-user-id.html

    This is a quick article on different ways to get the current user ID in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this year). So...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB

  17. Zoho Deluge - Pad with leading Zeroshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-pad-with-leading-zeros.html

    this is probably unwarranted so I may rename this article later to common things I need to do in Zoho Deluge. How? So going through the forums you may find the following example: string padWithLeadingZeros(int finalStringLength, int startingNumber) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB

  18. Zoho CRM: Make Upload File Field Mandatoryhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-make-upload-file-field-mandatory.html

    when I tried using a layout rule. Probably everyone else has figured this out and I'm just late to the party. How? Through the wonders of Zoho CRM Client Script. So we're going to check on page onload, onchange for the Create Page (Standard), Edit Page...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  19. Add "Command prompt from here" to right-click context menuhttps://joellipman.com/component/content/article/add-command-prompt-from-here-to-right-click-context-menu.html?catid=80&Itemid=165

    do this every year as I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I do it: Open up windows explorer Go to Tools ->...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  20. VBScript to retrieve Windows Product Keyhttps://joellipman.com/component/content/article/vbscript-to-retrieve-windows-product-key.html?catid=80&Itemid=165

    I needed the serial number / product key from my Windows 7 Professional 32-bit operating system. I didn't want to dig through my CD/DVDs to find my original windows 7 disc and no longer have access to the email account when I purchased Windows 7 (my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
Results 121 - 140 of 141