1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
| Select dbo.getAscendantsVarChar(lh.Node,'3170') AS PathLib,
nd.NdLibelle AS Libelle,
lh.Datation AS ValueDate,
lh.BCPoint AS BarCode,
lh.ValueString AS Value,
sc.ValueString as SAP_reference,
nd.node as currentnode
from current_Nodes AS nd
INNER JOIN LastHisto AS lh ON nd.Node = lh.Node
INNER JOIN Typeids AS TI ON TI.TypeId=nd.TypeId and TI.Hist_cache <> 1
left JOIN EventLibs AS EV ON EV.EventString=lh.ValueString -- repérage des évènements
left JOIN lastnodes AS SC ON (SC.nodeFather=nd.Nodefather or SC.nodeFather=nd.Node)and SC.typeId = 'SC' -- noeud code SAP associé
where lh.Node IN ( -- Sélection des noeuds appartenant au sous-arbre ayant
SELECT Node -- le noeud de départ comme racine
FROM dbo.getDescendants('3170')
UNION
SELECT '3170'
)
AND lh.Datation > '2006-01-02' -- Sélection de la date de début
AND lh.Datation <= '2006-28-02' -- Sélection de la date de fin
AND lh.valuestring LIKE ('/%')[/quote]
Merci d'utiliser les balises codes.
select dbo.getAscendantsVarChar(lh.Node,'3170') AS PathLib,
nd.NdLibelle AS Libelle,
lh.Datation AS ValueDate,
lh.BCPoint AS BarCode,
lh.ValueString AS Value,
sc.ValueString as SAP_reference,
nd.node as currentnode
from current_Nodes AS nd
INNER JOIN LastHisto AS lh ON nd.Node = lh.Node
INNER JOIN Typeids AS TI ON TI.TypeId=nd.TypeId and TI.Hist_cache <> 1
left JOIN EventLibs AS EV ON EV.EventString=lh.ValueString -- repérage des évènements
left JOIN lastnodes AS SC ON (SC.nodeFather=nd.Nodefather or SC.nodeFather=nd.Node)and SC.typeId = 'SC' -- noeud code SAP associé
where lh.Node IN ( -- Sélection des noeuds appartenant au sous-arbre ayant
SELECT Node -- le noeud de départ comme racine
FROM dbo.getDescendants('3170')
UNION
SELECT '3170'
)
AND lh.Datation > '2006-01-02' -- Sélection de la date de début
AND lh.Datation <= '2006-28-02' -- Sélection de la date de fin
AND lh.valuestring LIKE ('/%') |
Partager