The ParseName function was exactly what I was looking for and irritated that I couldn't find it.

I looked all over the net looking for string functions and none of the...

The reason I am asking is that I am using the following query:

SELECT @IsIdentity = sys.columns.is_identity

FROM sys.columns

JOIN sys.objects

...

Well, they aren't working for me but it isn't an issue since the other one does.

Thanks,

Tom

Actually, the first 2 are not working (as they did before) for me in 2008 but do in 2005. Which is why I posted it. And I did...

The first one gives me an empty set.

The second gives me blanks in my fields.

I did find one that works:

SELECT sys.columns.is_identity

FROM sys.columns

JOIN sys.objects

...

The first one also works in 2005 and not 2008

Tom

That was my problem.

I forgot the parens.

Thanks,

Tom

As you can see, I had come to the same conclusion you mention - dynamic SQL. I was just curious if there was a different way to handle it.

I...

What I am trying to do is try to return the values in certain reference tables. I don't know what the name of the tables are - this is...

The problem is that the 9pt is not what is on the cells, they are all 10pt. Not sure why 9pt is in the code file.

Tom

We have added and deleted columns as the reports were developed. Unfortunately, we can't really start over building them since we have about 30 reports that would be affected.

Seems...

Right - but how would you do that for SSRS?

I am trying to set up my reports to get the Connection string and the Cube to be handled dynamically as...