Viewing 10 posts - 1 through 10 (of 10 total)
Only the temporal tables. So one would be customer and another would be customer address. The report would show the transactions against each chronologically for example
Username, EventDate, Table, NewValue, OldValue
June 22, 2020 at 5:34 pm
Thanks for the response,
The tables that system versioning is enabled do not get transacted against often as far as I can tell.
June 22, 2020 at 1:47 am
Sorry, the purpose is to export to a 3rd party which only accepts csv or tab delimited data (not particularly cool) so the external system is expecting each record...
June 29, 2016 at 6:09 am
Thanks so much for that. If this were extended for future development to include say Kelvin would I have to rank the conversions somehow rather than select the min.
July 14, 2014 at 10:43 am
January 25, 2007 at 6:19 pm
when you move them to outer joins is that just a matter of moving the subqueries to the From clause and then using the correct ansi joins from there
January 25, 2007 at 8:54 am
Cheers Ninja's RGR'us did that after I posted this
January 14, 2007 at 7:32 pm
Sorry forgot to mentio the desired output would be as such
Sorry Forgot to Mention the output should look as such
January 10, 2007 at 10:16 pm
Thanks Guys muchly apreciated
The Tables that I have are as such
Shift Roster Table
Day Shift Day Shift Night Shift Night Shift
Date Team Man...
January 10, 2007 at 9:53 pm
Thanks for the reply,
The database actually works it is one of the frontends that works with this database that is causing the issue. Basically there is a ASP page...
June 30, 2004 at 4:46 pm