Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
6 answers
Compare data between two tables and derive value in new column
I have TABLE1 which is permanent table with huge records and TABLE2 which will be the stage table that truncates and loads every time. That said, the data from stage will be inserted into permanent table on incremental basis: --Final Table CREATE…
asked 2020-11-05T22:47:52.59+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(198.4, 61%, 29%)' 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)
red
21
Reputation points
commented 2020-11-09T09:24:04.477+00:00
MelissaMa-MSFT
24,196
Reputation points
2 answers
One of the answers was accepted by the question author.
Web App showing You do not have permission to view this directory or page error after azure AD enabled
We have web app and azure authentication enabled on it. This was working fine until last week. Last week due to insufficient credits, web app was down. Now I have added my credit card then web app is up and running. But now it is showing You do not…
asked 2020-11-04T11:53:33.13+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, 14.000000000000002%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMY%3C/text%3E%3C/svg%3E)
Mihir Yelamanchili
21
Reputation points
accepted 2020-11-09T09:23:15.76+00:00
Mihir Yelamanchili
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Lost access to subscription attached on a directory without access
Hi, A company have lost it access to manage any resources on a subscription Althought the company is owner of the subscription, it can't manage any resources because it's attached on a directory on which the company don't have access (it's a personal…
asked 2020-11-08T13:58:53.263+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, 47%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Anthony BOUQUET
21
Reputation points
answered 2020-11-09T09:18:52.96+00:00
Anthony BOUQUET
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Windows Biometric Framework, problem with RejectDetail of WINBIO_CAPTURE_DATA
I get sample code of WBF fingerprint device in the following microsoft web pag. https://video2.skills-academy.com/zh-tw/windows/win32/api/winbio_adapter/nc-winbio_adapter-pibio_sensor_finish_capture_fn?redirectedfrom=MSDN In this page, there are definition…
![](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(19.2, 16%, 11%)' 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)
1 answer
One of the answers was accepted by the question author.
ms access runtime Quick Access Toolbar (QAT)
In my MS Access 16 application (.accdb), I can use my Quick Access Toolbar (QAT). However, when using this application by changing the name (.accdr) with MS Access RUNTIME, I can't see my QAT. How can I make this QAT visible? If it is not…
asked 2020-11-08T15:36:56.833+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(86.4, 61%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Jacques Van den broeck
21
Reputation points
accepted 2020-11-09T09:12:06.883+00:00
Jacques Van den broeck
21
Reputation points
4 answers
Error while springboot application starts up in azure spring cloud - "could not locate property source and fast fail property is set"
Error while springboot application starts up in azure spring cloud - "could not locate property source and fast fail property is set" . The App is currently running in a VM environment and I am trying to port it to azure spring cloud. I have a…
asked 2020-10-21T15:44:13.807+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(140.8, 76%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGT%3C/text%3E%3C/svg%3E)
Goswami, Tuhin
21
Reputation points
commented 2020-11-09T09:10:51.983+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(51.2, 79%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Krish G
2,331
Reputation points
2 answers
One of the answers was accepted by the question author.
The description for Event ID 111 from source Microsoft-Windows-EventForwarder cannot be found.
I have source initiated subscription method of Event Log Forwarding. I'm trying to forward existing/historic SMBServer event ID 3000 logs. Error from Event Log Forwarding setup: The description for Event ID 111 from source…
asked 2020-11-03T23:19:18.627+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(86.4, 45%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kamran Ahmed
271
Reputation points
accepted 2020-11-09T09:10:25.527+00:00
Kamran Ahmed
271
Reputation points
3 answers
One of the answers was accepted by the question author.
we are unable to add web-part in workbench.aspx on premise SharePoint 2019
we are unable to add web-part in workbench.aspx on premise SharePoint 2019
asked 2020-11-02T13:25:56.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(99.2, 85%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Mohammad Javed
151
Reputation points
accepted 2020-11-09T09:05:22.847+00:00
Mohammad Javed
151
Reputation points
2 answers
Cluster storage disk online(No Access)
Hi All, We are using WS 2012 hyper-v running on clustered storage. The configuration was working fine for the last 4 years. Today morning 2 of the disks in cluster seems to have lost connection and can be seen as online(no Access). due to which VMs…
asked 2020-11-02T12:32: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(112.00000000000001, 85%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
Nandal, Preeti
1
Reputation point
commented 2020-11-09T09:05:00.147+00:00
Xiaowei He
9,891
Reputation points
2 answers
Can we use Microsoft Intune with Exchange Online Plan 1?
Can we user Microsoft Intune with Exchange Online Plan 1?
asked 2020-10-12T11:54:56.017+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, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Allauddin Mutalief
1
Reputation point
answered 2020-11-09T09:00:29.07+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(262.40000000000003, 67%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGH%3C/text%3E%3C/svg%3E)
Gerry Hampson MVP
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Fields doesn't exist on web
Property 'Fields' does not exist on type 'IWeb' when I'm using PnP Js in SPFX: const fields = await web.fields(); Is this because of I'm using wrong PnP js version ? Please help
asked 2020-11-05T01:23:36.65+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-11-09T08:57:09.697+00:00
developer sp1
461
Reputation points
2 answers
Monitor ADFS User logon / logoff events to federated applications
Thanks in advance I need to audit user logon and logs offs on our applications that use ADFS for federation, but I cannot seems to find any information on how to manage this. here is what I need to do, if a user logs on to one of our applications…
asked 2020-02-06T20:40:17.603+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(166.4, 50%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELG%3C/text%3E%3C/svg%3E)
Luis Gonzales
1
Reputation point
commented 2020-11-09T08:56:39.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(236.8, 0%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Bart Hermans
6
Reputation points
3 answers
exchange 2016 autodiscover working from workgroup machines not from domain joined machines all on same lan
from a client machine that is on a work group on the LAN i am able to connect to exchange through outlook this problem is only for outlook so i should be autodiscover, strangely from a domain joined machine it keeps asking for pwd? any thoughts
asked 2020-10-26T20:36:31.513+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, 3%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Maher Ramadan
286
Reputation points
commented 2020-11-09T08:50:42.837+00:00
KyleXu-MSFT
26,261
Reputation points
0 answers
Using MediaCapture from WPF Framework class assembly
I have an existing WPF application that needs to make use of the MediaCapture class. The idea is to put the image management in a class assembly so that the same code can easily be used across multiple applications. There are a couple of examples on how…
asked 2020-11-09T01:35:50.113+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(0, 9%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Richard Haggard
6
Reputation points
commented 2020-11-09T08:48:58.767+00:00
DaisyTian-1203
11,621
Reputation points
1 answer
Converting Exchange2010 to 365 - Exchange patching questions.
I 'm working with a company now that had the IT person leave unexpectedly. I have looked over the system and there are a number of updates I need to make. I have begun replacing their old DCs so now I am moving on to Exchange. They have Exchange 2010…
asked 2020-11-02T20:24:26.023+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(35.2, 73%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
EST_IT
21
Reputation points
commented 2020-11-09T08:48:47.29+00:00
KyleXu-MSFT
26,261
Reputation points
5 answers
One of the answers was accepted by the question author.
Errors with Server 2019 2020-10 Cumulative Update for Windows Server 2019 (1809)
Hi Getting error code 80073712 when trying to install the latest update Gone through all the Microsoft troubleshooting tools and I am still not getting anywhere Anyone else had this issue? Thanks
asked 2020-11-02T13:34:47.383+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, 81%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Stephen Allen
21
Reputation points
accepted 2020-11-09T08:35:31.393+00:00
Stephen Allen
21
Reputation points
1 answer
QUITAR CIFRADO A CARPETAS DE WINDOWS 10
Hola, acudo a este medio ya que me he cansado de buscarle solución a este problema recurrí a vídeos como a la página de microsoft y leí que está página es para lo mismo pero más avanzado les explico: Tengo está carpeta con cifrado de Minecraft (como dato…
asked 2020-11-02T06:29:11.723+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(313.6, 35%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
David Garcia
1
Reputation point
commented 2020-11-09T08:35:30.583+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(38.4, 50%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJY%3C/text%3E%3C/svg%3E)
Jenny Yan-MSFT
9,336
Reputation points
2 answers
One of the answers was accepted by the question author.
Migration Manager Move or Copy
Hi, Quick question regards using Microsoft's Migration Manager for Fileshare migration to OneDrive. When you run a task to migrate, is it a copy or move action? Thanks
![](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(105.60000000000001, 54%, 20%)' 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)
0 answers
Hide shared mailbox in Sharepoint site
As the topic. How hide only shared mailbox in Sharepoint site (Web Part Address Book)?
asked 2020-11-06T22:53:18.66+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(294.40000000000003, 40%, 38%)' 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)
DDD
1
Reputation point
commented 2020-11-09T08:33:20.127+00:00
Allen Xu_MSFT
13,826
Reputation points
1 answer
How to include excluded disks in azure backup
Hi All, I have 2 excluded disks from backup. I want to include them to my bakcup azure, but when i run my az command i have an error. My az command (I use --vm $() because my VM is not in the same Resource group of the Backup vault name): az backup…
asked 2020-11-06T14:25:04.1+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(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' %3EHA%3C/text%3E%3C/svg%3E)
HARRAG Achraf [ECM] (EXT)
6
Reputation points
answered 2020-11-09T08:31:18.443+00:00
SadiqhAhmed-MSFT
45,181
Reputation points Microsoft Employee