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 |
bubberz
Constraint Violating Yak Guru
289 Posts |
Posted - 2006-04-28 : 11:26:18
|
I have the follwoing SPROC (it's not working yet):CREATE PROCEDURE [dbo].[usp_UpdateBudgetUpdate] @Budget decimal (18,3), @WPID nvarchar(100), @FY nvarchar(4)ASUPDATE Budget SET WP_Budget.+'@FY'+ = @Budget WHERE Identifier = @WPIDGOThe column WP_Budget.* can either be:WP_Budget.FY04WP_Budget.FY05WP_Budget.FY06WP_Budget.FY07WP_Budget.FY08WP_Budget.FY09WP_Budget.FY10WP_Budget.FY11WP_Budget.FY12WP_Budget.FY13........and up to 20I'd like to not have to create 20 SPROCs.Any suggestions are welcome!Thanks! |
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-04-28 : 11:55:29
|
1 proc. dynamic SQL. |
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2006-04-28 : 12:32:38
|
CREATE PROCEDURE [dbo].[usp_UpdateBudgetUpdate] ( @Budget decimal (18,3), @WPID nvarchar(100), @FY nvarchar(4))ASSET NOCOUNT ONDECLARE @sql VARCHAR(1000)SET @sql = 'UPDATE Budget SET WP_Budget.' + @FY + ' = ' + @Budget + ' WHERE Identifier = ' + @WPIDEXEC (@sql)GOHearty head pats |
|
|
bubberz
Constraint Violating Yak Guru
289 Posts |
Posted - 2006-05-07 : 23:38:35
|
Thanks Bex for the help! |
|
|
|
|
|