Post reply

Comparing data to extended property

  • August 23, 2007 at 9:37 am

    #176133

    I am trying to compare a date from a table to a value in an extended property using the following condition but I am getting the incorrect syntax error. Could someone please tell me what am I doing wrong?

    TIA

    Dean

    IF

    SELECT MAX(Job_Booked_Date) AS MaxBookedDate FROM parfls.dbo.JobMaster >

    SELECT value FROM ::fn_listextendedproperty ('DataUpdated', 'schema', 'dbo', 'table', 'GPSReport', null, default)

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near '>'.

  • August 23, 2007 at 10:51 am

    #729038

    I would think that you should have () around each complete select statement. 

  • August 23, 2007 at 10:59 am

    #729042

    THANKS

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply