Re: Urgent: Strange Exception on SQL7 but not on SQL2000

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 18:45:49 +0200

These types of errors are not user errors. Either data corruptions or bug. I'd start with searching KB as well
as making sure I'm on good service pack level. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lisa Pearlson" <no@spam.plz> wrote in message news:OfwTjeufEHA.3556@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> This error is raised on SQL 7:
>
> ODBC: Msg 0, Level 19, State 1
> SqlDumpExceptionHandler: Process 28 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process
>
> The VIEW on which I execute the query is:
>
> CREATE VIEW vCumulatiefOverzicht
> AS
> SELECT
>  a.boekjr,
>  a.artcode,
>  a.periode,
>  ISNULL(o.omzet, 0) omzet,
>  ISNULL((SELECT SUM(omzet) FROM Sales
>   WHERE boekjr=a.boekjr AND artcode=a.artcode AND periode<=a.periode), 0)
> cumul_artikel,
>  ISNULL((SELECT SUM(omzet) FROM Sales
>   WHERE boekjr=a.boekjr AND periode=a.periode), 0) omzet_periode,
>  ISNULL((SELECT SUM(omzet) FROM Sales
>   WHERE boekjr=a.boekjr AND periode<=a.periode), 0) cumul_periode
> FROM (SELECT
>  j.boekjr,
>  j.artcode,
>  p.periode
>  FROM
>  (SELECT DISTINCT boekjr, artcode FROM OMZART) j,
>  (SELECT 1 AS periode
>  UNION ALL SELECT 2
>  UNION ALL SELECT 3
>  UNION ALL SELECT 4
>  UNION ALL SELECT 5
>  UNION ALL SELECT 6
>  UNION ALL SELECT 7
>  UNION ALL SELECT 8
>  UNION ALL SELECT 9
>  UNION ALL SELECT 10
>  UNION ALL SELECT 11
>  UNION ALL SELECT 12) p) AS a
> LEFT OUTER JOIN Sales o
>  ON o.boekjr = a.boekjr AND o.periode=a.periode AND o.artcode=a.artcode
>
> And I execute the following query on it:
>
> SELECT boekjr, artcode, periode, omzet, cumul_artikel
> FROM vCumulatiefOverzicht
> WHERE boekjr=2000 AND artcode='021-02661'
> ORDER BY boekjr, artcode, periode
>
> Did I do something wrong, or is it a BUG (and perhaps fixable with a service
> pack?).
> I do not have access to the server myself.
>
> Lisa
>
>
>

Relevant Pages

  • Re: Urgent: Strange Exception on SQL7 but not on SQL2000
    ... Is there an alternative way to write a LEFT OUTER JOIN? ... ISNULLFROM SALES ... (SELECT 1 AS periode ... UNION ALL SELECT 2 ...
    (microsoft.public.sqlserver.server)
  • Re: Simplex wants Union workers to install there product
    ... Now al of a suden the rep for Simplex says they only want Union ... doing alarm work in a small shop in a major shopping mall. ... ran the wires and left. ... they organized a large rally of all the sales ...
    (alt.security.alarms)
  • Re: Return Query Result when no data
    ... Union doesn't seem to like it. ... which are not appearing in your current query, ... don't match Debtmain as they don't have a debt for the date. ... Sales table has 3 fields: AccNo, Week and Turnover, Debts table also ...
    (microsoft.public.access.queries)
  • Re: update multiple columns to single column in another table
    ... Please post DDL, so that people do not have to guess what the keys, ... you have mixed sales and orders. ... UNION ALL ... then get a copy of the simplest intro book I know -- ...
    (microsoft.public.sqlserver.programming)
  • Re: Query Show All
    ... You can use two different LEFT JOINS and UNION the subqueries together: ... FROM Budget LEFT JOIN Sales ...
    (microsoft.public.access.queries)