Assuming given is required, the following 76 results were found.
-
because the database wasn't designed with timestamps (despite being a timetabling and room booking system). But I do get given a weekday and the start date of the week... WITH tblDifference AS ( SELECT t1.*, ROW_NUMBER() OVER (ORDER BY t1.Date ASC,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
this data to your developers and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and DataScramble). How? CREATE PROCEDURE [Common].[usp_ScrambleMultivalue] (...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original data but the same length and the same type of data. Why?...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
that was not visibly used on the website. The website was working fine and I was able resume my click-happy habits. It's a given that in my test, there was only 1 user (me). There are reports though that some people set up websites with NO 3rd-party...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Given Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ------- ------- --------- Me 09:00 07:30 08:00 07:00 06:00...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Released under GNU/GPL ReadMe.txt What is it? I wanted my own IP lookup script to tell me the country that is allocated a given IP address, this is what I use. The scripts in the folder you have downloaded are to create a lookup function using a MySQL...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
weeks being/commence on Monday. It also uses the current date in the form of NOW() but this example has to work with any given date. First of all: Get this week's dates and days: SELECT DATE( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) DAY ) ) AS...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Platform ChangeLog Options 1.5 (4) - Enhancement: Restored alignment parameter - Enhancement: Restored colors and new colors given - Enhancement: Compatible with Joomla v2.5.x - Fixed: Backwards compatible parameters updated - Date Uploaded: Fri, 16th...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and Microsoft's SQL Server Reporting Services interface isn't...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been given. Why? Because I can How? Setup an account with gravatar.com and they’ll give you a link to that picture (eg....
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
opposite, where the week starts on the previous Saturday and ends on the last working day of the week. The Solution Where "givenDate" is the given date you have to calculate the last working day of: -- SAMPLE DATES ARE: -- -- 2012-04-27 10:00:00 -- is a...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
purposes, I'm going to be using the European date format so DD/MM/YYYY. The Solution This is what I use to convert a given SQL date to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table WHERE...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes : displays as...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
In other words, 1.0 in decimal, formatted to time is equal to 24 hours; 0.5 would be 12 hours and so forth. My formula: -- Given Cell B5 = 0.14 person days from above example. -- 1 person day = 26640 seconds and 1440 minutes = 24 hours. -- 0.07 person...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB