Hi

In a different post I got a reply that tells about Repetitive SQL. Could you please explain what is Repetitive SQL?

http://stackoverflow.com/questions/2657459/sql-code-smells

I thought to make it a new post as it is a different subject. The reply says that use of "multiple stored procedures that perform the exact same joins but different filters" can be avoided using VIEWs.

Could you please give an example that can only be achieved using repetitive queries, if we are using Stored Proecure? [The same can be achieved without repetition when used VIEWS]

Thanks

Lijo