In order to make sure my structures are valid, I generally apply the rules for the first 4 normal forms (1,2,3, BCNF). If I get to Boyce-Codd Normal...
If you go over to Project Estimating in the navigation bar, and go to frmStructureLookup3. This would be the best one to show the dilemma, where the...
I think you can do this in PowerQuery. I'm pretty sure Chandeep Chhabra covered it in one of his videos on youtube. basically, you have a translation...
other problem you have - in sql, when dates are expressed as a string they need to be in the format of mm/dd/yyyy or the sql standard of yyyy-mm-dd....