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...
Websites
R.E.S.Aubange
R.E.S.Aubange
Created on 30 January 2014
Website to manage a football club, including a pronostics game.
WPF
Troubleshooting graphic issues in WPF applications
Troubleshooting graphic issues in WPF applications
Created on 30 January 2014
Graphic issues in WPF applications can include any of the following symptoms:
· ...
SQL
Convert a date to varchar
Convert a date to varchar
Created on 30 January 2014
This function return a varchar with the date and time from a datetime parameter.
The string r...
SQL
Search in system object
Search in system object
Created on 30 January 2014
This function search a word in all the sysobjects and return the result with the source (storedpr...
SQL
First Day of the month
First Day of the month
Created on 30 January 2014
Get the First Day of the month
CREATE FUNCTION [dbo].[udf_GetFirstDayOfMonth]
(
-- Add the ...
SQL
First Day of the next month
First Day of the next month
Created on 30 January 2014
Get the First Day of the next month
CREATE FUNCTION [dbo].[udf_GetFirstDayOfNextMonth]
(
--...
Powered by