Groups > comp.databases.ms-sqlserver > #1389

Re: Purge Utility

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Purge Utility
Date	2013-02-14 21:00 +0100
Organization	Erland Sommarskog
Message-ID	<XnsA167D5B8CB6FYazorman@127.0.0.1> (permalink)
References	<695679d9-3eb9-44c8-a7fb-2e60ef2b8373@googlegroups.com> <41b71981-071e-4070-8dd2-700ec898f02d@googlegroups.com>

Show all headers | View raw

JAW (jwilliam@aglresources.com) writes:
>==================================================== 
> INSERT INTO REP_BUS_DIR_NO_INSTMT_JAW WITH (TABLOCK) SELECT * FROM
> TEMP_BUS_DIR_NO_INSTMT_JAW WHERE KY_BA IN (SELECT KY_BA  FROM 
> [CISStagingDB].[dbo].[REP_BILL_ACCT] (nolock) WHERE  CD_OFFICE > '079' 
>====================================================
> Msg 50000, Level 16, State 1, Procedure usp_Purge, Line 144
> Incorrect syntax near '079'

When there is a token missing at the end, SQL Server flags the token as
the culprit, rather than say EOF or similar as some compilers do. There
should be closing parenthesis at the end.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Purge Utility JAW <jwilliam@aglresources.com> - 2013-02-13 12:44 -0800
  Re: Purge Utility Erland Sommarskog <esquel@sommarskog.se> - 2013-02-13 22:25 +0100
  Re: Purge Utility JAW <jwilliam@aglresources.com> - 2013-02-14 08:10 -0800
    Re: Purge Utility Erland Sommarskog <esquel@sommarskog.se> - 2013-02-14 21:00 +0100
  Re: Purge Utility JAW <jwilliam@aglresources.com> - 2013-02-14 08:22 -0800
  Re: Purge Utility JAW <willjamu@gmail.com> - 2013-02-21 17:38 -0800
    Re: Purge Utility rja.carnegie@gmail.com - 2013-02-21 18:04 -0800

csiph-web