I'm sure i've done this before but I can't seem to find the answer;
How do I truncate a temporary table?
I've declared it, but I need to populate it and loop through it multiple times, each with the ID column starting at 0 so Delete from doesnt work. Therefore I either need to truncate it or kill the variable and re-create it.
Any help would be much appreciated.