Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sardinka
Posting Yak Master
142 Posts |
 Posted - 2005-09-15 : 09:43:07
|
| I have 2 tables:Table 1 has:ID,FName,LnameTable2 has:ID,PID,PFName,PLName, FlagPID is a unique number -> (hh:mm:ss)I need to run an update to table2 by setting the Flag to 1 and also creating PID.I could use a join query to do this, but I am concern about PID (hh:mm:ss), because it may take less then 1 second to update and I will have duplicate PID.Any idea what is the best way of doing this? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-15 : 09:59:03
|
well if two updates happen faster than 3.33 miliseconds, you don't have the proper resolution to divide them anyway.you might consider another unique value... like timestamp maybe?Go with the flow & have fun! Else fight the flow  |
 |
|
|
Stalker
Yak Posting Veteran
80 Posts |
Posted - 2005-09-15 : 23:53:58
|
| ... or IDENTITY, or uniqueidetnifier ... |
|
|
|
|
|
|
opinion