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

  1. Android: Replace return key with done, go, send...https://www.joellipman.com/articles/else/app-dev/android-os/android-replace-return-key-with-done-go-send.html

    action key performs a "send" operation, delivering the text to its target. IME_ACTION_UNSPECIFIED // no specific action has been associated with this editor, let the editor come up with its own if it can. Source(s) developers.android.com : TextView -...

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

  2. Parameters not being used in report processinghttps://www.joellipman.com/component/content/article/parameters-not-being-used-in-report-processing.html?catid=75&Itemid=165

    off the @GivenDate and @GivenCampus and re-assigned them mid-script which made no difference whatsoever. In case you've been stuck for ages (as I have), I found out you cannot declare the parameters used by the software within the SQL script... So the...

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

  3. Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    retrieved Yields something like: This is the bottom left of a report where both the above examples (fill and borders) have been applied:

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

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

    table then following the below will also let you do this (requirements: common sense or the IQ of a duck). It's what I've been searching for for the past hour and although you may think I'm just adding to the cyberspace pile of useless info, at least...

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

  5. SSRS / MDX Date Querieshttps://www.joellipman.com/component/content/article/ssrs-mdx-date-queries.html?catid=75&Itemid=165

    I find myself using date ranges endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in my environment: WinXP, BIDS (vs2008), TFS (vs2010), SSRS...

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

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

    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 returned based on the status of the stored...

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

  7. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    warnings in SQL Developer (or SQL*Plus, etc.) Hardcode your parameters in the SSRS report with actual values that would have been submitted. Create the most basic report you can with the data you're working with just so you can get used to how this...

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

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

    on the Reporting Server: Conclusion The whole report was appearing over any scrolled content as if it were a header that had been told to keep visible while scrolling. The fix in a nutshell is to ensure nothing is kept visible while scrolling. This...

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

  9. Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/component/content/article/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html?catid=77&Itemid=165

    I misunderstood what was going to happen when I started this. We have a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following other instructions because I thought my personal...

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

  10. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    changed job and no longer have all my test machines at work. Instead I only have the one workstation :eek Still I've been asked to test some web applications (???) so I had to find a solution to suit me. I'd done this before IE7 (so a long time since)....

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

  11. The ReportServer Databasehttps://www.joellipman.com/articles/else/database/the-reportserver-database.html

    times instead of summing the remaining columns? Correction, sum will only give me the total time but what if a report has been run twice more often then another, then is it slower? Not necessarily. Like all measures in bytes, I would like a thousand...

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

  12. 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

    to format the returned value to a more user-friendly date format (such as Month name then year - eg. November 2010). I have been told that data types are a nightmare in SQL Server Reporting Services and that all data types should be kept in their...

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

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

    A007 08:00 17:00 NULL NULL NULL NULL NULL NULL */ Note that my data is inaccurate as the last row of each grouped data has been changed to NULL. Also note how the actual select query is pulling data from my CTE in its post-formatted form. I perform all...

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

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

    "Obfuscating your SQL Server Data" by John Magnabosco but tweaked for our purposes. NOTE that the following has only ever been run on development environments and I would not recommend running this on a production system as I have not tested the...

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

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

    Some people have been suggesting you can use "CREATE OR REPLACE... VIEW... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I...

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

  16. DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/else/database/t-sql/datatumble-randomize-data-rows.html

    scramble Data in a column of a table. ** ** The process will mix the Data using a random function. ** ** Once the Data has been scrambled it won't be possible to get the original set of Data. ** ** ** ** Usage Examples: ** ** EXEC usp_ScrambleMultivalue...

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

  17. T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    DMExtractReferenceTable r1 ON e1.CodeType=r1.MapIn So simply change the "=" to a "LIKE". Scenario #2 So when the above has been addressed or we've tried casting as varchars all over the place, check the value that gets outputted is also a literal...

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

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

    OR ( t1.TABLE_CATALOG IS NULL OR t2.TABLE_CATALOG IS NULL ) -- NOTE: This does not list if a column has been moved to another table Method #4 And a final enhancement to epitomize my laziness (replace [myDB1] with name of database 1 and [myDB2] with name...

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

  19. Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    data therein matched the TNSNAMES.ORA file located in "C:\ORACLE\product\11.2.0\client_1\network\admin". Furthermore I've been asked why aren't all our Oracle databases the same version? It's due to the fact that these aren't our databases, we simply...

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

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

    Basically, I've started using so much more SQL in our new Business Intelligence projects that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
Results 101 - 120 of 154