I wouldn't trust the ASCII-value solution. Too subject to things like collation values or the introduction of a two-character prefix or whatever.

Definitely split the values.

In that particular instance, I'd say more than one person can "own" a car/house/whatever. Divorce proceedings often seem to support that concept.

The standard definition of "recession" is a period of 2 quarters in a row of negative GDP growth for a region. US GDP is growing (not sure about the...

In that case, either a Union with "fake" column names, or exporting the column names once, then the data for them and appending it, will work just fine.

You're welcome.

If the number and type of columns doesn't change, but you want the column headers to change, you might also be able to include "column headers" as a row of...

The error you're getting per a prior post is that it can't open a distributed transaction. Have you checked the DTC is running on that machine?

That would be a cursor. It will work.

The problem I see with that (Joe's) query is it assumes collation and values will always produce the Y result. Can you be certain of that? If, for...

First, that will only work if you're only inserting one type of CartwallID at a time. It also won't work if you insert multiple rows in one transaction, because...

I thought of an interesting method you could use for this if you use the RowVersion/Timestamp data type in your tables. Use a Dense_Rank() query that selects a union...

Well, you can either do it in a trigger, or in the proc that inserts into that table.

You should be able to simply select the count from the table based...

Steve Jones - SSC Editor (10/27/2010)

---

I'll drop some topics out here for you. Here's a couple that I have saved up:

- Finding/changing the default backup location

- scheduling a trace

- duplicating...

There's an option in SSIS to delay validation of the data sources till they are called. I've used that to avoid the error about design-time vs run-time.

If there are only two levels, then yes, and Exists check will get you what you need.

SELECT

ID,

CASE WHEN EXISTS ( SELECT

...