Viewing 11 posts - 1 through 11 (of 11 total)
We have also history tables, but closed contracts remain 'alive' and their data are used.
And I cannot split tables.
March 5, 2010 at 1:12 am
Would it be possible to use views that will exclude the rows/columns they're not allowed to change and grant update permission to that view?
Not so simple !
They are allowed to...
March 4, 2010 at 12:59 pm
Having users in the business that have permission to manually update data outside of the confines of the application is a massive problem
I do agree, of course ! But the...
March 4, 2010 at 10:28 am
Works fine, too !
And it provides the number of duplicates for each group of dups and the dup number in each group.
Thanks again.
October 26, 2009 at 10:01 am
Wow !
Works fine, with only one (combined) request !
The power of this langage is always stupendous for me.
Thanks a lot.
Gedeon
October 26, 2009 at 8:18 am
Ok, I tried.
It's a big step forward, but not exactly what I was waiting for.
I get all duplicates records where row_no greater than 1.
But for these records, and only for...
October 26, 2009 at 7:36 am
I'll try this solution this afternoon (I must attend a meeting now).
I couldn't invent such a piece of code.
Thanks for your lightning fast answer !
Gedeon
October 26, 2009 at 2:01 am
Yes ! It is mainly code for checking data.
Thanks for the advice.
August 6, 2009 at 10:18 am
Hello Victor,
As described, replication seems to feet my needs.
But is there also a way to insert a few check/transformation code between the publisher and the subscribers ?
Having begun to read...
August 5, 2009 at 1:13 pm
OK ! Thanks Grasshopper !
I'll look these two technos.
August 5, 2009 at 10:48 am
Oops ! Stupid mistake ! :crazy:
With millions of records in each table, sure it lasts a very long time...
Thanks.
July 8, 2009 at 7:00 am
Viewing 11 posts - 1 through 11 (of 11 total)