AsherB
4Penny.net
Points: 7383

2/27/2024 8:32:18 AM

Finding a snippet in SQL that you ran 3 days ago

Ever have one of those moments where you 'hear the angels sing'? A 'man, that's so cool' moment? I just had one. 

I'm editing an ACA query just now (has to do with year end reporting). 3 days ago I wrote a formula, ran it a few times, then the client told me it wasn't needed so I removed it. Today, I need it <forehead slap>. And it was a paid to research and code, I needed a person's age on Jan 1 for the report. 

Enter Red Gate SQL Prompt:

4Penny.net
Version: Unknown or N/A
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3