Part of the issue is definitely people falling into what they know. It's conceptually easy for someone coming from writing C for instance to find the cursor and say...

One of the somewhat insidious problems with undetected or uncontrolled use of RBAR is that it may often work fine. At first.

As both the load and number of records...

There are no "dependencies" per se for dynamic SQL because it's just text literals, so you have no defined dependencies to search on directly.

As far as I know the only...

There is also the option of using a table type parameter as a container for variable and/variable length parameter lists.

Build a type containing name - value pairs, populate it in...

Interesting stuff, thank you.

Table type parameters for stored procedures have eliminated much of my need for doing this within SQL, but it's always nice to have options.

It does seem like that would be one instance where a CLR udf would do very well, especially to support more complex examples. That's precisely the type of thing...

Scott D. Jacobson (8/1/2012)

---

MarbryHardin (8/1/2012)

---

Yes, that's my point. Between does not logically imply a comparison order, but SQL Server imposes one.

And consider if you want to supply variables instead...

Yes, that's my point. Between does not logically imply a comparison order, but SQL Server imposes one.

And consider if you want to supply variables instead of literal values for...

Have you tried using OPENQUERY ?

Tabs, all the way.

Saying that you want to use spaces because people will write improperly formatted code is a hack. Tabs have the same usefulness and purpose in writing...