SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 --Create some events to place on the calendar SELECT EventDate = CONVERT(VARCHAR(2),DATEADD(MONTH, -1,GETDATE()),101) + '/30/2009 02:00:00 PM', Note = 'Event 1' UNION SELECT EventDate = CONVERT(VARCHAR(2),GETDATE(),101) + '/23/2009 12:00:00 PM', Note =...

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

RocketTheme's Affinity July 2009 Releasedhttps://www.joellipman.com/articles/cms/joomla/rocketthemes-affinity-july-2009-released.html

01 July 2009 Affinity is the July 2009 release from RocketTheme and features extensive third party support for powerful and popular community products, such as JomSocial, K2 and phpBB3. The template's core feature is Sortable Elements, which allows for the movement...

• Type: Article
• Author: Webmaster
• Category: Joomla
• Language: *

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

11 January 2011 =Format(Fields!myDateTime.Value, "M/d/yy")... 6/15/09 =Format(Fields!myDateTime.Value, "M/d/yyyy h:mmtt")... 6/15/2009 2:45PM =Format(Fields!myDateTime.Value, "MM/dd/yy HH:mm")... 06/15/09 14:45 =Format(Fields!myDateTime.Value, "MMM d, yyyy")... Jun...

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

Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 this page from time to time to ensure that you are happy with any changes. This policy is effective from the 1st of January 2009. What we collect We may collect the following information: name and job title contact information including email address...

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

Copyrighthttps://www.joellipman.com/static-items/copyright.html

30 May 2009 This website and its content is copyright of Joel Lipman .Com © 1999 - 2009. All rights reserved. Any redistribution or reproduction of part or all of the contents in any form is prohibited other than the following: you may print or download to a local...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Web Browsers Release Yearhttps://www.joellipman.com/articles/web-development/web-browsers-release-year.html

18 May 2010 Safari 3.0, Conkeror 1262 2008 Konqueror 4, Safari 3.1, Opera 9.5, Firefox 3, Amaya 10.0, Flock 2, Chrome 1, Amaya 11.0 1565 2009 Internet Explorer 8, Chrome 2, Safari 4, Opera 10, Chrome 3, SeaMonkey 2, Camino 2, Firefox 3.5 1734 2010 Firefox 3.6,...

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

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 newspapers Local colleges/universities Local community organisations and buildings Source(s): http://www.thepcguild.com/2009/12/featured/so-you-want-to-be-the-local-pc-repair-dude-tips-what-to-expect-resources/

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

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

07 December 2012 ** Author: - ** ** Created On: 28 August 2009 ** ** Revision: V 0.01 ** ** Description: Stored Procedure to 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...

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