Lynn and Steve,

Thanks for your replies. I made it work by moving the view2-related filters from the WHERE clause to the JOIN..ON section, and that solved the issue.

Steve,

View_1 and View_2 are working fine, and give results within seconds, so I am not sure that the linked server is the issue here. it's the third view...

One tiny correction in the code (in case anyone else uses it) - should be:

SELECT N FROM (VALUES(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12))e(N)

There was an extra comma after (12).

Luis C.,

Tested your code, and it is exactly the solution I was looking for! Thanks for your help.

-Amit

Luis Cazares (8/11/2014)

---

This seems horrible because of the triangular join that it includes,...

Hi Luis,

FISCAL_YEAR is an integer, so I'll change that in the...

LutzM (8/11/2014)

---

What are you trying to accomplish here?

It looks like you return the running total balance per month an fiscal year.

Why would you worry about this FY having less than...

Keith,

Thanks for your response and suggestion (duly noted).

Your solution has given me the idea. I need to tinker with a little bit - add a new table with Resetfrequency values...

Thanks, Sean and Lynn! That worked.

Hi Lynn,

I get the following error when I parse your script:

I'm using SQL Server 2008 R2.

Thanks, Lynn and Sean.

Yes, that worked!! 🙂

So can I take way the following as a rule?

"Don't fully qualified the column that needs to be updated (in a scenario like this)."

Thanks,...

Gail,

No triggers on the table ContractData.

"..bhc.coreprocesstoken18 appears nowhere in the update statement."

Oops, sorry about that - I'd changed the alias in the code, but posted the earlier error message...

Sean, the code you provided returned one row of data that included all the columns from table ContractData; and accountnumber, sourcesystem, effectivedate, siccode & coreprocesstoken18 from UDBSourceData for the same...

Lynn, it's a table.

Both the source and the destination tables have the same columns, and I need to update the column coreprocesstoken18 in destination...