MSCRM CRM get picklist field value function solution

There are many picklist fields in the form that do not want to write links stringmap
Code:

Entity ID Query method:
SELECT @ObjectTypeCode from entity where= ' entity name '

To call a function method:
Select Getpicklist (' Field name ', field value, entity ID)

--@AttributeName Field name--@AttributeValue Field Values--@ObjectTypeCode Entity IDCreate functionGetpicklist (@AttributeName varchar( -),@AttributeValue int,@ObjectTypeCode int)returns varchar( -) asbeginDeclare @value varchar( -) SELECT @value=Value fromStringmapwhereAttributeName=@AttributeName  andAttributeValue=@AttributeValue  andObjecttypecode=@ObjectTypeCode  return @valueEnd

MSCRM CRM get picklist field value function solution