Página 1 de 1

free lance xailer work

Publicado: Vie Mar 23, 2012 4:18 pm
por Ron Broere
We are looking for a xailer/sql programmer who can do small changes and additions to an existing xailer application that uses fastreports to get additional reports from a mssql database.
You should be good in mssql and fastreports and understand queries like this:
//
//how many contacts were there with children?
:cSelect := SELECT Oproepen.PkId Oproep, Afgehandeld.Contactsoort, sputogedaan, sputoafwijkend "+;
"FROM Oproepen INNER JOIN Afgehandeld ON Oproepen.AfgehandeldID = Afgehandeld.PkId " +;
"WHERE "
IF nPost > 0
:cSelect += "Afgehandeld.PostId = '" + alltrim(str( nPost)) + "' AND "
ENDIF
:cSelect += "DATEADD(dd, DATEDIFF(dd, 0, oproepen.datum), 0) >= '" + dVan + "' AND " +;
"DATEADD(dd, DATEDIFF(dd, 0, oproepen.datum), 0) <= '" + dTotMet + "' AND " +;
"DATEADD(year, 18, Oproepen.Geboren) >= '" + dTotMet + "' " +;
"ORDER BY Afgehandeld.Contactsoort; " +;
:open()
There will be a couple of hours work every month, you can work remote from your home/office.
Please send your cv and hourly rate to xailer@bbkm.nl
Regards,
Ron Broere
BBKM INfocom
bbkm.nl