Without sample data and DDL, it's hard to help, but I would look here.  It is only bringing back where the dtDate = enddate

INNER JOIN tblDate WITH (NOLOCK) ON tblDate.dtDate...

In the first link, if you go to step 16, you'll see where they are calling the procedure you have been referencing to update the watermark table.  Essentially, they are...

DDL, Sample Data and expected results will help us help you

I created your table [watermarktable] and then created your stored procedure dbo.usp_write_watermark and then executed your stored proc with the script that I provided.  I don't know what you did...

• This reply was modified 3 years, 9 months ago by Mike01.

I ran your code and it works as expected.  What happens if you run this:

Select * from watermarktable where table_name = '[dbo].[products]'

exec dbo.usp_write_watermark @LastModifiedtime = '8/17/2022', @TableName = '[dbo].[products]'

Select *...

Instead of shoving it into an xml field, can you parse it into real table or 3?

The DateAdd function is failing.  The increment parameter is an int and you are passing in a bigint

without any sample data, we can only tell you what we see.  App Category is coming from the label field in app_menu_filters and Menu is coming from the label field...

Depends on how big the data set is, but you could use string_split

;with cte as (
Select c.ID, c.name, ltrim(rtrim(s.value)) as word, c.KeyWords
from #Companies c
Cross apply 
string_split(KeyWords, ',')...

• This reply was modified 4 years, 4 months ago by Mike01.