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

  1. Apple Magic Trackpad with Windows 11 Intelhttps://www.joellipman.com/component/content/article/apple-magic-trackpad-with-windows-11-intel.html?catid=80&Itemid=165

    my docking station weren't too much of an issue either as MS Windows detected these without needing software. Long rant to justify why I didn't want to drive home (~20 to 40 minutes commute) and pick up my laptop. How? The work and research for this was...

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

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

    and the value we want to search on is "3" (the 3rd incremental load). How? The below stored procedure can be reduced to just a script as long as you declare and set the parameters after the BEGIN and extract the script from BEGIN to END (excluding the...

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

  3. Returned a data type that is not validhttps://www.joellipman.com/articles/else/database/t-sql/returned-a-data-type-that-is-not-valid.html

    I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report...

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

  4. Formatting a date in an MDX queryhttps://www.joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

    and trying to specify default date as today's in the format DD/MM/YYYY. Googled this but couldn't find an answer, then I just replaced "=NOW()" [yields: 01/01/2011 01:00:00] with "=Today()" [yields: 01/01/2011] and this did the trick. English Ordinal...

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

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

    replace NULL with lots of hyphens (if you want lots of dashes/hyphens as separators) or replace with whatever 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...

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

  6. Drop If Object Existshttps://www.joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html

    websites, I wanted a page which has all of them in one place. So here you go, I hope it's of some use. If it's wrong then just post a comment at the bottom of this page. Go go go Note that in the following examples, I'm checking under the [Common]...

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

  7. T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    yet available D300 4 Daat oNt EYt Avialable D300 This is obviously a simplified table as it doesn't tell us much but it is just for demo purposes. Consider the following query: SELECT DISTINCT StudentDetail FROM StudentTable WHERE...

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

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

    Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF...

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

  9. Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/else/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

    002 3.00 2000-02-18 1.00 2 002 3.00 2000-02-18 1.00 3 003 2.00 1999-02-25 1.00 1 003 2.00 1999-02-25 1.00 2 Great! Now let's just add the Rownum value to the date of sickness (minus 1 for obvious reasons - 25th + row(1) = 26th when the person was off...

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

  10. Compare two databases using T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/compare-two-databases-using-t-sql.html

    SQL Server Management Studio (SSMS) comes included so use it... How? Well I started with the method #1 listed here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM...

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

  11. T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/else/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

    a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput...

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

  12. Basic Oracle Function Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-function-structure.html

    I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function in it's simplest form and if I want to torture my successors,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  13. Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-stored-procedure-structure.html

    Reporting Services (SSRS) which is why I'm going down this route. For an even simpler stored procedure, I'd imagine you just get rid of the cursor. Why A standalone query is faster in the eyes of SSRS, however within SSRS we don't have the capability to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  14. SQL Queries for Statisticshttps://www.joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

    0 if not logged in) and of course the Timestamp (DateTimeStamp). Here is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user...

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

  15. Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    and its design is property of SomeoneElse.com Note how I don't use the `id` columns of the tables as I'm quite content with just the two columns I requested. And for those of you that don't know, the alias "AS" is optional in MySQL (think it's optional...

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

  16. Delete related records from multiple tableshttps://www.joellipman.com/articles/else/database/mysql/delete-related-records-from-multiple-tables.html

    rows is stored in another table, how do we delete from all the related tables as well? How? You need to refer to the tables just after the DELETE clause (so instead of DELETE FROM myTable WHERE myValue=givenValue): DELETE s, ssf, sst FROM `Session` s...

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

  17. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    demo site; I started at 9am and finished at 9:45.", "Monday morning, I also worked on creating a template for the site I just made; I started at 9:45 and finished at 12:00") The final system needs to specify every day of the week and divide all the days...

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

  18. 301 Redirect using htaccess filehttps://www.joellipman.com/articles/cms/website-development/301-redirect-using-htaccess-file.html

    There are a lot of articles & posts out there that cover the same topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted...

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

  19. FTP on Mac: Failed to retrieve directory listinghttps://www.joellipman.com/articles/cms/website-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

    boxes ticked EXCEPT for "Enable Stealth Mode" Settings Security and Privacy Firewall Firewall Options Note: the filezilla just appeared when it was running. I didn't add it. Helpful Links WireNine.com - Knowledgebase - How to fix failed to retrieve...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *

  20. Embed an FLV file into a web pagehttps://www.joellipman.com/articles/cms/website-development/html/embed-an-flv-file-into-a-web-page.html

    This is if you have an FLV file and you don't want any fancy management system, you just want your FLV to play on your webpage. The following example is a demonstration of how to do this without installing anything on your webserver. I like to use...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: *
Results 201 - 220 of 277