Hello again

Below is the transcript of the trace via the profiler and is a complete trace of the users actions when trying to eneter a record  from start to finish - our IT dept cannot see much wrong, however the error in Recorder still occured.

Andy

SET FMTONLY ON SELECT "Record_Type_Key", "Short_Name" FROM "Record_Type"
WHERE 1=2  SET FMTONLY OFF
go
SELECT "Record_Type_Key", "Short_Name" FROM "Record_Type"

go
SET FMTONLY ON SELECT "Substrate_Key", "Short_Name" FROM "Substrate"
WHERE 1=2  SET FMTONLY OFF
go
SELECT "Substrate_Key", "Short_Name" FROM "Substrate"

go
SET FMTONLY ON SELECT * FROM "SAMPLE_TYPE"
WHERE 1=2  SET FMTONLY OFF
go
SELECT * FROM "SAMPLE_TYPE"

go
select * from RECORD_TYPE
go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_indexes_rowset N'RECORD_TYPE', NULL, NULL
go
SET NO_BROWSETABLE ON
go
select * from SUBSTRATE
go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_indexes_rowset N'SUBSTRATE', NULL, NULL
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT "Specimen_Type_Key", "Short_Name" FROM "Specimen_Type"
WHERE 1=2  SET FMTONLY OFF
go
SELECT "Specimen_Type_Key", "Short_Name" FROM "Specimen_Type"

go
SELECT MEASUREMENT_QUALIFIER_KEY, SHORT_NAME FROM MEASUREMENT_QUALIFIER WHERE MEASUREMENT_TYPE_KEY='NBNSYS0000000004' ORDER BY SHORT_NAME

go
exec sp_executesql N'SELECT "S".SURVEY_KEY, "S".ITEM_NAME FROM "SURVEY" "S"
LEFT JOIN "User_Survey_Restriction" "USR"
     ON "USR"."Survey_Key" = "S"."Survey_Key"
    AND "USR"."Name_Key" = @P1
WHERE "USR"."Name_Key" IS NULL
ORDER BY S.ITEM_NAME
', N'@P1 varchar(16)', 'WA0001570000004M'
go
SELECT "Item_Name" FROM "Taxon_List"
WHERE "Taxon_List_Key" = 'NHMSYS0000871304'

go
SET FMTONLY ON SELECT DISTINCT ITN.Taxon_List_Item_Key, ITN.Abbreviation,        ITN.Authority, TL.Item_Name AS ListName,        dbo.ufn_FormattedSpeciesName( ITN.Actual_Name,                                      ITN.Authority,                                       ITN2.Authority,                                      ITN.Preferred_Name,                                      ITN.Actual_Name_Italic,                                      ITN.Preferred_Name_Italic,                                       TV.Attribute,                                      TR.Short_Name) AS ItemName FROM (Index_Taxon_Name ITN INNER JOIN Taxon_List_Version TLV ON TLV.Taxon_List_Version_Key = ITN.Taxon_List_Version_Key) INNER JOIN Taxon_List TL ON TL.Taxon_List_Key = TLV.Taxon_List_Key INNER JOIN Taxon_List_Item TLI ON TLI.Taxon_List_Item_Key = ITN.Taxon_List_Item_Key INNER JOIN Taxon_Version TV ON TV.Taxon_Version_Key = TLI.Taxon_Version_Key INNER JOIN Taxon_Rank TR ON TR.Taxon_Rank_Key = TLI.Taxon_Rank_Key INNER JOIN Index_Taxon_Name ITN2 ON ITN2.Taxon_List_Item_Key    = TLI.Preferred_Name WHERE (ITN.Actual_Name LIKE 'pa%' OR ITN.Abbreviation LIKE 'pa%' OR ITN.Authority LIKE 'pa%')  AND ITN.Preferred_List=1 AND TLI.Taxon_List_Version_To IS NULL  AND TLV.Version >= (SELECT MAX(Version)    FROM Taxon_List_Version     WHERE Taxon_List_Key = (SELECT Taxon_List_Key From Taxon_List_Version WHERE Taxon_List_Version_Key = TLV.Taxon_List_Version_Key) AND Version_Is_Amendment = 0)
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
SELECT DISTINCT ITN.Taxon_List_Item_Key, ITN.Abbreviation,        ITN.Authority, TL.Item_Name AS ListName,        dbo.ufn_FormattedSpeciesName( ITN.Actual_Name,                                      ITN.Authority,                                       ITN2.Authority,                                      ITN.Preferred_Name,                                      ITN.Actual_Name_Italic,                                      ITN.Preferred_Name_Italic,                                       TV.Attribute,                                      TR.Short_Name) AS ItemName FROM (Index_Taxon_Name ITN INNER JOIN Taxon_List_Version TLV ON TLV.Taxon_List_Version_Key = ITN.Taxon_List_Version_Key) INNER JOIN Taxon_List TL ON TL.Taxon_List_Key = TLV.Taxon_List_Key INNER JOIN Taxon_List_Item TLI ON TLI.Taxon_List_Item_Key = ITN.Taxon_List_Item_Key INNER JOIN Taxon_Version TV ON TV.Taxon_Version_Key = TLI.Taxon_Version_Key INNER JOIN Taxon_Rank TR ON TR.Taxon_Rank_Key = TLI.Taxon_Rank_Key INNER JOIN Index_Taxon_Name ITN2 ON ITN2.Taxon_List_Item_Key    = TLI.Preferred_Name WHERE (ITN.Actual_Name LIKE 'pa%' OR ITN.Abbreviation LIKE 'pa%' OR ITN.Authority LIKE 'pa%')  AND ITN.Preferred_List=1 AND TLI.Taxon_List_Version_To IS NULL  AND TLV.Version >= (SELECT MAX(Version)    FROM Taxon_List_Version     WHERE Taxon_List_Key = (SELECT Taxon_List_Key From Taxon_List_Version WHERE Taxon_List_Version_Key = TLV.Taxon_List_Version_Key) AND Version_Is_Amendment = 0)

go
SELECT DISTINCT ITN.Taxon_List_Item_Key, ITN.Abbreviation,        ITN.Authority, TL.Item_Name AS ListName,        dbo.ufn_FormattedSpeciesName( ITN.Actual_Name,                                      ITN.Authority,                                       ITN2.Authority,                                      ITN.Preferred_Name,                                      ITN.Actual_Name_Italic,                                      ITN.Preferred_Name_Italic,                                       TV.Attribute,                                      TR.Short_Name) AS ItemName FROM (Index_Taxon_Name ITN INNER JOIN Taxon_List_Version TLV ON TLV.Taxon_List_Version_Key = ITN.Taxon_List_Version_Key) INNER JOIN Taxon_List TL ON TL.Taxon_List_Key = TLV.Taxon_List_Key INNER JOIN Taxon_List_Item TLI ON TLI.Taxon_List_Item_Key = ITN.Taxon_List_Item_Key INNER JOIN Taxon_Version TV ON TV.Taxon_Version_Key = TLI.Taxon_Version_Key INNER JOIN Taxon_Rank TR ON TR.Taxon_Rank_Key = TLI.Taxon_Rank_Key INNER JOIN Index_Taxon_Name ITN2 ON ITN2.Taxon_List_Item_Key    = TLI.Preferred_Name WHERE (ITN.Actual_Name LIKE 'pa%' OR ITN.Abbreviation LIKE 'pa%' OR ITN.Authority LIKE 'pa%')  AND ITN.Preferred_List=1 AND TLI.Taxon_List_Version_To IS NULL  AND TLV.Version >= (SELECT MAX(Version)    FROM Taxon_List_Version     WHERE Taxon_List_Key = (SELECT Taxon_List_Key From Taxon_List_Version WHERE Taxon_List_Version_Key = TLV.Taxon_List_Version_Key) AND Version_Is_Amendment = 0)

go
SELECT "Item_Name" FROM "Taxon_List"
WHERE "Taxon_List_Key" = 'NHMSYS0000871304'

go
SELECT DISTINCT ITN.Taxon_List_Item_Key, ITN.Abbreviation,        ITN.Authority, TL.Item_Name AS ListName,        dbo.ufn_FormattedSpeciesName( ITN.Actual_Name,                                      ITN.Authority,                                       ITN2.Authority,                                      ITN.Preferred_Name,                                      ITN.Actual_Name_Italic,                                      ITN.Preferred_Name_Italic,                                       TV.Attribute,                                      TR.Short_Name) AS ItemName FROM (Index_Taxon_Name ITN INNER JOIN Taxon_List_Version TLV ON TLV.Taxon_List_Version_Key = ITN.Taxon_List_Version_Key) INNER JOIN Taxon_List TL ON TL.Taxon_List_Key = TLV.Taxon_List_Key INNER JOIN Taxon_List_Item TLI ON TLI.Taxon_List_Item_Key = ITN.Taxon_List_Item_Key INNER JOIN Taxon_Version TV ON TV.Taxon_Version_Key = TLI.Taxon_Version_Key INNER JOIN Taxon_Rank TR ON TR.Taxon_Rank_Key = TLI.Taxon_Rank_Key INNER JOIN Index_Taxon_Name ITN2 ON ITN2.Taxon_List_Item_Key    = TLI.Preferred_Name WHERE (ITN.Actual_Name LIKE 'pa%' OR ITN.Abbreviation LIKE 'pa%' OR ITN.Authority LIKE 'pa%')  AND ITN.Preferred_List=1 AND TLI.Taxon_List_Version_To IS NULL  AND TLV.Version >= (SELECT MAX(Version)    FROM Taxon_List_Version     WHERE Taxon_List_Key = (SELECT Taxon_List_Key From Taxon_List_Version WHERE Taxon_List_Version_Key = TLV.Taxon_List_Version_Key) AND Version_Is_Amendment = 0)

go
SELECT DISTINCT ITN.Taxon_List_Item_Key, ITN.Abbreviation,        ITN.Authority, TL.Item_Name AS ListName,        dbo.ufn_FormattedSpeciesName( ITN.Actual_Name,                                      ITN.Authority,                                       ITN2.Authority,                                      ITN.Preferred_Name,                                      ITN.Actual_Name_Italic,                                      ITN.Preferred_Name_Italic,                                       TV.Attribute,                                      TR.Short_Name) AS ItemName FROM (Index_Taxon_Name ITN INNER JOIN Taxon_List_Version TLV ON TLV.Taxon_List_Version_Key = ITN.Taxon_List_Version_Key) INNER JOIN Taxon_List TL ON TL.Taxon_List_Key = TLV.Taxon_List_Key INNER JOIN Taxon_List_Item TLI ON TLI.Taxon_List_Item_Key = ITN.Taxon_List_Item_Key INNER JOIN Taxon_Version TV ON TV.Taxon_Version_Key = TLI.Taxon_Version_Key INNER JOIN Taxon_Rank TR ON TR.Taxon_Rank_Key = TLI.Taxon_Rank_Key INNER JOIN Index_Taxon_Name ITN2 ON ITN2.Taxon_List_Item_Key    = TLI.Preferred_Name WHERE (ITN.Actual_Name LIKE 'pa%' OR ITN.Abbreviation LIKE 'pa%' OR ITN.Authority LIKE 'pa%')  AND ITN.Preferred_List=1 AND TLI.Taxon_List_Version_To IS NULL  AND TLV.Version >= (SELECT MAX(Version)    FROM Taxon_List_Version     WHERE Taxon_List_Key = (SELECT Taxon_List_Key From Taxon_List_Version WHERE Taxon_List_Version_Key = TLV.Taxon_List_Version_Key) AND Version_Is_Amendment = 0)

go
SELECT DISTINCT TLI.Preferred_Name AS Preferred_Name_Key, ITN.Preferred_Name, ITN.Preferred_Name_Italic, ITN.Common_Name, ITN.Common_Name_Italic, ITN.Actual_Name, ITN.Actual_Name_Italic, ITN.Authority, TLV.Taxon_List_Key, TV.Attribute, TR.Short_Name AS RankName
FROM Index_Taxon_Name ITN JOIN Taxon_List_Item TLI ON TLI.Taxon_List_Item_Key = ITN.Taxon_List_Item_Key JOIN Taxon_List_Version TLV ON TLV.Taxon_List_Version_Key = ITN.Taxon_List_Version_Key
JOIN Taxon_Version TV ON TV.Taxon_Version_Key = TLI.Taxon_Version_Key JOIN Taxon_Rank TR ON TR.Taxon_Rank_Key = TLI.Taxon_Rank_Key
WHERE ITN.Taxon_List_Item_Key = 'NHMSYS0000499023'

go
SET NO_BROWSETABLE OFF
go
SELECT Allow_Data_Entry FROM Index_Taxon_Name WHERE Taxon_List_Item_Key='NHMSYS0000499023'
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT L.Location_Key, LN.Item_Name, System_Supplied_Data FROM Location AS L INNER JOIN Location_Name AS LN ON L.Location_Key = LN.Location_Key WHERE L.Parent_Key IS NULL AND   LN.Preferred = 1  ORDER BY LN.Item_Name WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
SET NO_BROWSETABLE OFF
go
SELECT L.Location_Key, LN.Item_Name, System_Supplied_Data FROM Location AS L INNER JOIN Location_Name AS LN ON L.Location_Key = LN.Location_Key WHERE L.Parent_Key IS NULL AND   LN.Preferred = 1  ORDER BY LN.Item_Name
go
SELECT TOP 1 1 FROM [LOCATION] WHERE [LOCATION_Key] = 'WA00015700000025'
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT * FROM "Location_Type"
order By SHORT_NAME
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
SELECT * FROM "Location_Type"
order By SHORT_NAME

go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_procedure_params_rowset N'usp_GetSiteID', 1, NULL, NULL
go
declare @P1 varchar(8)
set @P1=NULL
exec usp_GetSiteID @P1 output
select @P1
go
SET FMTONLY ON select "Location_Key" from  "Location_Name" WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT * FROM "Location_Name"
WHERE "Location_Key" = ' '
ORDER BY Item_Name
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT * FROM "Location_Name"
WHERE "Location_Key" = @P1
ORDER BY Item_Name
', N'@P1 varchar(16)', NULL
go
SET FMTONLY ON select Location_Key from  Location_Name WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_procedure_params_rowset N'usp_GetSiteID', 1, NULL, NULL
go
declare @P1 varchar(8)
set @P1=NULL
exec usp_GetSiteID @P1 output
select @P1
go
SET FMTONLY ON select "LD"."Location_Key" from  "Location_Designation" AS "LD" INNER JOIN
          "Site_Status" AS "S" ON "LD"."Site_Status_Key" = "S"."Site_Status_Key" WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT "S".Short_Name, "LD".* FROM "Location_Designation" AS "LD" INNER JOIN
          "Site_Status" AS "S" ON "LD"."Site_Status_Key" = "S"."Site_Status_Key"
WHERE "LD"."Location_Key" = ' '
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT "S".Short_Name, "LD".* FROM "Location_Designation" AS "LD" INNER JOIN
          "Site_Status" AS "S" ON "LD"."Site_Status_Key" = "S"."Site_Status_Key"
WHERE "LD"."Location_Key" = @P1
', N'@P1 varchar(16)', NULL
go
SET FMTONLY ON select LD.Location_Key from  Location_Designation AS LD INNER JOIN
          Site_Status AS S ON LD.Site_Status_Key = S.Site_Status_Key WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
SET FMTONLY ON select DT.[Master_Key] from  ((Measurement_Type AS MT
  INNER JOIN Measurement_Qualifier AS MQ
  ON MT.Measurement_Type_Key = MQ.Measurement_Type_Key)
  INNER JOIN Measurement_Unit AS MU
  ON MT.Measurement_Type_Key = MU.Measurement_Type_Key)
  INNER JOIN [DataTable] AS DT
  ON (MU.Measurement_Unit_Key = DT.Measurement_Unit_Key)
     AND (MQ.Measurement_Qualifier_Key = DT.Measurement_Qualifier_Key) WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
SET FMTONLY ON select DT.[Master_Key] from  ((Measurement_Type AS MT
  INNER JOIN Measurement_Qualifier AS MQ
  ON MT.Measurement_Type_Key = MQ.Measurement_Type_Key)
  INNER JOIN Measurement_Unit AS MU
  ON MT.Measurement_Type_Key = MU.Measurement_Type_Key)
  INNER JOIN LOCATION_DATA AS DT
  ON (MU.Measurement_Unit_Key = DT.Measurement_Unit_Key)
     AND (MQ.Measurement_Qualifier_Key = DT.Measurement_Qualifier_Key) WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
SET FMTONLY ON select DT.LOCATION_Key from  ((Measurement_Type AS MT
  INNER JOIN Measurement_Qualifier AS MQ
  ON MT.Measurement_Type_Key = MQ.Measurement_Type_Key)
  INNER JOIN Measurement_Unit AS MU
  ON MT.Measurement_Type_Key = MU.Measurement_Type_Key)
  INNER JOIN LOCATION_DATA AS DT
  ON (MU.Measurement_Unit_Key = DT.Measurement_Unit_Key)
     AND (MQ.Measurement_Qualifier_Key = DT.Measurement_Qualifier_Key) WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select LOCATION_Key from  LOCATION_DATA WHERE 1=2  SET FMTONLY OFF
go
exec [NBNData]..sp_procedure_params_rowset N'usp_GetSiteID', 1, NULL, NULL
go
declare @P1 varchar(8)
set @P1=NULL
exec usp_GetSiteID @P1 output
select @P1
go
SET FMTONLY ON select "DT"."LOCATION_Key" from  (("Measurement_Type" AS "MT"
  INNER JOIN "Measurement_Qualifier" AS "MQ"
  ON "MT"."Measurement_Type_Key" = "MQ"."Measurement_Type_Key")
  INNER JOIN "Measurement_Unit" AS "MU"
  ON "MT"."Measurement_Type_Key" = "MU"."Measurement_Type_Key")
  INNER JOIN "LOCATION_DATA" AS "DT"
  ON ("MU"."Measurement_Unit_Key" = "DT"."Measurement_Unit_Key")
     AND ("MQ"."Measurement_Qualifier_Key" = "DT"."Measurement_Qualifier_Key") WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT "DT"."LOCATION_DATA_Key" AS "Data_Key", "DT".Custodian, "DT".Data, "DT".Accuracy, "DT".Changed_By, "DT".Changed_Date, "DT".Measurement_Qualifier_Key, "MQ"."Short_Name" AS "Qualifier_Short_Name", "DT".Measurement_Unit_Key, "MU"."Short_Name" AS "Unit_Short_Name", "MT".Measurement_Type_Key, "MT"."Short_Name" AS "Type_Short_Name", "DT".Entered_By FROM (("Measurement_Type" AS "MT"
  INNER JOIN "Measurement_Qualifier" AS "MQ"
  ON "MT"."Measurement_Type_Key" = "MQ"."Measurement_Type_Key")
  INNER JOIN "Measurement_Unit" AS "MU"
  ON "MT"."Measurement_Type_Key" = "MU"."Measurement_Type_Key")
  INNER JOIN "LOCATION_DATA" AS "DT"
  ON ("MU"."Measurement_Unit_Key" = "DT"."Measurement_Unit_Key")
     AND ("MQ"."Measurement_Qualifier_Key" = "DT"."Measurement_Qualifier_Key")
WHERE "DT"."LOCATION_Key"
= ' '
ORDER BY MT.Short_Name, MQ.Short_Name, DT.Data, MU.Short_Name, DT.Accuracy
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT "DT"."LOCATION_DATA_Key" AS "Data_Key", "DT".Custodian, "DT".Data, "DT".Accuracy, "DT".Changed_By, "DT".Changed_Date, "DT".Measurement_Qualifier_Key, "MQ"."Short_Name" AS "Qualifier_Short_Name", "DT".Measurement_Unit_Key, "MU"."Short_Name" AS "Unit_Short_Name", "MT".Measurement_Type_Key, "MT"."Short_Name" AS "Type_Short_Name", "DT".Entered_By FROM (("Measurement_Type" AS "MT"
  INNER JOIN "Measurement_Qualifier" AS "MQ"
  ON "MT"."Measurement_Type_Key" = "MQ"."Measurement_Type_Key")
  INNER JOIN "Measurement_Unit" AS "MU"
  ON "MT"."Measurement_Type_Key" = "MU"."Measurement_Type_Key")
  INNER JOIN "LOCATION_DATA" AS "DT"
  ON ("MU"."Measurement_Unit_Key" = "DT"."Measurement_Unit_Key")
     AND ("MQ"."Measurement_Qualifier_Key" = "DT"."Measurement_Qualifier_Key")
WHERE "DT"."LOCATION_Key"
= @P1
ORDER BY MT.Short_Name, MQ.Short_Name, DT.Data, MU.Short_Name, DT.Accuracy
', N'@P1 varchar(16)', ''
go
SET FMTONLY ON select DT.LOCATION_Key from  ((Measurement_Type AS MT
  INNER JOIN Measurement_Qualifier AS MQ
  ON MT.Measurement_Type_Key = MQ.Measurement_Type_Key)
  INNER JOIN Measurement_Unit AS MU
  ON MT.Measurement_Type_Key = MU.Measurement_Type_Key)
  INNER JOIN LOCATION_DATA AS DT
  ON (MU.Measurement_Unit_Key = DT.Measurement_Unit_Key)
     AND (MQ.Measurement_Qualifier_Key = DT.Measurement_Qualifier_Key) WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_procedure_params_rowset N'usp_GetSiteID', 1, NULL, NULL
go
declare @P1 varchar(8)
set @P1=NULL
exec usp_GetSiteID @P1 output
select @P1
go
SET FMTONLY ON select "LOCATION_KEY" from  "LOCATION_ADMIN_AREAS" WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT * FROM "LOCATION_ADMIN_AREAS"
WHERE "LOCATION_KEY" = ' '
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT * FROM "LOCATION_ADMIN_AREAS"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', NULL
go
SET FMTONLY ON select LOCATION_KEY from  LOCATION_ADMIN_AREAS WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_procedure_params_rowset N'usp_GetSiteID', 1, NULL, NULL
go
declare @P1 varchar(8)
set @P1=NULL
exec usp_GetSiteID @P1 output
select @P1
go
SET FMTONLY ON select "LOCATION_KEY" from  "GRID_SQUARE" WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT * FROM "GRID_SQUARE"
WHERE "LOCATION_KEY" = ' '
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT * FROM "GRID_SQUARE"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', NULL
go
SET FMTONLY ON select LOCATION_KEY from  GRID_SQUARE WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_procedure_params_rowset N'usp_GetSiteID', 1, NULL, NULL
go
declare @P1 varchar(8)
set @P1=NULL
exec usp_GetSiteID @P1 output
select @P1
go
SET FMTONLY ON select "LOCATION_KEY" from  "LAND_PARCEL" WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT * FROM "LAND_PARCEL"
WHERE "LOCATION_KEY" = ' '
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT * FROM "LAND_PARCEL"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', NULL
go
SET FMTONLY ON select LOCATION_KEY from  LAND_PARCEL WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_procedure_params_rowset N'usp_GetSiteID', 1, NULL, NULL
go
declare @P1 varchar(8)
set @P1=NULL
exec usp_GetSiteID @P1 output
select @P1
go
SET FMTONLY ON select "LOCATION_KEY" from  "LOCATION_BOUNDARY" WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT * FROM "LOCATION_BOUNDARY"
WHERE "LOCATION_KEY" = ' '
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT * FROM "LOCATION_BOUNDARY"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', NULL
go
SET FMTONLY ON select LOCATION_KEY from  LOCATION_BOUNDARY WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_procedure_params_rowset N'usp_GetSiteID', 1, NULL, NULL
go
declare @P1 varchar(8)
set @P1=NULL
exec usp_GetSiteID @P1 output
select @P1
go
SET FMTONLY ON select "LOCATION_KEY_1" from  "LOCATION_RELATION" WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT * FROM "LOCATION_RELATION"
WHERE "LOCATION_KEY_1" = ' '
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT * FROM "LOCATION_RELATION"
WHERE "LOCATION_KEY_1" = @P1
', N'@P1 varchar(16)', NULL
go
SET FMTONLY ON select LOCATION_KEY_1 from  LOCATION_RELATION WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_procedure_params_rowset N'usp_GetSiteID', 1, NULL, NULL
go
declare @P1 varchar(8)
set @P1=NULL
exec usp_GetSiteID @P1 output
select @P1
go
SET FMTONLY ON select "LOCATION_KEY" from  "LOCATION_USE" WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT * FROM "LOCATION_USE"
WHERE "LOCATION_KEY" = ' '
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT * FROM "LOCATION_USE"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', NULL
go
SET FMTONLY ON select LOCATION_KEY from  LOCATION_USE WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_procedure_params_rowset N'usp_GetSiteID', 1, NULL, NULL
go
declare @P1 varchar(8)
set @P1=NULL
exec usp_GetSiteID @P1 output
select @P1
go
SET FMTONLY ON select "LOCATION_KEY" from  "TENURE" WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT * FROM "TENURE"
WHERE "LOCATION_KEY" = ' '
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT * FROM "TENURE"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', NULL
go
SET FMTONLY ON select LOCATION_KEY from  TENURE WHERE 1=2  SET FMTONLY OFF
go
select * from TENURE_TYPE
go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_indexes_rowset N'TENURE_TYPE', NULL, NULL
go
EXECUTE usp_Polygon_Layers_Get
go
SET FMTONLY ON select "Location_Key" from  "Location" WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT * FROM "Location"
WHERE "Location_Key" = ' '
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT * FROM "Location"
WHERE "Location_Key" = @P1
', N'@P1 varchar(16)', 'WA00015700000025'
go
SET FMTONLY ON select "Location_Key" from  "Location_Name" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "Location_Name"
WHERE "Location_Key" = @P1
ORDER BY Item_Name
', N'@P1 varchar(16)', 'WA00015700000025'
go
SET FMTONLY ON select Location_Key from  Location_Name WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON SELECT * FROM "Site_Status"
ORDER BY Short_Name
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
SELECT * FROM "Site_Status"
ORDER BY Short_Name

go
SET FMTONLY ON select "LD"."Location_Key" from  "Location_Designation" AS "LD" INNER JOIN
          "Site_Status" AS "S" ON "LD"."Site_Status_Key" = "S"."Site_Status_Key" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT "S".Short_Name, "LD".* FROM "Location_Designation" AS "LD" INNER JOIN
          "Site_Status" AS "S" ON "LD"."Site_Status_Key" = "S"."Site_Status_Key"
WHERE "LD"."Location_Key" = @P1
', N'@P1 varchar(16)', 'WA00015700000025'
go
SET FMTONLY ON select LD.Location_Key from  Location_Designation AS LD INNER JOIN
          Site_Status AS S ON LD.Site_Status_Key = S.Site_Status_Key WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "DT"."LOCATION_Key" from  (("Measurement_Type" AS "MT"
  INNER JOIN "Measurement_Qualifier" AS "MQ"
  ON "MT"."Measurement_Type_Key" = "MQ"."Measurement_Type_Key")
  INNER JOIN "Measurement_Unit" AS "MU"
  ON "MT"."Measurement_Type_Key" = "MU"."Measurement_Type_Key")
  INNER JOIN "LOCATION_DATA" AS "DT"
  ON ("MU"."Measurement_Unit_Key" = "DT"."Measurement_Unit_Key")
     AND ("MQ"."Measurement_Qualifier_Key" = "DT"."Measurement_Qualifier_Key") WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT "DT"."LOCATION_DATA_Key" AS "Data_Key", "DT".Custodian, "DT".Data, "DT".Accuracy, "DT".Changed_By, "DT".Changed_Date, "DT".Measurement_Qualifier_Key, "MQ"."Short_Name" AS "Qualifier_Short_Name", "DT".Measurement_Unit_Key, "MU"."Short_Name" AS "Unit_Short_Name", "MT".Measurement_Type_Key, "MT"."Short_Name" AS "Type_Short_Name", "DT".Entered_By FROM (("Measurement_Type" AS "MT"
  INNER JOIN "Measurement_Qualifier" AS "MQ"
  ON "MT"."Measurement_Type_Key" = "MQ"."Measurement_Type_Key")
  INNER JOIN "Measurement_Unit" AS "MU"
  ON "MT"."Measurement_Type_Key" = "MU"."Measurement_Type_Key")
  INNER JOIN "LOCATION_DATA" AS "DT"
  ON ("MU"."Measurement_Unit_Key" = "DT"."Measurement_Unit_Key")
     AND ("MQ"."Measurement_Qualifier_Key" = "DT"."Measurement_Qualifier_Key")
WHERE "DT"."LOCATION_Key"
= @P1
ORDER BY MT.Short_Name, MQ.Short_Name, DT.Data, MU.Short_Name, DT.Accuracy
', N'@P1 varchar(16)', 'WA00015700000025'
go
SET FMTONLY ON select DT.LOCATION_Key from  ((Measurement_Type AS MT
  INNER JOIN Measurement_Qualifier AS MQ
  ON MT.Measurement_Type_Key = MQ.Measurement_Type_Key)
  INNER JOIN Measurement_Unit AS MU
  ON MT.Measurement_Type_Key = MU.Measurement_Type_Key)
  INNER JOIN LOCATION_DATA AS DT
  ON (MU.Measurement_Unit_Key = DT.Measurement_Unit_Key)
     AND (MQ.Measurement_Qualifier_Key = DT.Measurement_Qualifier_Key) WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY" from  "LOCATION_ADMIN_AREAS" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "LOCATION_ADMIN_AREAS"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', 'WA00015700000025'
go
SET FMTONLY ON SELECT * FROM [ADMIN_AREA] WHERE ADMIN_AREA_KEY = 'NBNSYS0000000886'
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
SELECT * FROM [ADMIN_AREA] WHERE ADMIN_AREA_KEY = 'NBNSYS0000000886'

go
SELECT * FROM [ADMIN_TYPE] WHERE ADMIN_TYPE_KEY = 'NBNSYS0000000032'

go
SET FMTONLY ON select LOCATION_KEY from  LOCATION_ADMIN_AREAS WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY" from  "GRID_SQUARE" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "GRID_SQUARE"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', 'WA00015700000025'
go
SET FMTONLY ON select LOCATION_KEY from  GRID_SQUARE WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY" from  "LAND_PARCEL" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "LAND_PARCEL"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', 'WA00015700000025'
go
SET FMTONLY ON select LOCATION_KEY from  LAND_PARCEL WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY" from  "LOCATION_BOUNDARY" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "LOCATION_BOUNDARY"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', 'WA00015700000025'
go
SET FMTONLY ON select LOCATION_KEY from  LOCATION_BOUNDARY WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY_1" from  "LOCATION_RELATION" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "LOCATION_RELATION"
WHERE "LOCATION_KEY_1" = @P1
', N'@P1 varchar(16)', 'WA00015700000025'
go
SET FMTONLY ON select LOCATION_KEY_1 from  LOCATION_RELATION WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY" from  "LOCATION_USE" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "LOCATION_USE"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', 'WA00015700000025'
go
SET FMTONLY ON select LOCATION_KEY from  LOCATION_USE WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY" from  "TENURE" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "TENURE"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', 'WA00015700000025'
go
SET FMTONLY ON select LOCATION_KEY from  TENURE WHERE 1=2  SET FMTONLY OFF
go
SELECT * FROM "Location_Type"
order By SHORT_NAME

go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_procedure_params_rowset N'usp_LastSurveyEvent_ForLocation_Select', 1, NULL, NULL
go
exec usp_LastSurveyEvent_ForLocation_Select 'WA00015700000025'
go
SELECT L.Location_Key, LN.Item_Name, System_Supplied_Data FROM Location AS L INNER JOIN Location_Name AS LN ON L.Location_Key = LN.Location_Key WHERE L.Parent_Key ='WA0001570000002B' AND   LN.Preferred = 1  ORDER BY LN.Item_Name
go
SELECT F.Location_Feature_Key,                     F.Item_Name,                     FT.Short_Name FROM (Location_Feature AS F LEFT JOIN Location_Feature_Grading AS FG ON        F.Feature_Grading_Key = FG.Feature_Grading_Key) LEFT JOIN Location_Feature_Type AS FT ON        FG.Location_Feature_Type_Key = FT.Location_Feature_Type_Key WHERE F.Location_Key = 'WA0001570000002B'  ORDER BY F.Item_Name, FT.Short_Name
go
SELECT TOP 1 1 FROM [LOCATION] WHERE [LOCATION_Key] = 'WA0001570000003G'
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON select Location_Key from  Location WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "Location_Key" from  "Location" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "Location"
WHERE "Location_Key" = @P1
', N'@P1 varchar(16)', 'WA0001570000003G'
go
SET FMTONLY ON select "Location_Key" from  "Location_Name" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "Location_Name"
WHERE "Location_Key" = @P1
ORDER BY Item_Name
', N'@P1 varchar(16)', 'WA0001570000003G'
go
SET FMTONLY ON select Location_Key from  Location_Name WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LD"."Location_Key" from  "Location_Designation" AS "LD" INNER JOIN
          "Site_Status" AS "S" ON "LD"."Site_Status_Key" = "S"."Site_Status_Key" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT "S".Short_Name, "LD".* FROM "Location_Designation" AS "LD" INNER JOIN
          "Site_Status" AS "S" ON "LD"."Site_Status_Key" = "S"."Site_Status_Key"
WHERE "LD"."Location_Key" = @P1
', N'@P1 varchar(16)', 'WA0001570000003G'
go
SET FMTONLY ON select LD.Location_Key from  Location_Designation AS LD INNER JOIN
          Site_Status AS S ON LD.Site_Status_Key = S.Site_Status_Key WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "DT"."LOCATION_Key" from  (("Measurement_Type" AS "MT"
  INNER JOIN "Measurement_Qualifier" AS "MQ"
  ON "MT"."Measurement_Type_Key" = "MQ"."Measurement_Type_Key")
  INNER JOIN "Measurement_Unit" AS "MU"
  ON "MT"."Measurement_Type_Key" = "MU"."Measurement_Type_Key")
  INNER JOIN "LOCATION_DATA" AS "DT"
  ON ("MU"."Measurement_Unit_Key" = "DT"."Measurement_Unit_Key")
     AND ("MQ"."Measurement_Qualifier_Key" = "DT"."Measurement_Qualifier_Key") WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT "DT"."LOCATION_DATA_Key" AS "Data_Key", "DT".Custodian, "DT".Data, "DT".Accuracy, "DT".Changed_By, "DT".Changed_Date, "DT".Measurement_Qualifier_Key, "MQ"."Short_Name" AS "Qualifier_Short_Name", "DT".Measurement_Unit_Key, "MU"."Short_Name" AS "Unit_Short_Name", "MT".Measurement_Type_Key, "MT"."Short_Name" AS "Type_Short_Name", "DT".Entered_By FROM (("Measurement_Type" AS "MT"
  INNER JOIN "Measurement_Qualifier" AS "MQ"
  ON "MT"."Measurement_Type_Key" = "MQ"."Measurement_Type_Key")
  INNER JOIN "Measurement_Unit" AS "MU"
  ON "MT"."Measurement_Type_Key" = "MU"."Measurement_Type_Key")
  INNER JOIN "LOCATION_DATA" AS "DT"
  ON ("MU"."Measurement_Unit_Key" = "DT"."Measurement_Unit_Key")
     AND ("MQ"."Measurement_Qualifier_Key" = "DT"."Measurement_Qualifier_Key")
WHERE "DT"."LOCATION_Key"
= @P1
ORDER BY MT.Short_Name, MQ.Short_Name, DT.Data, MU.Short_Name, DT.Accuracy
', N'@P1 varchar(16)', 'WA0001570000003G'
go
SET FMTONLY ON select DT.LOCATION_Key from  ((Measurement_Type AS MT
  INNER JOIN Measurement_Qualifier AS MQ
  ON MT.Measurement_Type_Key = MQ.Measurement_Type_Key)
  INNER JOIN Measurement_Unit AS MU
  ON MT.Measurement_Type_Key = MU.Measurement_Type_Key)
  INNER JOIN LOCATION_DATA AS DT
  ON (MU.Measurement_Unit_Key = DT.Measurement_Unit_Key)
     AND (MQ.Measurement_Qualifier_Key = DT.Measurement_Qualifier_Key) WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY" from  "LOCATION_ADMIN_AREAS" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "LOCATION_ADMIN_AREAS"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', 'WA0001570000003G'
go
SET FMTONLY ON select LOCATION_KEY from  LOCATION_ADMIN_AREAS WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY" from  "GRID_SQUARE" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "GRID_SQUARE"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', 'WA0001570000003G'
go
SET FMTONLY ON select LOCATION_KEY from  GRID_SQUARE WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY" from  "LAND_PARCEL" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "LAND_PARCEL"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', 'WA0001570000003G'
go
SET FMTONLY ON select LOCATION_KEY from  LAND_PARCEL WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY" from  "LOCATION_BOUNDARY" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "LOCATION_BOUNDARY"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', 'WA0001570000003G'
go
SET FMTONLY ON select LOCATION_KEY from  LOCATION_BOUNDARY WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY_1" from  "LOCATION_RELATION" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "LOCATION_RELATION"
WHERE "LOCATION_KEY_1" = @P1
', N'@P1 varchar(16)', 'WA0001570000003G'
go
SET FMTONLY ON select LOCATION_KEY_1 from  LOCATION_RELATION WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY" from  "LOCATION_USE" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "LOCATION_USE"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', 'WA0001570000003G'
go
SET FMTONLY ON select LOCATION_KEY from  LOCATION_USE WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "LOCATION_KEY" from  "TENURE" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "TENURE"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', 'WA0001570000003G'
go
SET FMTONLY ON select LOCATION_KEY from  TENURE WHERE 1=2  SET FMTONLY OFF
go
SELECT * FROM "Location_Type"
order By SHORT_NAME

go
SET NO_BROWSETABLE OFF
go
exec usp_LastSurveyEvent_ForLocation_Select 'WA0001570000003G'
go
SELECT L.Location_Key, LN.Item_Name, System_Supplied_Data FROM Location AS L INNER JOIN Location_Name AS LN ON L.Location_Key = LN.Location_Key WHERE L.Parent_Key ='WA0001570000003G' AND   LN.Preferred = 1  ORDER BY LN.Item_Name
go
SELECT F.Location_Feature_Key,                     F.Item_Name,                     FT.Short_Name FROM (Location_Feature AS F LEFT JOIN Location_Feature_Grading AS FG ON        F.Feature_Grading_Key = FG.Feature_Grading_Key) LEFT JOIN Location_Feature_Type AS FT ON        FG.Location_Feature_Type_Key = FT.Location_Feature_Type_Key WHERE F.Location_Key = 'WA0001570000003G'  ORDER BY F.Item_Name, FT.Short_Name
go
exec [NBNData]..sp_procedure_params_rowset N'usp_Location_Select', 1, NULL, NULL
go
exec usp_Location_Select 'WA0001570000003G'
go
exec usp_Location_Select 'WA0001570000003G'
go
SET NO_BROWSETABLE ON
go
SELECT Name_Key, Forename, Initials, Surname,   CASE WHEN Forename IS NULL THEN     CASE WHEN Initials IS NULL THEN       CASE WHEN Title IS NULL THEN Surname       ELSE Title + ' ' + Surname END     ELSE Initials + ' ' + Surname END   ELSE Forename + ' ' + Surname END AS IndividualName FROM Individual WHERE Forename LIKE 'Je%'   OR Initials LIKE 'Je%'   OR Surname LIKE 'Je%'   OR Title LIKE 'Je%' ORDER BY Forename, Initials, Surname

go
SET NO_BROWSETABLE OFF
go
SELECT Organisation FROM Name WHERE Name_Key='WA0001570000004M'
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON select "NAME_KEY" from  "INDIVIDUAL" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "INDIVIDUAL"
WHERE "NAME_KEY"    =   @P1
', N'@P1 varchar(16)', 'WA0001570000004M'
go
SET FMTONLY ON select NAME_KEY from         INDIVIDUAL WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
SET FMTONLY ON select "Survey_Key" from  "Survey" WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT * FROM "Survey"
WHERE "Survey_Key"=' '
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT * FROM "Survey"
WHERE "Survey_Key"=@P1
', N'@P1 varchar(16)', 'WA0001570000000N'
go
SET FMTONLY ON select Survey_Key from  Survey WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
exec usp_Location_Select 'WA0001570000003G'
go
exec usp_Location_Select 'WA0001570000003G'
go
exec usp_Location_Select 'WA0001570000003G'
go
exec usp_Location_Select 'WA0001570000003G'
go
exec usp_Location_Select 'WA0001570000003G'
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON select "Survey_Key" from  "Survey" WHERE 1=2  SET FMTONLY OFF
go
exec sp_executesql N'SELECT * FROM "Survey"
WHERE "Survey_Key"=@P1
', N'@P1 varchar(16)', 'WA0001570000000N'
go
SET FMTONLY ON select Survey_Key from  Survey WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
SET FMTONLY ON select "LOCATION_KEY" from  "GRID_SQUARE" WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT * FROM "GRID_SQUARE"
WHERE "LOCATION_KEY" = ' '
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT * FROM "GRID_SQUARE"
WHERE "LOCATION_KEY" = @P1
', N'@P1 varchar(16)', 'WA0001570000003G'
go
SET FMTONLY ON select LOCATION_KEY from  GRID_SQUARE WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
SET FMTONLY ON select SE.SURVEY_KEY from  SURVEY_EVENT SE WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select SE.SURVEY_KEY from  SURVEY_EVENT SE WHERE 1=2  SET FMTONLY OFF
go
SET FMTONLY ON select "SE"."SURVEY_KEY" from  "SURVEY_EVENT" "SE" WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON SELECT "SE".SURVEY_EVENT_KEY, "SE".VAGUE_DATE_START, "SE".VAGUE_DATE_END, "SE".VAGUE_DATE_TYPE FROM "SURVEY_EVENT" "SE"
WHERE "SE"."SURVEY_KEY" = ' '
AND "SE"."LOCATION_KEY" = 'WA0001570000003G' AND ("SE"."LOCATION_NAME" = '' OR "SE"."LOCATION_NAME" IS NULL)
ORDER BY SE.LOCATION_NAME DESC
WHERE 1=2  SET FMTONLY OFF
go
set fmtonly off
go
exec sp_executesql N'SELECT "SE".SURVEY_EVENT_KEY, "SE".VAGUE_DATE_START, "SE".VAGUE_DATE_END, "SE".VAGUE_DATE_TYPE FROM "SURVEY_EVENT" "SE"
WHERE "SE"."SURVEY_KEY" = @P1
AND "SE"."LOCATION_KEY" = ''WA0001570000003G'' AND ("SE"."LOCATION_NAME" = '''' OR "SE"."LOCATION_NAME" IS NULL)
ORDER BY SE.LOCATION_NAME DESC
', N'@P1 varchar(16)', 'WA0001570000000N'
go
SET FMTONLY ON select SE.SURVEY_KEY from  SURVEY_EVENT SE WHERE 1=2  SET FMTONLY OFF
go
SET NO_BROWSETABLE OFF
go
exec [NBNData]..sp_procedure_params_rowset N'spNextKey', 1, NULL, NULL
go
declare @P1 varchar(16)
set @P1=NULL
exec spNextKey 'SURVEY_EVENT', @P1 output, default
select @P1
go