Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,652 questions
3 answers
One of the answers was accepted by the question author.
Dynamic SQL in UDF - Work around
Hello everyone I have a 16 period fields in a schema, for example PreviousMonth where each date in the previous month has a value of 1 I trying to write a function that returns the Max date key dependant on the Field I pass in PreviousMonth,…
asked 2020-11-23T13:54:22.89+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(115.19999999999999, 5%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
ron barlow
411
Reputation points
answered 2020-11-24T00:07:52.107+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, 89%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Joe Celko
16
Reputation points
1 answer
One of the answers was accepted by the question author.
error APT1000: Attribute "imageAspectRatioAdjust" already defined with incompatible format.
the following error comes out after changing the target platform from Android 8 to Android 9, 10 or 11. + updating dependencies + migration to AndroidX: \ obj \ Debug \ 110 \ lp \ 64 \ jl \ res \ values \ values.xml (4): error APT1000: Found tag id…
asked 2020-11-23T12:18:53.837+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, 49%, 17%)' 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)
Александр Р
116
Reputation points
accepted 2020-11-23T23:58:16.113+00:00
Александр Р
116
Reputation points
5 answers
One of the answers was accepted by the question author.
Powershell and Published Data Orchestrator 2016
I am using Orchestrator 2016 with the reg change to make it use powershell 5. In Powershell ISE, I run this simple query for a remote box to check the status of Windows updates via WMI: $CCMUpdate = get-wmiobject -query "SELECT * FROM…
asked 2020-11-23T17:41:35.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(9.6, 6%, 10%)' 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)
ben
21
Reputation points
commented 2020-11-23T23:36:37.053+00:00
Andreas Baumgarten
111.1K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
IIS compression intermittent
We have a conflict with our JavaScript minifier and IIS compression. The minifier recreates the file when the app pool resets and on other occasions. The zipped version of the file that was stored by IIS is occasionally not a complete file. We are…
asked 2020-11-19T18:30:38.573+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, 56.00000000000001%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Robert Crockett
21
Reputation points
accepted 2020-11-23T23:23:54.973+00:00
Robert Crockett
21
Reputation points
1 answer
Azure Notification not working window app based
Hi I tried to use windows app based notification using azure Created Developer Portal Created the App On product management WPN/MSPN click and clicked on Live Services site. Copied the Application Secrets and Package SID In Azure Portal…
![](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(144, 89%, 23%)' 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)
1 answer
How to enable MFA in azure for SaaS applications?
Hello, We have our AD/ADFS hosted in azure on a vm ( not Azure AD) and are using it as identity provider for external applications ,now we have a requirement to enable MFA for a particular SaaS application , is it possible to enable MFA without Azure…
asked 2020-11-22T10:28:07.793+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(80, 24%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
roy lucky
1
Reputation point
commented 2020-11-23T22:13:39.86+00:00
Andy David - MVP
149.1K
Reputation points MVP
1 answer
Microsoft docs learning points have dissapeared
Hi My learning history resetted for some reason? I was at level 7-8 because of all the point/courses I have achieved, but now I re-visited the website and i'm back at 0 (level 1). A bit dissapointing you can imagine, any idea what could be the…
asked 2020-11-23T22:10:23.01+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, 54%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
Andreas Otten
1
Reputation point
answered 2020-11-23T22:12:11.833+00:00
Leon Laude
85,816
Reputation points
1 answer
One of the answers was accepted by the question author.
Exchange Certificate Renewal
My existing Exchange certificate is about to expire so I renewed it using the EAC console. I sent the CA request to my CA provider, got the cert, completed the cert request on my server and now I have TWO Exchange SMTP certificates for the same domain. …
asked 2020-11-23T14:26:15.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(3.2, 45%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Joshua Thompson
166
Reputation points
commented 2020-11-23T22:06:24.95+00:00
Joshua Thompson
166
Reputation points
5 answers
One of the answers was accepted by the question author.
SSRS History snapshots
How to find SSRS History snapshots retention on all reports ? Can we force the default History snapshots retention settings for all reports
![](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, 57.00000000000001%, 33%)' 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
Xamarin.ios app crashes on 14.2 when downloaded via MDM
When xamarin.ios app is downloaded via MDM it crashes immediatedly after startup. The app works fine when downloaded via apple store/testflight
asked 2020-11-23T15:30:07.74+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, 42%, 29%)' 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)
coder
1
Reputation point
commented 2020-11-23T21:56:52.9+00:00
Borisoprit
371
Reputation points
1 answer
I need to reschedule
I never received confirmation of my exam schedule. I now see it's scheduled for tomorrow but I a) Just returned from my honeymoon, b) have not prepared at all and c) am told my work computer can't be used for the exam. I need to reschedule for the…
asked 2020-11-23T21:40:29.227+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, 33%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWB%3C/text%3E%3C/svg%3E)
Ward, Brian
1
Reputation point
answered 2020-11-23T21:47:19.58+00:00
Leon Laude
85,816
Reputation points
0 answers
Azure Container instance app replaced by azure functions app
Hi, I am developing an app using Azure Container Instances. I have deployed my app with configured nginx inside the container and CNAME record on my domain provider pointing to containers FQDN Everything worked as expected and I could…
asked 2020-11-21T12:19:36.877+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, 39%, 25%)' 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)
Artur Symanovic
21
Reputation points
commented 2020-11-23T21:19:13.933+00:00
whoward-msft
2,766
Reputation points
3 answers
Azure Firewall and Azure VPN Gateway
Hello experts, Quick question here when setting up Azure VPN Gateway for site to site VPN from On-prem to Azure for S2S connectiing and also using Azure FW for network perimeter filtering and inspection from On-prem to Azure. Now on the Gateway…
asked 2020-11-20T17:49:47.757+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(134.4, 84%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Shola Lawani
531
Reputation points Microsoft Employee
commented 2020-11-23T21:18:26.407+00:00
Shola Lawani
531
Reputation points Microsoft Employee
2 answers
Steps and proedure for Connecting Azure App Service to the Local OnPremise SQL Database via Express route ?
Hi All, My company has already established the ExpressRoute so my Corporate OnPremise network can access Azure resources internally. Could someone please share the steps for me to connect the app service to Express Route so the Azure App Service can…
asked 2020-11-13T06:46:41.967+00:00
EnterpriseArchitect
5,406
Reputation points
commented 2020-11-23T21:13:40.28+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, 36%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SaiKishor-MSFT
17,236
Reputation points
1 answer
Do Azure Firewall at VNet blocks any log analytics workspace data
I have a set of VMs spread across different VNets, these VMs logs data to Log Analytics workspace and these VNets are connected via Hub-Spoke topology. Looking to implement Azure Firewall at Hub to increase the security across my VNet resources. Now I…
asked 2020-11-11T08:39:48.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(163.2, 36%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA9%3C/text%3E%3C/svg%3E)
AzureUser-9588
151
Reputation points
commented 2020-11-23T21:12:18.683+00:00
SaiKishor-MSFT
17,236
Reputation points
2 answers
Can we get somebody to merge some of the pull requests on the aci-deploy github action repository?
Hi folks, I'm using the Microsoft-written Github action for deploying to an Azure Container Instance resource. The Github action itself has some bugs in the code and does not work. I have provided a pull request for the bug I encountered. I also see…
asked 2020-10-20T15:51:07.197+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(80, 66%, 17%)' 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)
Ryan
6
Reputation points
answered 2020-11-23T21:06:16.163+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(281.6, 99%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Dustin Briles
1
Reputation point
7 answers
One of the answers was accepted by the question author.
ASR Configuration Server - Unable to pass the validation step 3 (Install 3rd party software)
ASR Configuration server. First time setup, image (OVL) downloaded from Azure and untouched. Problem: When trying to "Download and Install" MySQL a red X appears saying "Loading..." but nothing happens. I am stuck here. Dev…
asked 2020-11-19T16:48:18.107+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, 79%, 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)
Michele
21
Reputation points
answered 2020-11-23T20:57:56.967+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, 67%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Raj Kumar Elumalai
1
Reputation point
1 answer
Securing Single Web App.
I currently have a single Web App and Durable Functions, 2 VMs and 1 Azure SQL Database and 1 Cosmos DB. I wanted to know what is the best approach to secure the Web App. I have read WAF, or WAF with Application Gateway or Front Door. I would need…
![](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(134.4, 90%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%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(153.6, 92%, 24%)' 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.
How to point domain in DNS zone to static website
Hello. We have a domain that's currently hosted with One.com. I have created a DNS Zone in Azure, and have entered the name servers from Azure into the domain configuration at One.com. When doing an nslookup on the domain, I can see that the name…
![](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, 52%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Moving Domain Controller to New Site - Questions
Hello all. We have a domain AD site that has multiple domain controllers. We have recently started standing up DCs that are protected by Cisco ACI. We are now half ACI and half legacy that are not. We would like to start to force authentication in this…
asked 2020-11-23T18:35:28.967+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(102.4, 6%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Don Harvey
21
Reputation points
accepted 2020-11-23T20:36:03.697+00:00
Don Harvey
21
Reputation points