Hello, I have a query which works properly and returns value in MS SQL. But when the same query is executed via DB connect , its returning no rows returned. Below is the sample of that query not the original one SELECT * FROM (SELECT abc.row, abc.rsa, abc.desc, CASE WHEN resTyp = 'OBJECT' THEN objNa(abc.rsa) ELSE objNa(pt.OBJECT_ID) END AS objNa, abc.resTyp, abc.reqMod, abc.reqStat FROM sys.abc LEFT JOIN sys.pt ON pt.hobt_id = abc.rsa WHERE rsa > 0 AND resource_database_id = DB_ID('Database1')) as locks ORDER BY objNa The same is returning rows in MS SQL not in db connect. Please help what is causing the issue in above query
... View more