thread in sql1 = thread in sql2
just wondering if theres a way to check thread name vs thread name in a different sql...
And if they are different update it to the other unless yours thread date is newer than the other...
well i kinda figure it is possible using something like
if (sql1 thread.threaname WHERE thread.threadid = '197') != (sql2 thread.threadname WHERE thread.threadid = '298')
if sql1 thread.threaddate > sql2 thread.threaddate
//do nothing
else
set sql1 thread.threadname = sql2 thread.threadname
else
// do nothing
well thats the "outline" and i belive i've given away that i have no clue whatsover when it comes to coding/programming...
And ofcourse i have full access to both SQL's they are on same server..
|