Not sure if this is correct forum as it's SQL syntax specific.
Putting in new ERP system which does not hold fical period/year stamps in the transaction records, just the datetime timestamp. There is a GL table which holds the period year and the begin and end dates.
Need to find a code snippet that I could hook into any sql statement so that I could pull the period and year from the GL table.
Not sure how to code in sql if the timestamp of the txn is less than x but greater than y, give me the corresponding gl period and year.
Any pointers/links would be great.
add: this is sql server 2008, if it matters.
View Complete Post