I thought that to.

But then why would it allow me to run immediately if I map the 1st 4 and then it won't when I map the next one or...

No, that is true.

But in my case, I have to use the database prefix because it will be called from another database.

Thanks,

Tom

These are all on one server.

The view is only on one of the databases in the environment. It is called from another database and works fine when used from...

That would normally be true.

But in this case the view is being called from a different environment and it wouldn't be a problem except that I don't know if I...

I had thought about doing it that way, but I really didn't want to do the unions where any changes would have to be done multiple times, thus increases chances...

Are you serious??????

This is why you aren't taken seriously.

You don't seem to ever want to address the issue.

There wasn't one thing you said that addressed the issue. The answer...

That was pretty much what I figured.

I can do the join to the database table to get the records that for each database by adding a DatabaseID column to the...

I have tried everything to get this and another file to work and in that one I am getting the same type of error for a column that is blank.

This...

I found out why it does this if I have the Query window results set to Text.

From Query/Query Options/Text, I have it set to 256.

But why would that do the...

That works fine.

Thanks,

Tom

So that would be the same as:

SELECT TOP 1 ID,

Name,

Number,

...

I see.

I can see it better if I put the case statement as a column to see what it is doing and it makes sense. Clean.

3Main2MainClass ...

That was what I was looking for.

I added in the Order by without the Top just to see how it would order and it worked great.

3Main2MainClass

2MainNULLMainClass

1MainNULLNULL

Not sure what this is...

A dynamic query wouldn't help. The issue isn't the number of parameters I send. It is the result that I get back. I have no way of...

I did find a problem when the schema was blank.

If @tablename = 'Roles', this will return nothing. I thought about using a Case statement but not sure how to...