I have no problem running the following query in both Pi SQL Commander and SQL Report Builder:
SELECT tc.name, tc.BuildingNumber as BuildingNumber, round(tc.Power, 3) FROM [PIDB-AF].[Asset].[ElementHierarchy] eh INNER JOIN [PIDB-AF].[DataT].[ft_TransposeSnapshot_CW Meter Template] tc ON tc.ElementID = eh.ElementID OPTION (FORCE ORDER, IGNORE ERRORS, EMBED ERRORS)
Unfortunately this gives all the data when I just need data for just one building; In a traditional sql query I can restrict the vales by:
Where tc.name = @CWName
Here, the @CWName is a user selected parameter from a list of all the building names. Unfortunately this format is not working, is there a way to only get values for 1 building?