posted twice

• This reply was modified 10 months, 3 weeks ago by  Mike01.

looks like 2 different folders??  Should the first one be \\myServer\Users\SQLAdmin\Documents\BulkInsert\??

exec master.sys.xp_dirtree '\\myServer\Users\Documents\BulkInsert\', 1, 1;

exec master.sys.xp_dirtree 'c:\Users\SQLAdmin\Documents\\BulkInsert\', 1, 1;

can you provide a link to the ddl and data?

How about a cte?

drop table if exists #some_table;
go
create table #some_table (
input_string varchar(200) not null);

insert #some_table(input_string) values
('5,1,6,1,69,1'),
('5,1,6,1,3,2,5,3,69,1'),
('5 ,2,36,1,69,1')
;


;with cte as (select input_string, case when RowNum %2 = 0...

Is year and Month always the same for all 3 parameters?  Are you always looking for StartOfMonth, EndOfMonth and MiddleOfMonth?  If so, you can do something like this:

            
September 8, 2022 at 3:46 pm
            
#4085479

            
            
                                                
        

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 2 years, 4 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 2 years, 11 months ago by  Mike01.

I tried to just add a column to the table with a default value of the current day but it errors out with because there is no date (Column 14)...