Hi Everyone,

I just wanted to tell everyone I figured the issue. The issue was I had the COALESCE in the derived tables once I put the COALESCE function at...

Correct, I started this thread at work. I'll provide the error code, etc.

Thanks,

Hi,

No because it's my work machine and I'm in the middle of setting up the VPN/Network where I work.

In a nutshell there's no infrastructure. I'm currently building...

Hi,

Thanks for the quick reply.

My goal is to setup a reporting table that gets update every week via a DTS or SSIS package:

That would generate a table output like this:

[Company...

I'm trying to create an aggregation of multiple values. Where sometimes the Derive table doesn't return any data. I want to be able to handle no data return. ...

The fields names appear in the XML files like so:

XML File 1

FirstName - John

XML File 2

FName

Sorry that these fieldnames didn't appear in my original message.

Thanks,

Hi,

I appreciate the quick response. Anyhow what was happening was a spelling error on my part for the final sproc. I had

@AcctN0 instead of of @AcctNo. Talk...

Hi,

They track this manually. I was given a matrix layout, which I create a view breaking down the states into Zones (via business rules). Since there is a...

Figured it out. It's not a self-join but rather a cross-join that I need.

Here's my Sql that yields my results:

Select s1.statecode,s1.countrycode + '-' + s1.statecode OriginCode,

s2.countrycode + '-' +...

Thanks answers my question

I have no idea how much "political power" this DBA has. The issue I have with this person or anyone else is he feels having prefix on database objects...

Thanks for the insight. I couldn't believe what I was hearing. What makes me laugh is the control issues I'm facing daily. "That's the way we do...

Personally I rather not deal with the text files at all. I understand about converting to XML the reason I don't do this is because it's still my responsibility...

Yeah, I know people like him are tough to come by. Funny thing is he's my second boss that has left. And I'm talking very high level positions....

Thanks for the information. I just found out that my boss is leaving the company and he's the only one that supports and buys into my design ideas, i.e....