I only can filter according to Year and Month. The data consist of Year, Month, rest of the columns.

Year  | Month | 20s+ columns
2018 | Jan |...

The column that I filter is just the year.

Year: 2018

Any sample that I can refer to index those column?

Is working for both way. Understand method of joining now. Thanks.

i would like to clean it on certain condition.
if user input name which contains Mary or John or Calley and few more conditions, i would like to delete it.

girl_bj (4/1/2016)

I manage to run in every 7 days continuously. Added in ROW_NUMBER() OVER (ORDER BY startdate) AS Row too.

How can I push this record as an output. I tried...

I manage to run in every 7 days continuously. Added in ROW_NUMBER() OVER (ORDER BY startdate) AS Row too.

How can I push this record as an output. I tried SSIS...

How can I replace the LEAD function?

I'm using 2008.

I still need to do it manually?

getdate till 7 days will be 7 april

Then 8 april till 7 days and so on.

I would like to breakdown 7 days each for 100 days.

fileA: getdate() - 6 april

fileB: 7 april - 14 april

fileC: 15 april - 22 april

and so on.

Currenctly im doing it...

It will be continuous. I am just testing for 1 month on how it works. The weekly data will be send as an output file.

Is there any way that I...