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 |
|
ETTIENNE
Starting Member
2 Posts |
 Posted - 2008-09-15 : 05:41:29
|
| I have created a dynamic sql view to create a view and pivot out all the records from a reference table in a column. This is OK when the view is originally populated, however doesnt work when the reference table is updated. I was thinking a trigger on the reference table to delete and re-created the view? I was just after a reccomendation on a good course of action. Your help is greatly appreciated |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-15 : 05:53:53
|
| you can use sp_refreshview system stored procedure to refresh your view when you table is updated. |
 |
|
|
ETTIENNE
Starting Member
2 Posts |
Posted - 2008-09-15 : 07:16:59
|
| Much Appreciated |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-15 : 12:43:43
|
quote:
Originally posted by ETTIENNE
Much Appreciated
You're welcome  |
|
|
|
|
|
|
Dynamic SQL View On Execute