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 next is required, the following 106 results were found.

  1. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    I gave up and just wrote my own. Saying that it's taken me 4 hours just to do the below... hopefully it will be quicker next time now that I noted it all down. The SQL Script: DECLARE @StartTime datetime, @EndTime datetime, @GivenDate datetime; SET...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  2. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    into: I replaced the empty dataset with the message "None" using Method #2 above. I noticed when a textbox is hidden, the next textbox moves to fill up the space... There are some suggestions on the net but they didn't work or didn't apply for me. I had...

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

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

    Note that a footer exists (contains page number) because if printed, the page would end on a dataset row and continue the next page with the rest of the dataset. This footer allows for a large space at the bottom of the page indicating the page number....

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

  4. How to change local folder for TFShttps://www.joellipman.com/component/content/article/how-to-change-local-folder-for-tfs.html?catid=79&Itemid=165

    to your local folder; once done close the dialogs click on the TFS icon in Source Control Explorer and check what it says next to "Local Path" (for me this said the name of the local folder that I specified just before)

    • Type: Article
    • Author: Joel Lipman
    • Category: Team Foundation Server
    • Language: *

  5. Run commands for Windowshttps://www.joellipman.com/component/content/article/run-commands-for-windows.html?catid=80&Itemid=165

    Utility msconfig System File Checker Utility (Scan Immediately) sfc /scannow System File Checker Utility (Scan Once At The Next Boot) sfc /scanonce System File Checker Utility (Scan On Every Boot) sfc /scanboot System File Checker Utility (Return Scan...

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

  6. Administrator Program Shortcut without Prompthttps://www.joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    > Shortcut Type in the task with the format schtasks /run /tn "task-name" schtasks /run /tn "VisualStudio2010" and click on Next Give the shortcut a name to display as (eg. "Visual Studio 2010") Click on OK to complete your shortcut. Additional: You can...

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

  7. Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/else/database/create-read-only-database-user-in-sql-server.html

    Properties. Select User Mapping. Map the login to the database they will have access to. Tick the boxes for role membership next to public and db_datareader. Confirm by clicking OK. You should get something like the following: Database-level role names...

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

  8. Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

    get was An error occurred during local report processing. An error has occurred during report processing. Cannot read the next data row for the dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had...

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

  9. T-SQL Record Separatorhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    character. I just put NULL because I wanted an empty row. My final query This displays all room bookings for today and the next 6 days. Note how I can't use normal dates because the database wasn't designed with timestamps (despite being a timetabling...

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

  10. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    the idea of requiring macros as not all users switch this on and teaching executives on how to do this is tough work. What Next? Permissions on EXCEL filters: Need to control for different levels of management? Could add a WHERE clause to the query so...

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

  11. Some milestones for a website projecthttps://www.joellipman.com/articles/cms/website-development/some-milestones-for-a-website-project.html

    the saleability of the product and technical risk involved in fully developing the website. ALPHA/BETA – these are the next major milestones that represent near completed websites, these are subject to extensive testing, compatibility and QA by both the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  12. Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/cms/website-development/difference-between-two-dates-the-midnight-hour.html

    23:30:00 = -23.00 This is great for everything during that date as long as the "To Date" never goes past midnight into the next day... But what system doesn't do this (no Microsoft jokes please)? The Solution Eureka! Or duh! for those that it's obvious...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  13. Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/cms/website-development/html/parse-a-html-table-into-a-listview.html

    is used for several tables, the Needlemarker tells the function to start from where it last found a table and to find the next: ExtractText( Haystack, Needle1a, Needle1b, Needle2a, NeedleMarker ){ Needle1 := InStr( Haystack, Needle1a, false,...

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

  14. Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/cms/website-development/php/creating-a-top-10-chart-with-less-code.html

    (for sorting purposes - eg. so 10 is not before 2) Store both the formatted count and the value of column1.table in the next array entry Reverse this array Display the first 10 rows of this array (if we are doing a top ten) My new method is: SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *

  15. SITS: Export field code and namehttps://www.joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    |: Select the exchange fields (or container) to apply this to Select the "Export Format" tab and click on the chevrons ("»") next to the field to apply this to Enter the dictionary code, the entity code and then the inner SRL text which should be |, if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *

  16. Pancakeshttps://www.joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165

    - any sort of whisk or even a fork will do - incorporating any bits of flour from around the edge of the bowl as you do so. Next gradually add small quantities of the milk and water mixture, still whisking (don't worry about any lumps as they will...

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

  17. MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

    and reconfiguring which fields go in "Report Filter", "Column Labels", "Row Labels" and sum "Values". But because the next time this happens, I would have to repeat this, I would advise the above steps to remove parentheses.

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

  18. DJI Phantom FC40 - Fun at the raceshttps://www.joellipman.com/component/content/article/dji-phantom-fc40-fun-at-the-races.html?catid=113&Itemid=165

    the winds were really strong, I'd doubled the cost of the quadcopter and that's my mate's girlfriend. I'll use the guards next time if the wind allows. Do NOT break Line-of-Sight (LoS) for any participants Not distract the drivers or fly between them...

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

  19. Make bootstrap carousel responsive to swipehttps://www.joellipman.com/articles/cms/website-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

    } function o(e){ if(c){ var o=e.touches[0].pageX,i=u-o;Math.abs(i)>=n.threshold&&(h(),t(this).carousel(i>0?"next":"prev")) } } function h(){ this.removeEventListener("touchmove",o),u=null,c=!1 } var u,c=!1;"ontouchstart"in...

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

  20. Windows 7 and Google Chrome incognito mode by defaulthttps://www.joellipman.com/component/content/article/windows-7-and-google-chrome-incognito-mode-by-default.html?catid=61&Itemid=165

    using "incognito" mode with the Google Chrome web-browser, this article is just how to switch the quick launch shortcut (next to your start button). All the articles I googled were windows vista so I thought I'd share one for windows 7 here. I'm...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
Results 81 - 100 of 106