Ew... you're right. Nice catch.

Hi Erikur,

Thanks again for the reply. To preface this, your post was VERY helpful, and I doubt I would have got to the version I'm happy with now without your...

Thanks for the response. Taking a look now...

Thanks, Luis. sys.parameters is great for solving some weird problem like that.

Huzzah! That did it. Thanks, Scott!

Yeah, I actually mentioned that approach, but it's not always possible to get JUST those with those procs. If you had a TT called MyTableOfDoom and a presentation table called...

But no way to do it in SQL? I'm trying to avoid having to have a real live human have to look it all up ahead of time.

Thanks, Steve.

So let me ask a more general question, assuming many companies don't run solely out of a single data center, what do people REALISTICALLY do to keep things in...

ScottPletcher (7/24/2015)

---

I just rename the existing user table type to some other type name -- which you can then immediately drop -- then (re)create the original type name with the...

Do you have a simple example of the schema and proc you use which, perhaps, I could adapt? Or is it a lot of code?

Thanks for the doc on the string splitter. I'm quite familiar with it (we use those string splitters regularly). You may have already answered my question when you said there's...

So the way I'm using them is in procedures which are part of an API which allows people to put in configuration rows which eventually get put into pres tables....

adamsmin (6/26/2014)

---

Great work.

But the Resources of getdescendants.cs cann't open

this is error message:

The resource could not be found

Sorry, we could not find the resource at /SQLServerCentral2/Error404.aspx?404;http://www.sqlservercentral.com:80/Files/getdescendants.cs/20713.cs

If you followed...

I completely agree that the quick easy solution is to use the import export wizard.

I'll just offer one more ad-hoc way to do this. Since your data is pretty...

If you've got multiple values, I'd throw them in a temp table and join out to that, rather than concatenated them and use DSQL.