update [SdkElementAttributeData]
	set TextValue  = coalesce (
                                  convert(nvarchar(4000), TextValue)
                                 ,convert(nvarchar(4000), NumericValue)
                                 ,convert(nvarchar(4000), DateTimeValue)
                                 ,convert(nvarchar(4000), GuidValue)
                                 ,convert(nvarchar(4000), BooleanValue)
                              )
	                                     
go
	  
ALTER TABLE [SdkElementAttributeData]
	drop column NumericValue
go
ALTER TABLE [SdkElementAttributeData]
	drop column DateTimeValue
go
ALTER TABLE [SdkElementAttributeData]
	drop column GuidValue
go
ALTER TABLE [SdkElementAttributeData]
	drop column BooleanValue
go
	 

                

 
