Wat heb jij onder 'ctrl-v' #7

http://www.albert.nl/display.do?page=home

select m.bkjrcode, month(m.datum) perfin, m.medewerker, m.fullname, m.repto_id, m.costcenter, sum(m.aantal) totaal,
case when (m.class_01) = 'DIRECT' THEN sum(m.aantal) ELSE NULL END AS 'DIRECT',
case when (m.class_01) = 'INDIRECT' THEN sum(m.aantal) ELSE NULL END AS 'INDIRECT',
case when (m.class_01) = 'AFWEZIG' THEN sum(m.aantal) ELSE NULL END AS 'AFWEZIG' from medurenmatrix m
group by m.bkjrcode, m.costcenter, m.class_01, m.datum, m.medewerker, m.repto_id, m.fullname

Nemo tam stolidus est ut malit paci bellum; in pace liberi patres sepeliunt, bello quidem patres liberos.


Kankersig van iemand,

valkstraat 44

http://www.youtube.com/watch?v=5mlyrLvuO6A

state0,

188

http://nl.youtube.com/watch?v=vXOqJmfgMHo

Heitinga kan spelen tegen PSV
John Heitinga staat woensdag, wanneer Ajax het opneemt tegen PSV, gewoon in de basis.

http://i.fok.nl/s/emo.gif

SELECT TBL_MPM.MPM_ID,TBL_MPM.ORG_ID,TBL_MPM.MPM_TAB,SUBSTRING(TBL_MPM_009.MPM_TEXT,1,13) AS [TBL_MPM_VELD009],SUBSTRING(TBL_MPM_011.MPM_TEXT,1,192) AS [TBL_MPM_VELD011],SUBSTRING(TBL_MPM_016.MPM_TEXT,1,50) AS [TBL_MPM_VELD016],SUBSTRING(TBL_MPM_019.MPM_TEXT,1,192) AS [TBL_MPM_VELD019],TBL_MPM_022.MPM_TEXT AS [TBL_MPM_VELD022],TBL_MPM_023.MPM_TEXT AS [TBL_MPM_VELD023],TBL_MPM_027.MPM_TEXT AS [TBL_MPM_VELD027],TBL_MPM_028.MPM_TEXT AS [TBL_MPM_VELD028],TBL_MPM_032.MPM_TEXT AS [TBL_MPM_VELD032],TBL_MPM_033.MPM_TEXT AS [TBL_MPM_VELD033],TBL_MPM_038.MPM_TEXT AS [TBL_MPM_VELD038],TBL_MPM_039.MPM_TEXT AS [TBL_MPM_VELD039],TBL_MPM_040.MPM_TEXT AS [TBL_MPM_VELD040],TBL_MPM_041.MPM_TEXT AS [TBL_MPM_VELD041],CAST(CAST(TBL_MPM_037.MPM_DATA AS VARBINARY(8000)) AS VARCHAR(8000)) AS [TBL_MPM_VELD037],LEN(CAST(CAST(TBL_MPM_037.MPM_DATA AS VARBINARY(8000)) AS VARCHAR(8000))) AS [TBL_MPM_VELD037_Warning_Max_Length_8000],TBL_MPM_037.MPM_TEXT AS [TBL_MPM_VELD037_TextSource],TBL_MPM_037.MPM_DATA AS [TBL_MPM_VELD037_ImageSource],CAST(CAST(TBL_MPM_042.MPM_DATA AS VARBINARY(8000)) AS VARCHAR(8000)) AS [TBL_MPM_VELD042],LEN(CAST(CAST(TBL_MPM_042.MPM_DATA AS VARBINARY(8000)) AS VARCHAR(8000))) AS [TBL_MPM_VELD042_Warning_Max_Length_8000],TBL_MPM_042.MPM_TEXT AS [TBL_MPM_VELD042_TextSource],TBL_MPM_042.MPM_DATA AS [TBL_MPM_VELD042_ImageSource],SUBSTRING(TBL_MPM_044.MPM_TEXT,1,10) AS [TBL_MPM_VELD044],SUBSTRING(TBL_MPM_045.MPM_TEXT,1,10) AS [TBL_MPM_VELD045],SUBSTRING(TBL_MPM_046.MPM_TEXT,1,10) AS [TBL_MPM_VELD046],CAST(CAST(TBL_MPM_047.MPM_DATA AS VARBINARY(8000)) AS VARCHAR(8000)) AS [TBL_MPM_VELD047],LEN(CAST(CAST(TBL_MPM_047.MPM_DATA AS VARBINARY(8000)) AS VARCHAR(8000))) AS [TBL_MPM_VELD047_Warning_Max_Length_8000],TBL_MPM_047.MPM_TEXT AS [TBL_MPM_VELD047_TextSource],TBL_MPM_047.MPM_DATA AS [TBL_MPM_VELD047_ImageSource],SUBSTRING(TBL_MPM_048.MPM_TEXT,1,192) AS [TBL_MPM_VELD048]
FROM TBL_MPM
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_009 ON TBL_MPM_009.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_009.MPM_TAB='A' AND TBL_MPM_009.MPM_FIELD='009'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_011 ON TBL_MPM_011.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_011.MPM_TAB='A' AND TBL_MPM_011.MPM_FIELD='011'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_016 ON TBL_MPM_016.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_016.MPM_TAB='A' AND TBL_MPM_016.MPM_FIELD='016'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_019 ON TBL_MPM_019.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_019.MPM_TAB='A' AND TBL_MPM_019.MPM_FIELD='019'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_022 ON TBL_MPM_022.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_022.MPM_TAB='A' AND TBL_MPM_022.MPM_FIELD='022'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_023 ON TBL_MPM_023.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_023.MPM_TAB='A' AND TBL_MPM_023.MPM_FIELD='023'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_027 ON TBL_MPM_027.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_027.MPM_TAB='A' AND TBL_MPM_027.MPM_FIELD='027'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_028 ON TBL_MPM_028.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_028.MPM_TAB='A' AND TBL_MPM_028.MPM_FIELD='028'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_032 ON TBL_MPM_032.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_032.MPM_TAB='A' AND TBL_MPM_032.MPM_FIELD='032'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_033 ON TBL_MPM_033.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_033.MPM_TAB='A' AND TBL_MPM_033.MPM_FIELD='033'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_038 ON TBL_MPM_038.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_038.MPM_TAB='A' AND TBL_MPM_038.MPM_FIELD='038'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_039 ON TBL_MPM_039.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_039.MPM_TAB='A' AND TBL_MPM_039.MPM_FIELD='039'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_040 ON TBL_MPM_040.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_040.MPM_TAB='A' AND TBL_MPM_040.MPM_FIELD='040'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_041 ON TBL_MPM_041.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_041.MPM_TAB='A' AND TBL_MPM_041.MPM_FIELD='041'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_037 ON TBL_MPM_037.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_037.MPM_TAB='A' AND TBL_MPM_037.MPM_FIELD='037'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_042 ON TBL_MPM_042.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_042.MPM_TAB='A' AND TBL_MPM_042.MPM_FIELD='042'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_044 ON TBL_MPM_044.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_044.MPM_TAB='A' AND TBL_MPM_044.MPM_FIELD='044'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_045 ON TBL_MPM_045.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_045.MPM_TAB='A' AND TBL_MPM_045.MPM_FIELD='045'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_046 ON TBL_MPM_046.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_046.MPM_TAB='A' AND TBL_MPM_046.MPM_FIELD='046'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_047 ON TBL_MPM_047.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_047.MPM_TAB='A' AND TBL_MPM_047.MPM_FIELD='047'
LEFT OUTER JOIN TBL_MPM AS TBL_MPM_048 ON TBL_MPM_048.MPM_PARENT_ID=TBL_MPM.MPM_ID AND TBL_MPM_048.MPM_TAB='A' AND TBL_MPM_048.MPM_FIELD='048'
WHERE
TBL_MPM.MPM_TAB='A' AND TBL_MPM.MPM_FIELD='GRD'

j zou toch voor mekomen zorgen?

<!-- var thisTable = document.getElementsByTagName("table").item(1); if(!thisTable) thisTable = document.getElementById('itable'); var thisBody = document.createElement("tbody"); thisTable.appendChild(thisBody); var sClasses = new Array('a','e','n','t','s','p','v','l','sp');
Error #5
Deze site is momenteel niet bereikbaar wegens database-problemen. Wacht even en probeer het zometeen opnieuw. (db:query:2006)

http://forum.fok.nl/templates/new/i/p/16.gif

http://www.flickr.com/photos/welie/1305116957/