Viewing 3 posts - 1 through 3 (of 3 total)
For one-off issues, there are several free CSV to SQL tools on the net which build the insert/update/delete/merge/select script from the CSV data (i.e. bfotool.com/csv-to-sql). That generated script can then...
July 14, 2021 at 2:41 pm
It looks like you are not taking the LOTOSMIS_RET_DAILY.gm_var=1 condition into account.
You would need to code it something like this:
Sum(T.SING_IND * P.GRS_AMN *
CASE
WHEN P.gm_cd in (1105, 2123, 2124, 2150, 2152,...
August 26, 2020 at 1:36 pm
I too liked seeing the prior day's question's answer in the newsletter. I don't always have access to the web to look it up and often do not have...
July 31, 2013 at 8:34 am
Viewing 3 posts - 1 through 3 (of 3 total)