Amherst Parcel Target Parameters

The following is an example of how to set several targetparams for one layer, in this case the Parcels for Amherst, MA.

Most of these targetparams use the '%' wildcard to allow for an incomplete string to be entered:

[GPV].[GPVTargetParams_Parcels]
  @paramType nvarchar(20),
  @paramId nvarchar(50),
  @userRole nvarchar(20)
  as
if @paramType = 'landuse'
begin
  select MapParId 
  from sde.gisadmin.TOA_CAMA_TABLE
  where LandUse like @paramId + '%'
end
else if @paramType = 'landusecode'
begin
  select MapParId 
  from sde.gisadmin.TOA_CAMA_TABLE
  where LandUseCode like  @paramId + '%'
end
else if @paramType = 'owner'
begin
  select MapParId 
  from sde.gisadmin.TOA_CAMA_TABLE
  where Owner_Name like @paramId + '%'
end
else if @paramType = 'map'
begin
  select MapParId 
  from sde.gisadmin.TOA_CAMA_TABLE
  where map like @paramId + '%'
end
else if @paramType = 'munisprop'
begin
  select MapParId 
  from sde.gisadmin.TOA_CAMA_TABLE
  where REM_PIN like @paramId + '%'
end
else if @paramType = 'septic'
begin
  select PIN 
  from sde.dbo.[TOA_COM_SepticImpairments]
  where Title5 like @paramId 
end
else begin
  select MapParId 
  from sde.gisadmin.TOA_CAMA_TABLE
  where STREET like @paramId + '%'
end