<![CDATA[Forum — JNCCDET5]]> https://forums.nbn.org.uk/viewtopic.php?id=922 Sat, 14 Feb 2009 08:15:35 +0000 PunBB 1.4.6 <![CDATA[Re: JNCCDET5]]> https://forums.nbn.org.uk/viewtopic.php?pid=4054#p4054 </Condition>
Janet

Looks like there is an error in it in both the default and quick report.  Alias is not given for Survey table . Needs a minor change in two places.


Insert Into #JNCC_NEWDATA (Original_Key,Indicator)
SELECT DISTINCT

TDET.Taxon_Determination_Key, 1
FROM
Survey SV                      ***********************  SV added as an alias in both quick and default sections


Mike

]]> Sat, 14 Feb 2009 08:15:35 +0000 https://forums.nbn.org.uk/viewtopic.php?pid=4054#p4054 <![CDATA[Re: JNCCDET5]]> https://forums.nbn.org.uk/viewtopic.php?pid=4052#p4052 I have tried to run a batch update to change validation level on new data imported. I get the error 'S.V. Survey key could not be bound'!!  As anyone any idea what that means?

Thanks

Janet

]]> Fri, 13 Feb 2009 14:03:11 +0000 https://forums.nbn.org.uk/viewtopic.php?pid=4052#p4052