select from a view is not working

by SANINFOTECH Inc   Last Updated September 11, 2019 19:06 PM

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



Related Questions





Patching SSRS on Always on Availability Groups

Updated September 22, 2017 21:06 PM