Home
Welcome to my Web site.
Here you will find my full curriculum vitae and some of my accomplishments.
You can also view the latest information I regularly post on this site.
The Support section contains various useful informations for IT development or technologies.
Feel free to contact me if you have other questions.
Good reading.
Gaëtan
PrevNext
Last articles
SQL
Repeat rows according to a value
Repeat rows according to a value
Created on 25 September 2014
The case :
We have a table with this data :
Center
Nb of letter
...
SQL
Find all the dependencies for an Entity/column
Find all the dependencies for an Entity/column
Created on 23 September 2014
This table function return all the dependencies for a table/column.
The source used is here :...
SSIS
Use a specific port to send email in...
Use a specific port to send email in...
Created on 05 February 2014
When you send an email with the Mail Task in a SSIS, you cannot specify the port for the connecti...
SSIS
Get the error message in the script task...
Get the error message in the script task...
Created on 05 February 2014
When you execute a SSIS and a script task failed, you have only the message indicating the script...
SQL
Convert a real datetime to Midas datetime
Convert a real datetime to Midas datetime
Created on 05 February 2014
This Scalar-valued function return a Midas datetime from a real datetime. In midas, the date are ...
SQL
Convert a Midas datetime to SQL
Convert a Midas datetime to SQL
Created on 05 February 2014
This Scalar-valued function return a real datetime from a Midas datetime. In midas, the date is t...
News
Opening of the new website
Opening of the new website
Created on 30 January 2014
The new website is open. You'll find now a support part in which there is various codes and a...
Websites
Statistics and Simulations
Statistics and Simulations
Created on 30 January 2014
Website of statistics and simulations.This website was created for a student of U.Lg (University of ...
SQL
Remove trailing zeros
Remove trailing zeros
Created on 30 January 2014
Remove Trailing Zeros
CREATE FUNCTION [dbo].[udf_RemoveTrailingZeros]
(
@strValue nvarchar(...
SQL
Last Day of the week
Last Day of the week
Created on 30 January 2014
Get the last Day of the week
CREATE FUNCTION [dbo].[udf_GetLastDayOfWeek]
(
-- Add the para...
SQL
Last Day of the previous month
Last Day of the previous month
Created on 30 January 2014
Get the last day of the previous month
CREATE FUNCTION [dbo].[udf_GetLastDayOfPreviousMonth]
...