So the issue had something to do with the fact that the view was pulling data from sql2005 and the table had data stored in a 2008 db. When I...

I am almost sure this has to do with the fact that I am updating from a view. I copied the results of the view qeury to excel and reuploaded...

No, I dont think so because the following query works.

select *

from db1.dbo.transactions as t

join db2.dbo.donors as d

on t.TRANSACTIONNUMBER=d.TRANSACTIONNUMBER

So it seems like it is something with the set operator. But I...

Thank you for your reply ron. I am not querying against two tables, one is a view and one is a table. I think this is the problem.

-Danny

Damn, I feel not good. Thank you....(im new)

select orgID, count(distinct indID)

from transactions

group by orgID

The problem is, my count is off. Some employees retired during the year and so they have transactions when they were part of...

Yes, I could try to do this which would make my full query pretty complex.

I was hoping there would be a more simple elegant solution using the OVER clause or...

Thank you Lowell, that is perfect.

I always make small mistakes when I change all the column names before posting to the web. There is an employeeaccountnumber and an orgaccountnumber....

I am sorry, the two queries have the same accountnumber (accountnumber=orgaccoutnnumber).

I have never used a cross join, I will give it a shot. Is there a simpler way to write...

I read through the guide, it doesn't contain any information on migrating shared data sources, only information to migrate an entire reporting services installation, which I dont want to do...

Oh no, I was running this code in sql server 2008 but now have to run it in sql server 2005 which apparently doesn't have the merge command.

I know this...

Yes Jayanth, I finally caught that I had it flipped. And thank you kiwi for that merge statement. It is an improvement on my two merge statements and also outputs...

Hey SQLRNNR! I figured it out using the MERGE statement. I had to create two seperate statements, but thats okay.

When running these large queries, is there any way to spit...

You are right, my first sentence was misleading. Later in my first post I explained "I think part of my problem is that some address ID's dont already have a...

Thanks SQLRNNR,

That query also executes but returns 849 rows. I know there are only 56 rows in the SRC table with ID's that match the TGT table and start with...