[dba-SQLServer] SQL in SP failing

Take the AS Criteria out.
SQL does not care about it and it is probably confusing it.

At 02:07 PM 11/30/2006, you wrote:
>Date: Thu, 30 Nov 2006 20:07:42 +0000
>From: "Mark A Matte" <markamatte at hotmail.com>
>Subject: Re: [dba-SQLServer] SQL in SP failing
>To: dba-sqlserver at databaseadvisors.com
>Message-ID: <BAY127-F15C7879CCFD59737DEE59ED2DB0 at phx.gbl>
>Content-Type: text/plain; format=flowed
>
>Wouldn't that make it think TEST was a column name...when I want it to be
>the value in each row?
>
>Thanks,
>
>Mark A. Matte
>
>
> >From: "Eric Barro" <ebarro at verizon.net>
> >Reply-To: dba-sqlserver at databaseadvisors.com
> >To: <dba-sqlserver at databaseadvisors.com>
> >Subject: Re: [dba-SQLServer] SQL in SP failing
> >Date: Thu, 30 Nov 2006 11:40:25 -0800
> >
> >Enclose test in brackets like this
> >
> >[test]
> >
> >-----Original Message-----
> >From: dba-sqlserver-bounces at databaseadvisors.com
> >[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark A
> >Matte
> >Sent: Thursday, November 30, 2006 11:26 AM
> >To: dba-sqlserver at databaseadvisors.com
> >Subject: Re: [dba-SQLServer] SQL in SP failing
> >
> >If I use single quotes...SQL says it is a syntax error before I even run
> >it...won't even let me save it that way.
> >
> >Thanks,
> >
> >Mark A. Matte
> >
> >