USP_SIMPLEDATALIST_VENDORADDRESS

                CREATE procedure dbo.USP_SIMPLEDATALIST_VENDORADDRESS
                (
                  @VENDORID uniqueidentifier
                ) 
                as
                  set nocount on;

                  select ADDRESS.ID as VALUE,
                        case len(coalesce(ADDRESSTYPECODE.DESCRIPTION, ADDRESS.ADDRESSBLOCK))
                          when 0 then 'Incomplete Address ' + CAST(ADDRESS.SEQUENCE AS nvarchar)
                          else 
                              case 
                                  when (ADDRESSTYPECODE.DESCRIPTION) is null then ADDRESS.ADDRESSBLOCK
                                  else ADDRESSTYPECODE.DESCRIPTION + ' - ' + ADDRESS.ADDRESSBLOCK
                              end
                      end
                      as LABEL from dbo.ADDRESS
                      left join dbo.ADDRESSTYPECODE on ADDRESS.ADDRESSTYPECODEID = ADDRESSTYPECODE.ID
                  where
                      ADDRESS.CONSTITUENTID = @VENDORID
                  order by
                      ADDRESS.ISPRIMARY desc, ADDRESS.SEQUENCE;