JOIN CONTAINSTABLE

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bill Button (bbutton_at_pathtrace.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 17:17:26 -0000

Hi,

i am trying to create a stored procedure on sql 7.0, however the following
fails with the JOIN CONSTAINSTABLE with a syntax error near @myTXT.

SELECT rank,Reply.Topic_ID,Reply.Reply_ID,'R'
 FROM Reply
 JOIN CONTAINSTABLE(Reply, R_Message , @myTXT ) AS Res ON Reply.Reply_ID =
Res.[Key]
 left outer join MembersView on MembersView.Member_ID = Reply.R_Posted_By
 where Reply.R_Posted_By = @userID
 AND Reply.R_Approved = 1
 AND ((Reply.R_Posted >= @tdate OR Reply.R_Posted >= @tdate))

Regards
Bill Button

Relevant Pages

  • Re: Rearrange data in a column, Access 2003
    ... I tried this and am getting a 'syntax error, ... I have learned some about SQL, but not enough to figure out the above error. ... "John W. Vinson" wrote: ... this is high-hazard work: ...
    (microsoft.public.access.queries)
  • Re: Integrity Checks
    ... Well you must be running an older version of SQL Server. ... this integrity check fails consistently. ... in the Sql log that it failed because it must be in "single user mode". ...
    (microsoft.public.sqlserver.setup)
  • Re: return a value using MDX
    ... From [Total Revenue] ... but I am getting a syntax error with the. ... it is looking for @sql as well. ... DECLARE @sql varchar ...
    (microsoft.public.sqlserver.olap)
  • Re: C# / SQL Related - whats wrong with this Insert Into syntax?
    ... Strange little problem here... ... I'm getting a "Syntax error in Insert Into statement" when it ... tries to execute the SQL. ... execute it using the MS Access query engine, ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Server startup issue
    ... After that failure occurs(SSO fails to start due to remote SQL isn't ... it will start the services when SQL becomes online. ... Furthermore I've seen a former case that ENTSSO fails to automatically ... Microsoft Online Community Support ...
    (microsoft.public.biztalk.general)