Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,717 questions
2 answers
Select query to get data based on which table has the row
Hi, We get a data from vendor and import into our tables. We get one transaction at a time. In banking world like transfer of money from one account to another. So, there is withdrawal transaction and deposit transaction. They come one at a time.…
Developer technologies | Transact-SQL
asked 2020-09-15T22:22:39.207+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(32, 43%, 13%)' 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)
Spunny
366
Reputation points
commented 2020-09-23T02:51:12.16+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(236.8, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EchoLiu-MSFT
14,626
Reputation points
1 answer
Is it possible to add an Active Directory object to a security group via a group policy
The intent is to automatically add an Active Directory object to an Active Directory security group when it is created in or moved into a specific OU. I currently have a PowerShell script that will retrieve each object and add them to the security group…
Windows for business | Windows Client for IT Pros | User experience | Other
asked 2020-09-14T21:21:24.313+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(195.2, 4%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
steven gamble
1
Reputation point
commented 2020-09-23T02:17:39.523+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
2 answers
Laps Saved password count
Is there any way we can count how many passwords are stored in our LAPS database?I have a command to export all the passwords but I don't want to export them I just want to count how many passwords of systems are available.
Windows for business | Windows Client for IT Pros | Directory services | Active Directory
asked 2020-09-16T10:13:45.95+00:00
Muhammad Hussain
201
Reputation points
commented 2020-09-23T02:15:06.947+00:00
Anonymous
1 answer
MSIX Dependancy
I have a packaged network driver that needs to run prior to my application being installed. e.g. wintun.msi. And it does not execute in the installer from Windows Store so it leaves my network service hanging. So I tried adding a "Package…
Microsoft Partner Center | Other
Microsoft Partner Center | Other
Other features or issues related to Microsoft Partner Center
2,263 questions
asked 2020-09-21T15:02:29.56+00:00
Anonymous
commented 2020-09-23T02:12:03.713+00:00
Anonymous
2 answers
How can i change 'SharePoint' located in the top left corner in SHAREPOINT ONLINE
I moved to SharePoint 2013 to SharePoint Online. Again, I am using SharePoint Online... How can i change the top-left 'SharePoint'? I am using SPO so using below code is not an option. $webApp = Get-SPWebApplication…
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,922 questions
asked 2020-09-22T18:27:21.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(172.8, 75%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
helloworldfromed
51
Reputation points
commented 2020-09-23T02:11:41+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(67.2, 7.000000000000001%, 16%)' 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)
MichaelHan-MSFT
18,136
Reputation points
2 answers
Windows Server built-in iBGP with RRAS via S2S VPN connection
Hi, Comunity and Microsoft's engineers. This is a question, related to co-working of RRAS, S2S VPN, and BGP on MS Windows Server platform. It looks as is the built-in BGP component doesn't work properly with S2S VPN. At least - I can't configure it…
Windows for business | Windows Server | Devices and deployment | Set up, install, or upgrade
Windows for business | Windows Server | User experience | Other
20,405 questions
asked 2020-09-19T00:17:18.27+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(259.20000000000005, 92%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN8%3C/text%3E%3C/svg%3E)
ns.88.ns
16
Reputation points
commented 2020-09-23T02:04:11.5+00:00
Anonymous
1 answer
32-bit ASNs
I am try to get BGP working on Windows Server 2019 Datacenter I've gotten the Routing and Remote Access role installed. But when I try to use the Add-BgpRouter command (or the Set-BgpRouter command) in PowerShell, I've found the LocalASN parameter (as…
Windows for business | Windows Server | User experience | Other
20,405 questions
asked 2020-09-11T16:57:56.447+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, 73%, 33%)' 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)
Lathrop, Andrew
1
Reputation point
commented 2020-09-23T01:57:40.137+00:00
Andy YOU
3,076
Reputation points
1 answer
Partner Center: Microsoft Store submission API calls always return HTTP 409 for one of the applications
I am unable to use Microsoft Store submission API to manage one of my apps. I wrote a script that updates submissions on the flight, based on the documentation, and it works well with one of my apps, but not at all with another. For example, I make…
Community Center | Not monitored
Community Center | Not monitored
Tag not monitored by Microsoft.
54,291 questions
asked 2020-09-17T14:09:47.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(169.60000000000002, 79%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHW%3C/text%3E%3C/svg%3E)
Hello World
1
Reputation point
answered 2020-09-23T01:51:45.703+00:00
Anonymous
4 answers
SQL Server installation failure as first attepting to install
Hi i have been trying to install SQL Server 2019 as download from the website, however when I mount the disc image from the folder the wizard attempts to start however it blinks and fails. I also tried to load the wizard from the downloads folder from my…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,743 questions
asked 2020-09-21T16:22:30.687+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(76.8, 44%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFC%3C/text%3E%3C/svg%3E)
Fredrick Carter
1
Reputation point
answered 2020-09-23T01:48:45.997+00:00
m
4,286
Reputation points
4 answers
When input an error instance name and right port number of sql server 2016, still connect successfully
![25841-error.jpg][1]![25730-ok.png][2] [1]: /api/attachments/25841-error.jpg?platform=QnA ---- error instance name [2]: /api/attachments/25730-ok.png?platform=QnA ---- right instance name for the same server
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,743 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(83.2, 92%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
GetFile with Id instead of Relative Url in Rest API
I know we can get file by relative url like this: /_api/web/getFileByServerRelativeUrl('/sites/Test/Documents/Doc1.docx') But now I want to get with Id like this: /_api/web/GetFileById('<file unique id>') I don't know how to get this file…
Microsoft 365 and Office | SharePoint Server | Development
Microsoft 365 and Office | SharePoint Server | Development
The process of building custom solutions for SharePoint Server.
1,734 questions
asked 2020-09-22T01:42:25.54+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(156.8, 64%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
developer sp1
461
Reputation points
accepted 2020-09-23T01:45:59.347+00:00
developer sp1
461
Reputation points
0 answers
[UWP][Bug]Listing folders derived from MediaServerDevices returns only the first 200 items
When using Windows.Storage.KnownFolders.MediaServerDevices, and folders derived from it, when there are more than 200 items in the folder, GetItemAsync() returns the first 200 items only, and there is no way to get the next ones. Even with…
Developer technologies | Universal Windows Platform (UWP)
Developer technologies | Universal Windows Platform (UWP)
A Microsoft platform for building and publishing apps for Windows devices.
3,084 questions
asked 2020-08-25T19:05:57.747+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(185.6, 93%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dimitrov
1
Reputation point
commented 2020-09-23T01:40:09.737+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(73.60000000000001, 61%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFW%3C/text%3E%3C/svg%3E)
Fay Wang - MSFT
5,231
Reputation points
2 answers
Audit for Unlicensed SharePoint users
We use SharePoint to allow our customers to view and upload documents, but their access does not include a license. We want to monitor who is active and who is not so that we can deactivate, and potentially remove, inactive accounts. I've been unable…
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,922 questions
asked 2020-09-09T20:11:27.607+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(243.2, 4%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDE%3C/text%3E%3C/svg%3E)
Desiree Eversole
1
Reputation point
commented 2020-09-23T01:38:01.007+00:00
Itch Sun-MSFT
2,566
Reputation points
1 answer
Office.context.document.settings added to word document using the desktop mode word is not available when the document is opened in web mode word.
Hi Team, We are saving some properties of the word document using the desktop mode as follows: Office.context.document.settings.set("property","value"); It is available in the desktop mode word document. If the same document is opened…
Community Center | Not monitored
Community Center | Not monitored
Tag not monitored by Microsoft.
54,291 questions
asked 2020-09-22T07:27:55.543+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, 25%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Praveenkumar Rajan
1
Reputation point
answered 2020-09-23T01:25:57.367+00:00
Emily Hua-MSFT
27,901
Reputation points
2 answers
One of the answers was accepted by the question author.
OneDrive Synce Rename Issue
Hi Guys, I'm trying to setup OneDrive for myself - I've moved 150GB of Data accross, and everything has been fine, execpt that there are 2 files that need renaming. When I go to rename them, it says "rename finished with errors". - I cant get…
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,922 questions
asked 2020-09-22T21:15:17.63+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(60.8, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWM%3C/text%3E%3C/svg%3E)
William McCormack
21
Reputation points
commented 2020-09-23T00:51:23.717+00:00
Anonymous
3 answers
Different Measures calculation according to Client/Date
Hi all!! I'm new to SSAS Tabular Mode and DAX and I was wondering if anyone could help me, please. I have to create a Measure that uses different formulas accordingly to the Client and Date dimensions. For instance, I have a Measure named…
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,372 questions
asked 2020-08-19T17:03:53.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(278.4, 34%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHL%3C/text%3E%3C/svg%3E)
Henrique Lima
1
Reputation point
answered 2020-09-23T00:47:09.873+00:00
Henrique Lima
1
Reputation point
1 answer
liabilty due to xbox controller catching fire
Are there any xbox controller recalls due to fire? I know have a burned up couch and heavy smoke damage throughout the entire house. Any help would be greatly appreciated. Rich Cell 303-961-1572
Community Center | Not monitored
Community Center | Not monitored
Tag not monitored by Microsoft.
54,291 questions
asked 2020-09-22T23:27:26.377+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(227.2, 27%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETO%3C/text%3E%3C/svg%3E)
Tina O'Bryan
1
Reputation point
answered 2020-09-23T00:30:50.427+00:00
Anonymous
1 answer
One of the answers was accepted by the question author.
Data Factory copy data to another container
Hi Everyone, Could you help me please In Data Factory I created Copy Data pipelines from one Storage account (Containers) to another Storage account (Containers), copy working fine , could tell me please how I can configured to keep every time new…
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,160 questions
asked 2020-09-17T23:23:48.12+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(227.2, 85%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Alex Corovin
46
Reputation points
accepted 2020-09-23T00:16:21.977+00:00
Alex Corovin
46
Reputation points
1 answer
Do Azure SQL backups get included in DTU limits?
Can anyone tell me if an azure SQL backup operation could contribute as part of a database's DTU limit? I have a DB that frequently hits its max DTU every 12 hours or so, which seems suspiciously like a backup operation.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,862 questions
asked 2020-09-15T08:57:15.087+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(214.4, 44%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Mark Harrison
6
Reputation points
commented 2020-09-23T00:15:22.09+00:00
Anonymous
1 answer
WVD _ Deployment error
I have tried multiple time to deploy WVD every time getting error - {"message":"Deployment template validation failed: 'The provided value…
Azure Virtual Desktop
Azure Virtual Desktop
A Microsoft desktop and app virtualization service that runs on Azure. Previously known as Windows Virtual Desktop.
2,111 questions
asked 2020-09-21T15:00:10.87+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(204.8, 90%, 29%)' 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)
akhilesh
1
Reputation point
answered 2020-09-22T23:58:15.95+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(118.4, 98%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KarishmaTiwari-MSFT
20,862
Reputation points Microsoft Employee
Moderator