Can it be space or hidden character issue? I dont see anything when I paste this in notepad.

This is what I am trying to do

Step 1  - Convert function to SP

Step 2 - Change table variable to Temp Tbl

and then I would test it out. This is...

Great, I am almost there, quick question,

The only other thing is don't INSERT the data into a table variable, and instead just SELECT the dataset. - SHould I just comment...

• This reply was modified 3 years, 6 months ago by  sizal0234.
• This reply was modified 3 years, 6 months ago by  sizal0234.

The execution plan of the above select is giving a table scan and also missing idx hints, is it due to the fact that the function is not using an...

This is resolved, I added the IDX Inside the SP and it works fine. Please ignore.

Not sure how to delete this post hence posting the below reply to save your...

I am happy and always appreciate the help people here provide. However, I think user's should be allowed to attach plans directly as well. Just a feedback to further improve...

Looks like I posted this in 2017 sql group. The plan is from sql 2016. So, I will post if there as well.

The plans were saved using SQL sentry...however they should still open. It any issue, then save them as .sqlplan and it should open as GUI instead of XML.( just in...

The Tlogbackups were working again and all came in SYNC again.

I was able to spin  up a windows server on aws cloud let me proceed with that option for now. It will be an amazing learning experience if I am...

Thank you Jeff for showing the right direction. I always had this issue of generating test data and now I have a plan and your teaching is very helpful. I...

maybe something like this. Dump the file/ records  into a temp table and have the row ID of the file appended to the record, then cycle throught the records sequentially...

Can you elaborate a little on how can I implement sequential processing.  please share any example which help me understand.

is row level lock an option.?

Thanks!!

Jeff - I was reading your article(https://www.red-gate.com/simple-talk/opinion/opinion-pieces/jeff-moden-dba-of-the-day/) and wanted to ask, what are some of the books or resources you felt like are great resouces to master Tsql....

I did not understand the below in your reply...could you please elaborate. Was something wrong with the function I shared? I did not write it but please let me know.

Then,...