MS SQL (Stored?) Query help

[ksaab2002]

HI, I really do!

I need to link two tables dbo.Survey and dbo.CheckSurveyed on dbo.Survey.Full_Name to dbo.CheckSurveyed.Pass_Name

Then I need to:
update dbo.Survey.SurveyDate to dbo.CheckSurveyed.SurveyDate

Where dbo.CheckSurveyed.SurveyDate is (Greater than 6 Months prior to) dbo.Survey.Load_Date

I am lost when it comes to transact SQL syntax! I am struggling writing the query...

Also, I will need to run this query often as a call from a website? Can it/ should it be done as a stored procedure and if so, how would I embed it in one?

Thanks!!

 

[bborissov]

CREATE Procedure UpdateSurvey
AS
BEGIN
   UPDATE dbo.Survey
          SET SurveyDate to dbo.CheckSurveyed.SurveyDate
   FROM Survey
   INNER JOIN CheckSurveyed ON 
         dbo.Survey.Full_Name = dbo.CheckSurveyed.Pass_Name
   WHERE DateDiff(month,  dbo.CheckSurveyed.SurveyDate,
                          dbo.Survey.Load_Date) > 6

(not tested)



END

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[ksaab2002]

I changed "SET SurveyDate to dbo.CheckSurveyed.SurveyDate" to "SET SurveyDate = dbo.CheckSurveyed.SurveyDate"

After I got an error ....ner "to"

Also, I am getting "Incorrect syntax near '6'"

Any ideas? Many thanks!!

 

[bborissov]

Oops, You correct change TO to equal sigh, also you must put

END at the end

CREATE Procedure UpdateSurvey
AS
BEGIN
   UPDATE dbo.Survey
          SET SurveyDate = dbo.CheckSurveyed.SurveyDate
   FROM Survey
   INNER JOIN CheckSurveyed ON
         dbo.Survey.Full_Name = dbo.CheckSurveyed.Pass_Name
   WHERE DateDiff(month,  dbo.CheckSurveyed.SurveyDate,
                          dbo.Survey.Load_Date) > 6
END

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[ksaab2002]

Got it! Thank you!!