--- return list of tables that needed to update
--- list is one string separated by '&' delimeter
--- @listOfUpdateTime: [TableName=UpdateTime]&[...]  eg) tblDeptList=12/25/2004&tblHoliday=12/24/2004&...
CREATE procedure spGetListOfTableToDownLoad
	@listOfUpdateTime varchar(500)
as
	SET NOCOUNT ON
	Declare @listOfTable varchar(300), @item varchar(300)
	Declare @tbl varchar(50), @uptime datetime
	Declare @list varchar(500)
	Declare @sep varchar(1)
	SET @list = ''
	SET @sep = '&'
	DECLARE cur CURSOR FAST_FORWARD FOR 
	SELECT * FROM fnSplit(@listOfUpdateTime, @sep)
	
	OPEN cur
	
	FETCH   NEXT
    FROM    cur
    INTO    @item
	
	Declare @re bit, @tp varchar(50)
	WHILE @@FETCH_STATUS  = 0
		BEGIN
			
			-- get tablename, update time
			Declare cur2 CURSOR FAST_FORWARD FOR 
			SELECT * FROM fnSplit(@item, '=')
			OPEN cur2
			FETCH NEXT FROM cur2 INTO @tbl
			Print @tbl
			FETCH NEXT FROM cur2 INTO @tp
			print 'tp:' + @tp
			SET @uptime = CAST(@tp as datetime)
			print @uptime
			-- @re =1: true, 0: false
			EXEC spIsUpdate @tbl, @uptime, @re output
			IF @re = 1 
				SET @list = @list + @tbl + @sep
			CLOSE cur2
			DEALLOCATE cur2

			FETCH   NEXT
		    FROM    cur
		    INTO    @item
		END
		if LEN(@list) > 0 
			SET @list = LEFT(@list, Len(@list)-Len(@sep))
	CLOSE cur
	DEALLOCATE cur

	SELECT @list as Result

	SET NOCOUNT OFF


GO