Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT top 1000 [Timestmp]
- ,[Audience]
- ,[Severity]
- ,[Verbosity]
- ,[UserFullName]
- FROM [PD_SQL_DB].[dbo].[Client1_DiagList]
- wHERE [aUDIENCE]='8' AND [SEVERITY] = '4'AND [VERBOSITY] = '0'
- Union
- SELECT top 1000 [TimeStmp]
- ,[MessageText]
- ,[Audience]
- ,[Severity]
- ,[Verbosity]
- ,[UserFullName]
- FROM [PD_S`enter code here`QL_DB].[dbo].[Client2_DiagList]
- WHERE [AUDIENCE]='8' AND [SEVERITY] = '4'AND [VERBOSITY] = '0'
- Order by [TimeStmp] desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement