none
Syncing on a veiw? RRS feed

  • Question

  • Is it possible to set your select commands when syncing to be performed against a view.  I have some custom filtering based on joins that im not sure i can replicate with command parameters  that restrict data based on a users Active Directory Group.  If this is not possible what would be my solution.

    Here is an example of a view.

    SELECT     sfd.shock_file_id, sfd.field, sfd.value, sfd.shock_file_data_id, sfd.[order]
    FROM         dbo.SHOCK_FILE_DATA AS sfd LEFT OUTER JOIN
                          dbo.SHOCK_FILE AS sf ON sf.shock_file_id = sfd.shock_file_id LEFT OUTER JOIN
                          dbo.SHOCK AS ss ON sf.shock_id = ss.shock_id LEFT OUTER JOIN
                          dbo.TEAM AS t ON ss.team_id = t.team_id LEFT OUTER JOIN
                          dbo.SERIES AS s ON t.series_id = s.series_id
    WHERE     (IS_MEMBER('DOMAIN\SERIES_' + s.name) = 1)

    Friday, July 30, 2010 2:55 PM

All replies