Wednesday, October 22, 2014

More columns name than defined...?! Problem in a view...

Hi guys, I got this view TotalRate:



select


* from LastRate where TRANSACTION='Oil'



But when I try to run it I got:


View or function 'Test.dbo.TotalRate' has more column names specified than columns defined.


If I run simply select * from lastrate it works...I changed a lot of staff in lastrate but I can't understand the warning..


No comments:

Post a Comment