Thanks, Sean for your feedback....this is a wonderful place for someone like me and by and large the assistance provided here has always been very well-intentioned.....

Sometimes I just don't know...

I'm working on SQL SERVER 2008 R2 platform and using Visual Studio 2008 Business Intelligence Development Studio....

Along with SQL Server Reporting Services - Report Manager for the subscription component...

Perhaps...

I really appreciate the feedback......I'm still very new at all this.....

Do you think you might be able to expand on the differences between columns and fields as they relate to...

I've verified that both the fields I am trying to "concatenate" are string data......I've also discovered that the + operator does not work for these but the || does work....

Thanks...

This also returns data values of '0' in the FullName field.

I'm not sure what you mean by the "create script". The table is in a very large database and contains several hundred thousand records. Sample of the data contained is:

for...

Brandie:

Thanks again for your assistance.....I've got another "quick" question.

Other than the obvious "@Timestamp" method of appending a datetime to the end of a file name, do you know of...

Thank you very much for your assistance......as a "non-programmer" and a REAL newbie.....this has been most helpful.....

Your suggestions have been used and I now find my query working to perfection....

Thanks...

Thanks for your response. I'll give this a try......actually, I inadvertently pasted a modified set of code into the initial post: This is the actual code to retrieve prior...

I appreciate your response.......It is a shame ( actually a "MS" shame) that version backward compatibility remains to be an issue, but then again it IS MICROSOFT).

Being a newbie, I'm...

So when I am ready to "publish" the report created in SSRS and I am choosing the option to Notify by Report Server File Share I am asked for a...

The two are installed on the same developmen environment on a Virtual Server. I'm fairly certain (but will verify) that the two are installed side by side on the same...

Thanks very much for your response....I'll check with my Server Admin folks.......Could this have anything to do with the fact that SQL Server 2005 and SQL Server 2008 are both...