# Temp Table

**URL:** <https://www.dynamicsuser.net/t/temp-table/62810>\
**Category:** Developer Forum\
**Created:** [February 24, 2017, 10:41am UTC](https://www.dynamicsuser.net/t/temp-table/62810 "2017-02-24T10:41:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![axgamer](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@axgamer](https://www.dynamicsuser.net/u/axgamer)\
**Post date:** [February 24, 2017, 10:41am UTC](https://www.dynamicsuser.net/t/temp-table/62810/1 "2017-02-24T10:41:46Z")

</div>

Im using temp table in Job to delete the temptable data using tempTable variable,.

if two different users access the same job instantly is there any data lose between two user ?

---

<div class="post-metadata">

**Author:** ![kunal\_patel](https://avatars.discourse-cdn.com/v4/letter/k/d2c977/32.png) [@kunal\_patel](https://www.dynamicsuser.net/u/kunal_patel)\
**Post date:** [February 24, 2017, 10:49am UTC](https://www.dynamicsuser.net/t/temp-table/62810/2 "2017-02-24T10:49:01Z")

</div>

Hello,

it is depending on how you are using your code, please check locking concurrency in AX

[msdn.microsoft.com/…/bb190073.aspx](https://msdn.microsoft.com/en-us/library/bb190073.aspx)  
[stoneridgesoftware.com/…/](https://stoneridgesoftware.com/ax-2012-locking-concurrency-sample-code/)

---

<div class="post-metadata">

**Author:** ![MartinDrab](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@MartinDrab](https://www.dynamicsuser.net/u/MartinDrab)\
**Post date:** [February 24, 2017, 10:54am UTC](https://www.dynamicsuser.net/t/temp-table/62810/3 "2017-02-24T10:54:22Z")

</div>

Data in temporary tables are temporary and they’re delete when you stop using the table buffer, so deleting them in a job makes no sense. Your would have to first create some data to delete.  
If you can select data in your job without first creating them, your table clearly isn’t temporary.

---

<div class="post-metadata">

**Author:** ![axgamer](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@axgamer](https://www.dynamicsuser.net/u/axgamer)\
**Post date:** [February 24, 2017, 11:14am UTC](https://www.dynamicsuser.net/t/temp-table/62810/4 "2017-02-24T11:14:57Z")

</div>

Assume if 1st process takes 30 mins to complete at at the end of the process i used to delete the temp table. during the middle of the process 2nd user process the same but it will complete in 2 mins. In that case, is there any data lose in 1st process ?

---

<div class="post-metadata">

**Author:** ![MartinDrab](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@MartinDrab](https://www.dynamicsuser.net/u/MartinDrab)\
**Post date:** [February 24, 2017, 11:22am UTC](https://www.dynamicsuser.net/t/temp-table/62810/5 "2017-02-24T11:22:03Z")

</div>

If it’s a temporary table, each process has its own data and no access to the temporary table instance of the other process.