USP_RECURRENCE_RECORDS

      CREATE procedure [dbo].[USP_RECURRENCE_RECORDS] 
                (
                    @IDs nvarchar(4000)
                )
                as 
                begin
          declare @IDsTable table (id uniqueidentifier)

          insert into @IDsTable 
          select g from dbo.fnMakeGuidsTableFromString(@IDs, ',')

          select r.[ID], RECURRENCETYPE, INTERVAL, [DAYOFWEEK], [DAY], [WEEK],[MONTH],STARTDATE,ENDDATE from recurrence r
          inner join @IDsTable t on t.id = r.ID 
        end