Hi guys I've done truckloads of Admin, but I'm pretty light on procedures/scripts, I've only ever had to look at a few scripts since 99. I picked up a book on T-SQL and got through the first couple of chapters. Now, I can't quite fathom what Local variables are, how/why they're used, benefits etc. Can anyone give me an explanation and ideally some examples too? Thanks, JB. France. The finest wines. The tastiest cuisine. The most delicious women.