PHWinfo - Afficher un message - Trying to perform a query using XP Sendmail

13/12/2007, 23h23

(FSA_Weekly_Flash.dbo.GL_Account.GL_Account) = ''500-001''

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

"Mike K" <vwttracer@hotmail.com> wrote in message
news:2ee535d8-660f-47d9-ba37-cae5734ad537@d4g2000prg.googlegroups.com...
> On Dec 13, 1:50 pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
>> You declared @strBody as varchar(1000) and in fact your SQL statement is
>> around 2339 characters (according to a quick copy/paste to a text
>> editor).
>> Try declaring as varchar(3000).
>>
>> HTH,
>>
>> Plamen Ratchevhttp://www.SQLStudio.com
>
> Thanks that really ed. I glanced over it and yet totally missed
> it. My other question is how do I specify the having clause if I put
> the single quotes like this: HAVING
> (FSA_Weekly_Flash.dbo.GL_Account.GL_Account) = '500-001' I get an
> error. I can again make it work fine in query analyzer but I cant seem
> to figure out how to make it work in this stored procedure. Thanks for
> all your !!

13/12/2007, 23h23	#6
Greg D. Moore \(Strider\) Messages: n/a Hébergeur:	Re: Trying to perform a query using XP Sendmail (FSA_Weekly_Flash.dbo.GL_Account.GL_Account) = ''500-001'' -- Greg Moore SQL Server DBA Consulting Remote and Onsite available! Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html "Mike K" <vwttracer@hotmail.com> wrote in message news:2ee535d8-660f-47d9-ba37-cae5734ad537@d4g2000prg.googlegroups.com... > On Dec 13, 1:50 pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote: >> You declared @strBody as varchar(1000) and in fact your SQL statement is >> around 2339 characters (according to a quick copy/paste to a text >> editor). >> Try declaring as varchar(3000). >> >> HTH, >> >> Plamen Ratchevhttp://www.SQLStudio.com > > Thanks that really ed. I glanced over it and yet totally missed > it. My other question is how do I specify the having clause if I put > the single quotes like this: HAVING > (FSA_Weekly_Flash.dbo.GL_Account.GL_Account) = '500-001' I get an > error. I can again make it work fine in query analyzer but I cant seem > to figure out how to make it work in this stored procedure. Thanks for > all your !!