You want to present the results in a format QA isn't really equipped to deliver. You could do it, perhaps using a t ble valued function and some dynamic sql...

Not so fast! I agree the solution is workable and suitable (unavoidable) for some situations. Problem-solvers prefer situations with awkward or unusual constraints. It means we have to use ingenuity and makes things more interesting. But...

But in any form of SQL, if you have a group by clause, any column in the select list must either be enclosed in an aggregate function, or must also...

IN will only accept literals i.e. the actual values spelled out right there between the brackets(). You could, but almost certainly shouldn't, use dynamic SQL to get the literals between...

Are you saying that a domain of {0,1} or {'T','F'}, or whatever, in the logical model should never be mapped to the semantic values true, false in the conceptual model...

I'm not sure whether a stored proc would be approriate for your situation, but if so:

--This is based on AdventureWorks but can easily be adapted.

More of a piccalilli man myself...and brown sauce. English food is objectively disgusting, but when you're raised on it you can't help liking it, and in a perversely defiant way...

To send a recordset to the DB, you would preferably use an update method. The recordset (even if empty) should have come from the DB to start with, so you are...

I can't see what ordering algorithm you want to use. Position in what sequence?

Agree that meaningful grouping of columnname prefixes is almost certainly symptomatic of denormalisation. Might not be a business problem though.

Then we're all agreed. The data should be stored in classical relational form (subject to SQL compromises), for all the (one hopes) obvious reasons. The only (mildish) dispute, certainly from...

I still say that unless the relevant part, logical physical and temporal, of your system is read-only, sometimes reads using NOLOCK will be plain wrong, unless by lucky accident. This is true...

Dead quick to write, dead slow to run and debug (+ scalability to >8000char, embedded commas?). Admin procedures are allowed to be slow (if necessary), production ones aren't (it shouldn't be necessary). It...

The only way to do it as a single NOT IN subquery would be to concatenate the columns. But unless you use indexed calc columns, and probably even then, this...

Build your string first and use it as part of the spec of your DTS package. You should be able to create the package in TSQL, and incorporate the string...