Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE [dbo].[dvtable_{58299e31-e1ec-4756-bc89-eda47cbc6aa0}_userdependent]
- SET [UserSettings] = (
- SELECT DISTINCT TOP 1
- [UserSettings]
- FROM [dbo].[dvtable_{58299e31-e1ec-4756-bc89-eda47cbc6aa0}_userdependent] as uSettings
- INNER JOIN [dbo].[dvsys_users] as users ON users.UserID=uSettings.UserID
- WHERE users.AccountName='DOMAINNAME\AccountName'
- )
- WHERE UserID<>(SELECT TOP 1 [UserID]
- FROM [dbo].[dvsys_users] as u
- WHERE u.ACcoountName='DOMAINNAME\AccountName')
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement