Advertisement
vilgelmbb

DV Update all UserSettings

May 20th, 2015
239
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.49 KB | None | 0 0
  1. UPDATE [dbo].[dvtable_{58299e31-e1ec-4756-bc89-eda47cbc6aa0}_userdependent]
  2.     SET [UserSettings] = (
  3.                 SELECT DISTINCT TOP 1
  4.                 [UserSettings]
  5.                 FROM [dbo].[dvtable_{58299e31-e1ec-4756-bc89-eda47cbc6aa0}_userdependent] as uSettings
  6.                     INNER JOIN [dbo].[dvsys_users] as users ON users.UserID=uSettings.UserID
  7.                 WHERE users.AccountName='DOMAINNAME\AccountName'   
  8.                 )
  9. WHERE UserID<>(SELECT TOP 1 [UserID]
  10.         FROM [dbo].[dvsys_users] as u
  11.         WHERE u.ACcoountName='DOMAINNAME\AccountName')
  12. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement