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

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

    ' ', CHAR(10)) ELSE c.[Phone] END AS 'Phone', tt.[SiteId] AS 'Site', wm.[WeekNumber] AS FacilityWeek, CONVERT(CHAR(10), GETDATE(), 103) AS 'WeekStart', CONVERT(CHAR(10), DATEADD(day, 6, GETDATE()), 103) AS 'WeekEnd', SD.[SetId] AS 'Set' FROM...

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

  2. Cheat Sheet for mySQL vs t-SQLhttps://joellipman.com/articles/else/database/cheat-sheet-for-mysql-vs-t-sql.html

    CHAR_LENGTH(string) LEN(string) DATALENGTH(string) Dates / Times Weekday Name DAYNAME(now()) DATENAME(dd, getdate()) Weekday Number DAYOFWEEK(now()) DATEPART(dw, getdate()) Month Name MONTHNAME(now()) DATENAME(mm, getdate()) Month Number MONTH(now())...

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

  3. SSIS Convert a string into a datehttps://joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    NULL). -- PROBLEM: -- assuming date could be blank (has spaces) or in format DDMMYYYY (TRIM(Date) == "") ? (DT_DBTIMESTAMP)GETDATE() : (DT_DBTIMESTAMP)(SUBSTRING(Date,5,4) + "-" + SUBSTRING(Date,3,2) + "-" + SUBSTRING(Date,1,2) + " 00:00:00") -- Yields:...

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

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

    SET YEAR RANGE (1912 - 1994: for Birthdate specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ago from today SET @MaxYear = DATEPART(YEAR,GETDATE())-18; -- 18 years ago from today -- GET RANDOM...

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

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

    SET YEAR RANGE (1912 - 1994: for Birthdate specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ago from today SET @MaxYear = DATEPART(YEAR,GETDATE())-18; -- 18 years ago from today -- GET RANDOM...

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

  6. Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://joellipman.com/articles/else/app-dev/android-os/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

    } holder.newsItemTitle.setText(items.get(position).getTitle()); holder.newsItemDateD.setText(items.get(position).getDate().substring(5, 7)); holder.newsItemDateM.setText(items.get(position).getDate().substring(8, 11).toUpperCase());...

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

  7. Generate Academic Calendar using MySQLhttps://joellipman.com/articles/else/database/mysql/generate-academic-calendar-using-mysql.html

    our calendars WHERE calendar.SetID=( SELECT TOP 1 acyear.SetID FROM cmisuser.WEEKSTRUCTURE acyear WHERE acyear.StartDate >= GETDATE() ORDER BY acyear.StartDate DESC) */ ORDER BY calendar.weekNumber

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 1 - 7 of 7