Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Dynamic Where Clause for Multiple paramaters with AND Operator Expand / Collapse
Author
Message
Posted Monday, January 7, 2013 1:00 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:52 PM
Points: 1,945, Visits: 2,929
Please read any book on basic Software Engineering and study the parts on coupling and cohesion. This is bad programming in any language . You will see it referered to as "Automobiles, Squids and Lady Gaga" procedure or tables in SQL; other languages have their slang, most of which is not printable.

It is incoherent, controlled by exrternal flags and will have awful performance. Again, please read any book on basic Software Engineering.


Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
Post #1403834
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse