ALTER procedure  [dbo].[spUpdateServe]
@ServerRequestID int
,@ServerName varchar(100)=null
,@Environment  varchar(100)=null
,@C_Of_CPUs  varchar(100)=null
,@C_OfHardDrives  varchar(100)=null
,@SizeOfHD  varchar(100)=null
,@ServerPurpose  varchar(100)=null
,@ApplicationstoInstall  varchar(100)=null
,@ApplicationName  varchar(100)=null
,@IAP  varchar(100)=null
,@ServerAssetRequestID int=0
,@RAM  varchar(100)=null
,@ClaimedDate datetime=null
,@AcceptedDate datetime=null
,@DeclineDate datetime=null
,@CompletionDate datetime=null
,@Notes varchar(max)=null
,@InfrastructureWWID int=null
,@ValidationStateID int=null
as
begin




		update server
set
 ServerName=case when @ServerName = null then ServerName else @ServerName end
,Environment= case when @Environment = null then Environment else @Environment end
,RAM= case when @RAM = null then RAM else @RAM end
,_Of_CPUs = case when @C_Of_CPUs = null then _Of_CPUs else @C_Of_CPUs end
,_OfHardDrives =  case when @C_OfHardDrives = null then _OfHardDrives else @C_OfHardDrives end
,SizeOfHD = case when @SizeOfHD = null then SizeOfHD else @SizeOfHD end
,ServerPurpose = case when @ServerPurpose = null then ServerPurpose else @ServerPurpose end
,ApplicationstoInstall = case when @ApplicationstoInstall = null then ApplicationstoInstall else @ApplicationstoInstall end
,ApplicationName =  case when @ApplicationName = null then ApplicationName else @ApplicationName end
,IAP = case when @IAP = null then IAP else @IAP end


where ServerID =@ServerRequestID
end