Select assets where a particular "process" is running
Hi all I have the following Code but its retuning all results as "Yes" , which is not the case (Select (Case When Exists(Select Top 1 tblAssets.AssetName From tblAssets Where Exists(Select tblProcesses.AssetID From tblProcesses ...