Thanks. That was what I thought but wanted to double check with you all. Unfortunately, the big wig Claims person believes it can be done after the report renders. Says...

Thanks for all the advice. They all would work well if there was any form of procedure and accountability in the company I work with.

I started the job almost 6...

I didn't say anything about viewing the definition of the object I said I can't see it anywhere. I know it must be a function cause I can see it...

I there anyway to automate the creation of the XSD file. Such that when the package runs every time it will create the XSD from the XML.

What I meant to say was everybody worth listening to :). When a person has to go back into their code after being away from it for a while it...

That is pretty much the approach I have been seeing everywhere. So I guess it is the way it is done. I just thought maybe someone would have documented a...

For your better understanding of what I am thinking it would be something like what this article covers but more in-depth - such that a book could be written about....

Love that trick. Nice!

T-SQL and SQL certainly are different. I, therefore, would never assume someone knew TSQL just because they wrote SQL on a resume.

TSQL to me would mean the...

Using the term "Where Filter" is a pretty common way of referring to the WHERE clause conditiional filter. It maybe shorthand'ish but I don't see how anyone without putting any...

herladygeekedness,

Thanks so much for you great answer!

Best Regards..

Yes, I think that does it. That is much simpler and more elegant than what I did. Thanks to you both for your help.

...

I got it to work with creating a temp table and populating that with the results of my RowNumber table. May not be the most savy of code but it...

Thank for the reply Keith. The WHILE LOOP is needed because for each loop through it needs to create a unique company name to be used in the insert statement....

Thank you. That is solid good advice. Your right best not to mess with it until clarification can be achieved.