Set default parameter dates to start and end of monthhttps://joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

05 April 2011 =dateadd("d",-1, CDate(cstr(month(today.now())+1) + "/1/" + cstr(year(today.now()))) ) This idea was based on Bob Griffin's post on SQL Server Central.com forums where he subtracts 1 day from the first day of next month to get the last date/number of...

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

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

03 August 2012 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] schema, this...

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

Leap Motion and AR Dronehttps://joellipman.com/articles/_other-misc/quadcopters/leap-motion-and-ar-drone.html

17 May 2013 with major platforms. The following videos were shown to me by a colleague at work. I was so impressed I just had to post them. So here's a screenshot, read more if you want the videos: So Leap in Motion AR Drone: {youtube}ZOdxlrQj_ZU{/youtube} Just as...

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

Zoho Deluge - Regex to Strip all non-numeric charactershttps://joellipman.com/articles/crm/zoho/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

25 March 2019 A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above string...

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