From: "Rich" 

This is a multi-part message in MIME format.

------=_NextPart_000_0070_01C334D3.428DF810
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

   Does table SubAccountDataTypes have a column named SortOrder?

Rich

  "Geo."  wrote in message =
news:3eef654b$1{at}w3.nls.net...
  Ellen (or anyone who knows sql),

  Got any ideas on the cause of this error? I'm not even sure what table =
to
  look at from this query...

  [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
  'SortOrder'.

  =
-------------------------------------------------------------------------=
-+-
  ----
  Select dt.*, at1.AccountType, CASE (Select Count(*) From =
SubAccountData sa
  Where sa.DataTypeID =3D dt.DataTypeID) WHEN 0 THEN 'Delete' ELSE '' =
END as
  DelLink --, ISNULL(ObjectGroup, '') as ObjectGroup From =
SubAccountDataTypes
  dt, AccountTypes at1 --, ObjectGroups og Where dt.AccountTypeID *=3D
  at1.AccountTypeID AND dt.ExternalSystemType IS NULL -- and =
dt.ObjectGroupID
  *=3D og.ObjectGroupID Order By dt.SortOrder

  =
-------------------------------------------------------------------------=
-+-
  ----
  S0022


  Geo.


------=_NextPart_000_0070_01C334D3.428DF810
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








   Does
table SubAccountDataTypes have a
column = named=20
SortOrder?
 
Rich
 

  "Geo." <georger{at}nls.net>">mailto:georger{at}nls.net">georger{at}nls.net>
wrote=20
  in message news:3eef654b$1{at}w3.nls.net...Ellen=20
  (or anyone who knows sql),Got any ideas on the cause of this =
error?=20
  I'm not even sure what table tolook at from this=20
  query...[Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid =
column=20
  =
name'SortOrder'.---------------------------------------------=
-----------------------------------Select=20
  dt.*, at1.AccountType, CASE (Select Count(*) From SubAccountData =
saWhere=20
  sa.DataTypeID =3D dt.DataTypeID) WHEN 0 THEN 'Delete' ELSE '' END =
asDelLink=20
  --, ISNULL(ObjectGroup, '') as ObjectGroup From =
SubAccountDataTypesdt,=20
  AccountTypes at1 --, ObjectGroups og Where dt.AccountTypeID=20
  *=3Dat1.AccountTypeID AND dt.ExternalSystemType IS NULL -- and=20
  dt.ObjectGroupID*=3D og.ObjectGroupID Order By=20
  =
dt.SortOrder-----------------------------------------------------=
---------------------------S0022Geo.

------=_NextPart_000_0070_01C334D3.428DF810--

--- BBBS/NT v4.01 Flag-4