Search results for query: *

I would tend to agree with you, and I've given my recommendation as much...but we will see what they are going to. :-) So how'd ya like that mess of a procedure above^^. LOL Thanks again! RSBLaird

And just to let you see what I DID do to try and get around this...here is the code for the procedure I originally created. Honestly it works great...mainly because the fields we were going for were in alphebetical order (Abbreviation, Code, Description, Name...and none of the tables had only...

Actually I'm a "she"...LOL But yes, SQLSister & Joe...good points made by both of you...and beleive me this whole idea was not mine...I am a contractor...and the client asked for this and believed that MOST of the tables in their database had some sort of standard, (Abbreviation, Name...

Thank you Joe...guess I just needed it spelled out for me...and I must admit, my first reaction to my bosses request was just what you've said...but I am stubborn and was determined to find a way. But I am seeing there's just no way around it. *sigh* But I've learned something new, and will...

I would cry a little, then try again and FIND a way! :-)

As I mentioned "the other day", I do not know the table name ahead of time, it is a variable. How can you write a view on a variable? I didn't think it was possible. The @TableName is a table that varies with the selection in the report. So when you click any given table it's supposed to...

Not sure quite how to even approach this question so feel free to get clarification if I thoroughly confuse...>God knows I AM! Ok... I have a procedure that pulls three columns from any given table. (Variable @TableName) But some of the tables do NOT have the same column name. Example...some...

This could work theoretically...but honestly the three tables I gave as examples, were just that, examples. There are MANY, MANY tables that this has to apply to , and as it is, I don't know which ones have the Abbrv and which ones have the CODE fields...I just know that they are not consistant...

Thank you George, for your input...I appreciate your response. That will definitely help with the dynamic nature of the Table, and I had something similar, but I think your code will be better. and at least I feel better about the SQL Injection potential. Thank you. However, my BIGGEST...

To avoid confusion, I should have made the sample table one of the lookup tables I referred to...so the code should have looked like this instead. I am afraid of 'SQL Injection' problems, but don't know a good way to go about this with out using dynamic SQL. Here's what I need. I am...

I am afraid of 'SQL Injection' problems, but don't know a good way to go about this with out using dynamic SQL. Here's what I need. I am creating a "data dictionary" of sorts. The person who requested this, requested that we put a link within the report (SSRS '05) to another report showing...

Okay, well I feel about 2 inches tall..I hadn't tried this before writing...I just figured out the answer to my own question!! *duh!* You just have to make the "jump to" Parameter link to the "Fields!TaskID.Value" instead of the "Parameters!" one. Sorry for the dumb question. LOL RSBLaird

Somewhat new to SSRS... I'm currently running 2005 version of SQL Reporting Services. I have created a basic summary-type report with individual "Task ID"s. I am to attach the detail report of these tasks to the TaskID field in the summary, so when you click on the Task ID it jumps to the...