[dba-SQLServer] SQL in SP failing

Robert,

I think that did it...thank you very much...I'm still not sure why it would 
fail...but after modifying and changing back it would run succesfully with 
the same syntax that originally failed.

Thanks Again,

Mark A. Matte


>From: "Robert L. Stewart" <rl_stewart at highstream.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 14:20:41 -0600
>
>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
> > >
> > >
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Get free, personalized commercial-free online radio with MSN Radio powered 
by Pandora http://radio.msn.com/?icid=T002MSN03A07001