Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-19 : 10:31:07
|
| Jay writes "I have 4 reports that are HAND SQL coming from views on a database. We now have a new database, with new views to use for creating the same reports. I need the SQL that was used in the original 4 reports to be modified to reference the new database, and views. Any takers?" |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-04-19 : 14:39:47
|
| If the tables are the same in the new database you can just copy the view as is. What is it that needs modified? |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-19 : 21:24:36
|
i think you've asked this before and the answer is to go into the views, script them out, change the old database name to the new database name... --------------------keeping it simple... |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-04-20 : 01:16:05
|
| In Crystal Reports, there is an option to set Database Location where you can point the required Db. See if you are able to do the same in SSRS alsoMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
mappings