Advanced Search

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

  1. SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/component/content/article/ssrs-parameters-in-oracle-stored-procedure.html?catid=75&Itemid=165

    Properties" for that stored procedure. The variable values will be prefixed with @ for SQL Server and not the colon (:) we expected for Oracle. Passing in Variables I've been told that SSRS does not understand OUT variables. For a success message to be...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    Notes: No "SELECT... INTO..." on the second query which is the one that will return my columns. Two output fields are expected to be returned: "p_STUDENT_DETAILS" and "p_STUDENT_REF". 2. Add a datasource Nothing different to your usual method of...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    I might so it fails. I realised then the equals sign ("=") could be changed to a "LIKE" which will mean both values are expected to be a string. So with this in mind: SELECT r1.MapIn ( SELECT (COUNT(e2.EmpType)-1) AS MyCount FROM DMExtractEmployeeTable...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  4. T-SQL concatenate an incremental row numberhttps://joellipman.com/articles/else/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

    "Joel Lipman" has a degree in Computer Science BSc and some qualification in being Superman. Specification The output expected by the customer is the following: EMP -------------------------------------------------- EmpNumber QualificationRef 001 00101...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  5. Project Plan for Freelance Websitehttps://joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    exclusive to the Apple Mac operating systems. Webspace Setup For JoelLipman.Com to do: Assess allocated server space - expected size of website including all uploaded files. Add domain folder to the server. Setup FTP Accounts (just one...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  6. Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    back-end? can it be circumvented?) Website Revamp? Signed Off Specification (describing clearly the agreed work to do and expected results) Realistic Cost & Time (obviously agreed with client) Additional Documentation (timesheets, agreements, technical...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  7. SITS: Export field code and namehttps://joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    value in our XML to our Staging environment. Why? Let's take the country of birth of a person as an example as it is expected to be a long list and where just using the parameter &S is not workable. Instead I want to use &G[] and get both the code and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  8. Zoho Deluge - MD5 functionhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-md5-function.html

    So this is NOT an article on how to create a MD5 function for an ETag in Zoho Deluge as I expected it would be. At time of print, the Zoho documentation (and Google search results) make no mention of using MD5 in an encryption task. Why? I'm trying to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  9. MySQL Transactions in PHPhttps://joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

    the chances of misplacing our millions due to some possible error we must ensure that both queries are executed with the expected result before committing any changes to the data. This where transactions are useful. We can run the queries, then check if...

    • Type: Article
    • Author: Ike Francis
    • Category: MySQL
    • Language: en-GB
Results 21 - 29 of 29