Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,716 questions
4 answers
One of the answers was accepted by the question author.
Stored Procedure to Compare 2 table and create new records if new
Hi team, I am new to SQL, I have the concept below I want this to implement in my project, Please assist me how can I achieve this, I have Primary Table A and secondary table B Need to Check below, select each ID from table A begin with…
Developer technologies | Transact-SQL
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,742 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 27%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
4 answers
One of the answers was accepted by the question author.
Multiple Merge function in single SP
Hi Team, I wanted to compare 2 tables and update the second table with 3 constant values say A, B,C. I can hardcode the 3 values in my Insert/Update query. Merge function is Apt for my solution and working fine but I want to use the merge…
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,716 questions
3 answers
One of the answers was accepted by the question author.
Archive MS Teams Groups - Automation
Hello Teams Master, Iam looking for the script / Graph API to archive the MS teams groups who left the organization. i believe the below process have to follow to achieve this. i need to find the list of MS Teams groups owned by specific user. …
Microsoft Teams | Microsoft Teams for business | Other
Microsoft Teams | Microsoft Teams for business | Other
Additional features, settings, or issues not covered by specific Microsoft Teams categories
21,028 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 1%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
MS Teams on iPhone does not hide participant boxes when a screen is shared
Good afternoon, We are facing a case where on iPhone while someone is sharing their screen the participant boxes don't minimize. On Android, it works fine, you click the screen and it is minimized, but on iPhone it stays on display and does…
Microsoft Teams | Microsoft Teams for business | Other
Microsoft Teams | Microsoft Teams for business | Other
Additional features, settings, or issues not covered by specific Microsoft Teams categories
21,028 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 24%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIL%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Remote Desktop Services problem without Active Directory
Hi i dont need AD. i installed Remote Desktop Services in Server 2016 with Workgroup.and i added Remote Desktop User-Per User Cal. But The enviroment tab I added to users is not working Can you help me
Windows for business | Windows Client for IT Pros | User experience | Remote desktop services and terminal services
asked 2020-11-10T04:58:08.693+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 92%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Seçkin Önder
21
Reputation points
answered 2020-11-10T11:14:40.58+00:00
Seçkin Önder
21
Reputation points
1 answer
my hotmail outlook account now suddenly showing over 22,000 unread messages
i use my outlook hotmail account for business , and keep upto date reading and deleting messages, over the weekend 7 NOv 2020 , my inbox suddenly showed over 2,000 unread messages , i tried logout and in again , now shows over 22,500 unread messages…
Community Center | Not monitored
Community Center | Not monitored
Tag not monitored by Microsoft.
54,134 questions
asked 2020-11-10T11:08:10.83+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 0%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
leo abraham
1
Reputation point
answered 2020-11-10T11:11:51.157+00:00
Leon Laude
86,116
Reputation points
1 answer
System check showing Error for certification.
Hi Team, I have problem in completing my system check. During the launch simulation, It is showing something like - "tvnserver.exe is not allowed to run ......". Please help me out. I have already booked my test slot which is on 15/10/2020…
Community Center | Not monitored
Community Center | Not monitored
Tag not monitored by Microsoft.
54,134 questions
asked 2020-11-10T10:51:36.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 60%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Pavan Kumar S
1
Reputation point
answered 2020-11-10T11:07:51.28+00:00
Vaibhav Chaudhari
39,006
Reputation points
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
Is there any version in SharePoint Online like in SP On Premise.
Hi, Do we have a SharePoint version in case of online as well? If yes, how should I identify which version, I am using?
Microsoft 365 and Office | SharePoint | For business | Windows
Microsoft 365 and Office | SharePoint | For business | Windows
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
29,916 questions
asked 2020-11-09T11:09:00.48+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 48%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Amit Singh Rawat
731
Reputation points
accepted 2020-11-10T11:06:58.82+00:00
Amit Singh Rawat
731
Reputation points
1 answer
Refresh Combobox Items list and seleceted item with unchanged bounded source/property
Hello, i have a project where i want to switch the language at runtime (german, english). I decided to use System.Globalization and ConverterCulture={x:Static sysglb:CultureInfo.CurrentUICulture}. In the following code snippets i extracted and abstracted…
Developer technologies | Windows Presentation Foundation
Developer technologies | Windows Presentation Foundation
A part of the .NET Framework that provides a unified programming model for building line-of-business desktop applications on Windows.
2,890 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 28.999999999999996%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
1 answer
Power BI Connection encryption parameter for this data source
Hello guys, I have had a problem with Power BI. I got error "A connection was successfully established with the server, but then an error ... (provider: SSL Provider, error: 0 - The received certificate has expired.)", after it I turned off…
Community Center | Not monitored
Community Center | Not monitored
Tag not monitored by Microsoft.
54,134 questions
asked 2020-11-10T10:22:39.72+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 34%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nerobov Andrey
96
Reputation points
answered 2020-11-10T10:31:34.943+00:00
Leon Laude
86,116
Reputation points
1 answer
SCOM - Non Windows Logs
Hi All, I am using SCOM 2016 which is configured to monitor non-windows machines. The number of SCOM logs stored under opt/microsoft/scx/ is increasing a lot So i reduced it to intermittent using the below command cd /opt/microsoft/scx/bin/tools/ …
System Center Operations Manager
System Center Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,637 questions
asked 2020-11-10T05:39:49.763+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 15%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
karthik palani
661
Reputation points
answered 2020-11-10T10:29:59.483+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 31%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CyrAz
5,181
Reputation points
2 answers
Passing output of activity as input to next activity - data factory
I have a pipeline which writes data to three targets tables and one file. The summary of load metrics with data information has to be posted to a URL usong Post method in Web. How do I pass output of first activity as input of next activity. Also, the…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,158 questions
asked 2020-11-10T04:07:02.04+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 7.000000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Accelerator
1
Reputation point
answered 2020-11-10T10:15:34.95+00:00
Accelerator
1
Reputation point
2 answers
One of the answers was accepted by the question author.
From SharePoint workflow no email going to one user
Mailbox unavailable. The server response was: 5.1.1 <*****@XX.com>... User unknown* Above is the user and above is the message from ULS logs. It was confirmed from exchange and AD team that mail id is active. not sure what could be the problem. …
Microsoft 365 and Office | SharePoint Server | For business
Microsoft 365 and Office | SharePoint Server | For business
A family of Microsoft on-premises document management and storage systems.
4,685 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 77%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
2 answers
Microsoft Visual ++ 2015 Redistributable (x64) Error:0x81f4001
Good day, I have problem with installing Microsoft Visual C++ 2015 Redistributable (x64). I have version (x86) and I need install (x64) to solve problems in one program. I have windows 10 Pro 10.0.19041 Build 19041. Error is:…
Windows development | Windows API - Win32
2,962 questions
asked 2020-11-05T09:59:17.353+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 1%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Michalos Michael
1
Reputation point
answered 2020-11-10T10:01:13.387+00:00
Drake Wu - MSFT
996
Reputation points
2 answers
One of the answers was accepted by the question author.
How to build a generic Aggregation data flow in ADF?
Hi I wanted to try to create a generic aggregation pipeline which can be used for multiple scenarios. Always more than 1 column to aggregate on, always 1 or more measures to be aggregated. See attachment Is there a way to get this…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,158 questions
asked 2020-11-04T14:36:59.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 92%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Poel van der, RE (Ron)
451
Reputation points
accepted 2020-11-10T10:00:58.647+00:00
Poel van der, RE (Ron)
451
Reputation points
1 answer
Logic app to call WebService secured with certificate
Hi from logic app I need to call a Web service secured with the Certificate. I see in the Http action we have option to enable the Authentication with Authentication as 'Client certificate' but i can select only the .Pfx file not the .Cer file. …
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,795 questions
asked 2020-11-10T02:49:47.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 76%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Amar-Azure-Practice
661
Reputation points
answered 2020-11-10T09:36:23.393+00:00
Pramod Valavala
20,661
Reputation points Microsoft Employee
Moderator
2 answers
Migrate DNS zones from 1 Azure subscription to another
Hi guys, This should be pretty basic, but when I search for this I get flooded by Microsoft articles about improrting DNS zones from external companies. We already have all of our public zones hosted in an Azure subscription that is hosted by a CSP. …
Azure DNS
Azure DNS
An Azure service that enables hosting Domain Name System (DNS) domains in Azure.
881 questions
asked 2020-11-05T22:39:10.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 88%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
Heim, Dan
41
Reputation points
answered 2020-11-10T09:35:41.357+00:00
suvasara-MSFT
10,166
Reputation points
Moderator
1 answer
powershell script to copy files to webdav with Rclone
Hi, I am not having that much knowledge in PowerShell. I have to transfer some backup files from My server to WebDAV through rclone.searched and got some documents regarding rclone configuration https://rclone.org/webdav/ Initialy I have…
Windows for business | Windows Server | User experience | PowerShell
asked 2020-11-10T05:45:14.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 71%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Muhasseena T U
1
Reputation point
commented 2020-11-10T09:34:28.233+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
1 answer
old Display name for email still shows when I send message
Hello, I changed my display name EVERYWHERE, but when I send message for someone like client, he receive message with old display name. How can I fix this problem? My plan is: Exchange Online 1
Exchange Online
Exchange Online
A cloud-based service included in Microsoft 365, delivering scalable messaging and collaboration features with simplified management and automatic updates.
7,187 questions
asked 2020-11-04T11:17:32.407+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 18%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Abdullah AbuHaimed
1
Reputation point
commented 2020-11-10T09:33:00.273+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 71%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELZ%3C/text%3E%3C/svg%3E)
Lydia Zhou - MSFT
2,386
Reputation points Microsoft Employee
1 answer
HELP!!!! Unable to open word documents on my MAC?
Some documents in Word and Powerpoint able to open while others cannot. Current version of Word and PPT so it is not an update issue. Need to be able to open ALL documents. HELP!
Microsoft 365 and Office | Install, redeem, activate | For business | MacOS
Microsoft 365 and Office | Install, redeem, activate | For business | MacOS
Processes in Microsoft 365 for setting up Office apps, redeeming product keys, and activating licenses.
1,162 questions
Microsoft 365 and Office | Word | For business | Windows
Microsoft 365 and Office | Word | For business | Windows
A family of Microsoft word processing software products for creating web, email, and print documents.
9,042 questions
asked 2020-11-09T22:28:51.92+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 92%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jennifer Fondrevay
1
Reputation point
answered 2020-11-10T09:21:01.917+00:00
Erin Ding-MSFT
4,496
Reputation points