This is weird for me Select * from vw_xxxx is not showing any results for a certain ids and select from view working fine. Any help would be greatly appreciated.
select * from vw_clientdetails where clientid = 1234
is not getting any results and my view is defined as
create VIEW [dbo].vw_clientdetails as SELECT top 500 dbo.table1.Id, dbo.table1.SDA_Key where clientid = 1234
and if i run the select with in the View is working fine but not
select * from view