Thanks Jeff. i'll work on it and let you know. Thanks again for all your help.

Hi,

Here's the issue I'm having.

1. the bcp output doesn't include headers

2. the sql is too long to be included in one line. How could I call a .sql file...

It did cross my mind.I'll give this a try.But I would still like to explore the option highlighted.

Any more ideas .

I think this is a good solution. I can address the single character matches manually if i have to . Thanks.

Hi ,

No master table exists. The temporary master table has been posted below. I'll probably create one. So stripping off the FY** values and create a master list and do...

Thank you Sean for your help though. Gotta love this forum and the people here.

I think I have figured this out with an update statement. Wonder if a Merge statement would be a slicker operation on millions of rows.

update b

set b.Dec = b.Dec +...

Hi Sean,

Here I agree it's tough to figure out without background knowledge.

Please see below :

Intersections are a combination of the following below

fund fiscal project account function dept planning special ...

Hi Sean,

I tried give a snapshot of the data. Sorry if it wasn't helpful. here you go. Posting everything again.

yes like running total but I want to move only Nov...

Thanks Chris, your solution is slick and works well.

I have a silly question , just for my understanding

How does you subtraction work when your case has only Value in...

Thanks this works Changed the join to left outer to exclude the null values.

hi erland,

I'm sorry if the requirement was not clear.

I'll rephrase it :

The data is divided by Scenario : Jun (0+12) forecast and Actual.

And every Scenario will have a Fund,...

Any other thoughts guys ?

ck9663 (8/7/2013)

---

Couple of questions:

1. Will it always have, at most, 2 pair of record?

2. Will the resulting record have the period + 1 of the paired records? Will there...

Thanks makes total sense. Didn't realize my right table had duplicates.