sqlquest2575 (11/2/2011)

---

Thank you all for the quick response. I checked the data and i did not see any decimal value. All the data in that column is INT but just...

I skipped right over that Declare + Set and the fact that it was for 2005 and up since I had been doing that kind of set for some time...

overweight

The failed to login sounds like the domain account being used to login wasn't able to talk to AD (assuming AD is involved). That seems to be a highly...

Are you running that combination of queries direct on the server in SSMS? Or are you running it from your desktop?

If direct on the server, you have the memory...

It looks like it may be too many queries and memory on your local machine is inadequate for the extreme number of queries and exec plans.

codebyo (11/2/2011)

---

Wouldn't a pivot table be able to achieve that?

I'm trying to make an example but I'm not being successful because I'm not experience in using that technique.

Perhaps someone more...

L' Eomot Inversé (11/2/2011)

---

No. I owe my recognition of the word to my ability and willingness, when I was young and foolish, to offend...

elkucho (11/2/2011)

---

Thanks for the reply.

So if the records doesn't exist it will do to a OLD DB Destination, right ?

But if it does exist, what is the next component after...

I think he was understanding you to say restore the database from 2005 to 2008....

That means that the RDL files were upgraded to the 2008 version and cannot / will not work in 2005. You should use VS 2005 to edit modify SSRS...

An alternative that would work well would be to stage that data into a "temp" table and then use the merge statement.

Otherwise, what Lynn provided should work.

You will need to specify the number of decimal places unless you convert to a float type. If you convert to Int - there will be 0 decimal places.

As Jared said - we need a lot more info to answer that question. The reporting server needs to be built according to your reporting requirements.

If the databases are at the same version, it is feasible.

However, I prefer to restore the database as a different database name, then import the data that I need.

Or I...