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


Updated March 06, 2017 22:06 PM

Updated March 06, 2017 03:06 AM

Updated August 29, 2017 13:06 PM

Updated September 22, 2017 21:06 PM

Updated May 25, 2018 21:06 PM