Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions
2 answers
One of the answers was accepted by the question author.
How to get two business days prior to some date field (Settlement Date)
Hi Everyone, I am trying to get two business days prior to my Date Field (in this case, Settlement Date) For example, I have a Settlement Date of 12/28/2020. Two business days prior to 12/28/2020 would be 12/23/2020. What I have done so far is: …
![](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, 72%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
0 answers
how to enable or reactivate the disabled subscriptions after changing the credit card?
how to enable or reactivate the disabled subscriptions after changing the credit card?
asked 2021-01-05T08:46:39.39+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(160, 55.00000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Basim Rajab
1
Reputation point
commented 2021-01-07T14:18:39.707+00:00
SadiqhAhmed-MSFT
45,181
Reputation points Microsoft Employee
0 answers
Programatically adding resources to ARM template
I am trying to do the following: Create a Dashboard using ARM template and have metrics (eg. Network In, Network Out) for a Virtual machine (eg. VM1). The dashboard created is "Testdashboard" Now using the same template, I want to supply…
asked 2021-01-04T14:04:08.58+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, 70%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGN%3C/text%3E%3C/svg%3E)
Gururaj Nagaraja Rao
6
Reputation points
commented 2021-01-07T14:17:22.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(70.4, 97%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sumeet Bahadkar
1
Reputation point
1 answer
[Migrated from MSDN Exchange Dev]User mailbox not receiving mails from external
[Note] This thread was originally posted on MSDN. As the MSDN Exchange Dev forum mainly focuses on developing issues and the TechNet Exchange forums for general questions have been locked down, we manually migrated this one to Microsoft Q&A platform…
asked 2020-12-25T04:05:16.117+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(252.8, 22%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Lucas Liu-MSFT
6,176
Reputation points
commented 2021-01-07T13:56:42.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(41.6, 25%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Sabarivasan N
31
Reputation points
2 answers
windows server2016 評価版 オフライン環境下でのライセンス認証方法について
こんにちは。 インターネットから隔離されたイントラネット内の仮想サーバにおいて、windows server 2016 評価版の使用を検討しております。 ホームページから評価版のisoファイルをダウンロードしましたが、プロダクトキーがないためライセンス認証ができない状況です。 セキュリティ上、仮想サーバはインターネットに接続することができませんが、オフライン下で評価版ライセンス認証を実施する方法があれば教えてください。
asked 2021-01-05T07:19:02.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(12.8, 47%, 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
Reputation point
commented 2021-01-07T13:49:35.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(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
how can we take system state backup for VM's hosted in Azure?
how can we take system state backup for VM's hosted in Azure?
asked 2021-01-07T13:26:26.77+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(83.2, 75%, 18%)' 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)
Admin
1
Reputation point
answered 2021-01-07T13:47:08.753+00:00
SadiqhAhmed-MSFT
45,181
Reputation points Microsoft Employee
2 answers
Create template with custom presentation for forms
Hello, I can create custom forms e.g. by extendig the standard IR form. And I can create templates on this form, which can be used via "Create Incident From Template". Is it possible to combine this in that way, if you "Create Incident…
asked 2021-01-07T11:26:20.057+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, 5%, 38%)' 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)
Artimes
346
Reputation points
answered 2021-01-07T13:40:18.52+00:00
Andreas Baumgarten
109.1K
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
Logic App Can not Change mail id
Logic App while try to change my mail id to common mail id it is keep on using my own mail id. It is not switching to new mail id .appreciate your help
asked 2021-01-05T16:19:19.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(284.8, 57.99999999999999%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Gnanadurai C
96
Reputation points
answered 2021-01-07T13:39:35.6+00:00
Gnanadurai C
96
Reputation points
0 answers
TypeError: create_images_from_files() missing 1 required positional argument: 'batch'
Hello there, I am trying to upload images to custom vision portal using python. but when i am running the below code it is always throwing TypeError: create_images_from_files() missing 1 required positional argument: 'batch' My code : print…
asked 2020-12-24T17:08:07.303+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(137.6, 19%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Lal Balaji Govind Krishna
1
Reputation point
commented 2021-01-07T13:37:48.417+00:00
romungi-MSFT
45,961
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
issue converting parquet format to csv in ADF
Having the issue converting parquet data type to csv in ADF. I have a pipeline to copy from one blob to another replacing the format of the file from parquet to csv. Here is a sample of the data: header1 header2 header3 header4 header5 1107672220…
asked 2021-01-04T15:39:10.007+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, 26%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
braxx
441
Reputation points
commented 2021-01-07T13:26:57.74+00:00
Nasreen Akter
10,791
Reputation points
1 answer
While Textbox visibility Collapsed textchange event not working
Hi all, Am trying to trigger a change event by binding a data into the textbox from viewmodel. And I want to add a point(button is used as a pointer of selection with selected X, Y points). So I placed a textbox and made its visibility to…
asked 2021-01-07T11:35:37.957+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, 96%, 32%)' 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)
Manu Michael Samuel
131
Reputation points
commented 2021-01-07T13:25:06.947+00:00
Nico Zhu (Shanghai Wicresoft Co,.Ltd.)
12,866
Reputation points
1 answer
Connecting to IoT Edge using the C SDK on macOS
I am running macOS Catalina 10.15.7 and I am trying to use the downstream sample in the IoT SDK, but I keep getting a SSLHandshake failed error. I used this guide to setup my environment, but I'm not having any luck. I also spun up an Ubuntu VM, and…
asked 2020-12-09T18:56:23.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(227.2, 48%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Andrew Fitzpatrick
1
Reputation point
commented 2021-01-07T13:16:07.947+00:00
António Sérgio Azevedo
7,666
Reputation points Microsoft Employee
4 answers
Error login admin page
Goodmorning, I am experiencing a problem logging in to the administration/admin page / app. I want to add an email address and need to open the admin app, but i received this error the last week every day; error: You can try refreshing the page to…
asked 2021-01-07T08:29:19.787+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(307.2, 73%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
WeComplete
6
Reputation points
answered 2021-01-07T13:03:02.427+00:00
Robbert
46
Reputation points
2 answers
QnA Bot + Teams + Python
Hi All, I have created a QnA Bot using QnA Maker and integrated it with Teams using Python. Now I want to implement the following scenario to the Bot- In case of unable to respond to any query Bot should prompt: Ask the agent and after selecting…
Azure AI Bot Service
Azure AI Bot Service
An Azure service that provides an integrated environment for bot development.
833 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,098 questions
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
3,251 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(35.2, 11%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
1 answer
Replication Issue
subscriber connection was down for days, after connection is back, the syncing process is not bi-directional any more! I have checked the sp_replqueuemonitor at subscriber , the result is about 40K record! Also, the queue reader agent continues…
![](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(281.6, 54%, 37%)' 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)
5 answers
External links of communications site in Teams personal app opens twice
External links of communications site in Teams personal app opens twice I'm using a SharePoint Modern communications site as a personal app in my tenant. Last week, links pointing to external sites started opening twice when from the desktop (windows)…
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,098 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(224.00000000000003, 1%, 31%)' 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)
![](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(137.6, 34%, 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)
2 answers
One of the answers was accepted by the question author.
Cannot find 'aapt.exe' - latest version of Visual Studio 2019 and Xamarin installed
Hello, I have the latest version of Visual Studio 2019 community edition installed. A couple of days ago I installed Xamarin and Android SDK by following the instructions given in this course material "Xamarin Tutorial - Hello World in 10…
Xamarin
Xamarin
A Microsoft open-source app platform for building Android and iOS apps with .NET and C#.
5,349 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,918 questions
asked 2021-01-06T12:34:04.043+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(176, 74%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
Jouni Juntunen
141
Reputation points
accepted 2021-01-07T12:28:07.71+00:00
Jouni Juntunen
141
Reputation points
1 answer
One of the answers was accepted by the question author.
Is there any alternative to firestore?
Hello, I am developing uwp apps, I am using local SQLite DB to store user records. Now, I want to store it in a cloud DB. So far I have read about google firestore DB, which provides offline support as mentioned in their documentation, "Cloud…
asked 2021-01-05T14:30:49.137+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, 35%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
MG Bhadurudeen
626
Reputation points
accepted 2021-01-07T12:19:02.517+00:00
MG Bhadurudeen
626
Reputation points
6 answers
One of the answers was accepted by the question author.
How to convert Windows Server 2019 Datacenter Eval to Retail MSDN?
I have bought the Visual Studio Professional Retail annual subscription for ~$2000 in Switzerland (would be $1200 in US) and claimed a key for Windows Server 2019 Datacenter - Retail. I do have an existing test installation of Windows Server 2019…
![](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(80, 35%, 17%)' 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)
2 answers
Security_HKLM_only
Hi, I am hoping someone might be able to help. I have been having an issue with an application which launches an sign-in portal when the app is launched. This throws up a script error where it appears this portal is attempting to use javascript.…
Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
5,387 questions
asked 2021-01-04T16:20:03.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(41.6, 22%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECA%3C/text%3E%3C/svg%3E)
Craig Atkin
1
Reputation point
answered 2021-01-07T12:13:13.35+00:00
DonPick
1,266
Reputation points