AnsweredAssumed Answered

Report Generation Help

Question asked by Raghavendra Bhagavan.S.M on Feb 13, 2009
Latest reply on Feb 16, 2009 by Raghavendra Bhagavan.S.M
Hi,

I am trying to generate report from SWEPDM, By writing a query in SQL, This query Executes but results are not displayed.

I need to list all the part numbers and their descriptions in the report.

Here is the query.. Kindly help me where i am wrong.

________________________________________________________________
SELECT DISTINCT VariableValue.ValueCache AS Number,VariableValue.ValueCache AS Description
FROM Variable INNER JOIN
VariableValue ON Variable.VariableID = VariableValue.VariableID
WHERE (Variable.VariableName LIKE N'Number') AND (VariableValue.ValueCache <> N'')
(Variable.VariableName LIKE N'Description') AND (VariableValue.ValueCache <> N'')
ORDER BY VariableValue.ValueCache ASC
__________________________________________________________________

Your help is highly appreciated.

Regards,
Bhagavan.

Outcomes