25 lines
824 B
Transact-SQL
25 lines
824 B
Transact-SQL
/*
|
|
Here we are basically just doing SELECT * FROM VariableValue WHERE VariableID = 57
|
|
The reason we are doing all the join statements is we are trying to target only the files in the
|
|
DWS folder, so we need the other tables in order to construct a path
|
|
*/
|
|
|
|
SELECT
|
|
v.VariableID,
|
|
v.DocumentID,
|
|
v.ProjectID,
|
|
v.RevisionNo,
|
|
v.ConfigurationID,
|
|
v.ValueText,
|
|
v.ValueInt,
|
|
v.ValueFloat,
|
|
v.ValueDate,
|
|
v.ValueCache,
|
|
v.IsLongText
|
|
FROM [Drilling_Test].[dbo].[Documents] d
|
|
INNER JOIN [Drilling_Test].[dbo].[DocumentsInProjects] dp on d.[DocumentID] = dp.DocumentID
|
|
INNER JOIN [Drilling_Test].[dbo].[Projects] p on dp.ProjectID = p.ProjectID
|
|
INNER JOIN [Drilling_Test].[dbo].[VariableValue] v on d.DocumentID = v.DocumentID
|
|
WHERE v.VariableID = 57 and p.Path like '%DWS%'
|
|
ORDER BY v.DocumentID asc;
|