Thanks for the response. Much appreciated.

I was able to modify the script to make it work to give me one row. However, this script works only when the json contents...

Thanks for the reply. Much appreciated. This works, but returns 2 rows. This sample json got only one row.

Thanks for the reply. The JSON file contain over 500 records. So I need to point it to the filename each time.

After doing some research, I modified the code and...

Thanks for the response. Much appreciated. This worked with the testing I did with json (I am new to json files).

Now I received the real file from the 3rd party...

• This reply was modified 4 months ago by  don075. Reason: addition of modified file

Thanks a lot. That works.

Thanks a lot for all the replies. Much appreciated. I am going to remove the sub queries and see how it works. Will also ask the DBA for the execution...

I am trying commands separately to understand. Will update if I have any questions.

Thanks a lot. Much appreciated.

So far this solution gives me the result I am looking for. Much appreciated. Will be testing this with live data. Again apologies as the requirement was changed in the...

Thanks for the response. Much appreciated. It worked for that sample data because the dates were the same.

When I have different dates, it resets the counter.

My apologies, if I am...

Is it possible to make the count start only for non XXX. With the following sample data, column gives me 3 and 4. But I want it to give 1...

Thanks a lot for the response. Works great.

Unfortunately, there is no sort order. This is a 3rd party database. I don't have control of how they save data. Script should go through the data and take the...

Agree 100%. Will do the needful next time. Already got another one about a script that I did. Just putting everything thing (with the code that I already wrote). Appreciate...

• This reply was modified 1 year, 11 months ago by  don075.

Thanks for the response. I am a bit newbee when it comes to sql. Still learning.