Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,640 questions
5 answers
One of the answers was accepted by the question author.
How to pivot table?
I have a table with following values. Type New Closed Reopen Claim 32 14 97 Line 14 37 7 How do…
![](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, 84%, 11%)' 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)
8 answers
One of the answers was accepted by the question author.
Using "-or" in powershell
Hello, please help me to filter this sample: $obj = New-Object psobject -Property @{ FirstName = "Dave" LastName = "Gahan" Band = "Depeche Mode" } if (($obj.FirstName) -or (($obj.Band…
asked 2020-11-12T09:27:18.463+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(179.20000000000002, 86%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mountain Pond
1,441
Reputation points
commented 2020-11-16T22:41:37.503+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(256, 74%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rich Matheisen
46,796
Reputation points
0 answers
Expiry Datetime incorrect for Tumbling Window Trigger Catchup Run?
I have a pipeline that primarily has 2 copy activities . The sink for the copy activities is ADLS Gen 1, so it also sets an expiry datetime for each of the files copied over. It uses a tumbling window trigger with a self-dependency. Recently, the…
asked 2020-11-06T19:26:33.123+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, 36%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Rasika Athavale
1
Reputation point Microsoft Employee
commented 2020-11-16T22:40:37.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(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,476
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
DMV : sys.dm_os_volume_stats
Hello, Is there a way to get historical data from querying with this DMV : sys. dm_os_volume_stats ? I would like to see what the size of the a drive was for each day in the month. Please advise. Thank you, Veena
asked 2020-11-13T21:22:56.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(128, 67%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Veena Srinivas
251
Reputation points
accepted 2020-11-16T22:35:58.347+00:00
Veena Srinivas
251
Reputation points
1 answer
One of the answers was accepted by the question author.
B2C Multi-Tenant Management
Hi, a (hopefully) quick question: We're looking into the following setup for a client: Azure AD B2C Instance Web App 1 (remotely hosted) Web App 2 (remotely hosted) Web App 3 (remotely hosted) Admin App (hosted on Azure App Service) …
asked 2020-11-16T04:15:20.21+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, 76%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Dee, Matthew TPC
156
Reputation points
commented 2020-11-16T22:30:40.193+00:00
Dee, Matthew TPC
156
Reputation points
1 answer
Logs are missing in the Log Analytics Workspace - Azure Data Factory starting 10/23/2020
Hello, Our ADF and the log analytic workspace are hosted under West US2, same as our ADF, and since 10/23, we’ve noticed several pipeline runs do not come with the Succeeded or Failed log, but just InProgress or Queued. It threw off our query since…
![](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, 98%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
1 answer
Asynchronous execution of statements in stored procedure in Synapse
I have a stored procedure that creates tables and indexes. Is there a way to run these asynchronously inside the stored proc?
asked 2020-11-06T01:22:19.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(153.6, 2%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Deepthi Kodaru
1
Reputation point
commented 2020-11-16T22:26:21.583+00:00
HimanshuSinha-msft
19,476
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Register the service principal for Azure Front Door as an app in your Azure Active Directory via PowerShell
Register the service principal for Azure Front Door as an app in your Azure Active Directory via PowerShell Hi - are you able to tell me if this will cause any type of outage? Especially if other front doors already in use in the environment, but with…
asked 2020-05-11T13:15:20.143+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, 14.000000000000002%, 32%)' 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)
Jen F
21
Reputation points
commented 2020-11-16T22:17:08.717+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(182.40000000000003, 1%, 27%)' 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)
Mick Badran
1
Reputation point MVP
2 answers
Data Factory Loading multiple csv files. Is there any way of dealing with column header differences?
I have csvs in a datalake. Im coping them into SQL using the copy activity the File Path type is a wildcard file path Very occasionally there are slight differences between the column headers. Is there any way that this can be dealt with rather…
asked 2020-11-05T12:56:42.187+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, 27%, 29%)' 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)
Debbie Edwards
521
Reputation points
commented 2020-11-16T22:16:54.58+00:00
HimanshuSinha-msft
19,476
Reputation points Microsoft Employee
1 answer
copying data from azure file share to synapse
Hi , I have one requirement like - 1)my users will load some data to azure file share that is mounted on there machine 2) now i want to copy that data from azure file share to container in storage account 3)from that container i want to serve data to…
asked 2020-11-04T07:49:56.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(35.2, 28.000000000000004%, 13%)' 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)
Rohit Boddu
466
Reputation points
commented 2020-11-16T22:08:03.217+00:00
HimanshuSinha-msft
19,476
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
remove user from sphere tenant, company migrated to Office 365
I need to remove a user from Azure Sphere. The user registered using a company email that was assigned to a Microsoft Tenant user. The company has since migrated to Office 365 using Active Directory sync. The existing registered user was removed so…
asked 2020-10-08T22:59:05.507+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(64, 8%, 16%)' 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)
Doug Hardy
31
Reputation points
commented 2020-11-16T22:07:28.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(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache
20,271
Reputation points
1 answer
Failed to Locate a Column at Position x in the Output Event
Hi all I'm running an export job out of IOTCentral for measurements data and that is going into an Event Hub. I'm then using Stream Analytics to move the data into an Azure SQL table. I've switched on the error tracking in the Stream Analytics log and…
asked 2020-11-02T13:11:27.533+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(124.80000000000001, 62%, 22%)' 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)
John Clifford
21
Reputation points
commented 2020-11-16T22:06:10.853+00:00
HimanshuSinha-msft
19,476
Reputation points Microsoft Employee
1 answer
Ugrading the Azure VM of Window 10 to Visual Studio 2019 VM
Hi We have a bought a windows 10 VM for a fixed price from Azure ( 3 years lock in). My question is that can I delete this VM and create a new VM of Visual studio of same configuration. Does it affect our billing? Current VM Config : …
asked 2020-11-16T06:49:59.57+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(147.20000000000002, 35%, 24%)' 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)
Ankur Shah
1
Reputation point
answered 2020-11-16T21:35:46.62+00:00
whoward-msft
2,766
Reputation points
6 answers
One of the answers was accepted by the question author.
Accessing expired azure student account
I need to access a VM on an expired AZURE Student account, either make it a pay as you go account or access the VM(RDP to download files) to download files any suggestions to make either option happen? I have a new pay as you go account but can't…
asked 2020-11-16T20:55:37.237+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, 76%, 25%)' 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)
Powell, Gary Anthony
21
Reputation points
commented 2020-11-16T21:34:23.637+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
One of the answers was accepted by the question author.
I would like to ask about additional explanations about Prohibited content
Hello everyone. I have a several questions: Can I include into a project repository my own EULA\License text for the source codes? Can I use Azure DevOps for free and open-sourced projects? Because here…
asked 2020-11-13T22:52:52.82+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, 92%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sergei Pogrebniak
136
Reputation points
accepted 2020-11-16T21:23:53.3+00:00
Sergei Pogrebniak
136
Reputation points
3 answers
One of the answers was accepted by the question author.
How to create a new StreamingEndpoint for AMS
I'm trying to acces the client.StreamingEndpoints.CreateAsync method that requires resourceGroupName, accountName, streamingEndpointName and paramaeters of type StreamingEndpoint. How do I access this method. I can't seem to figure out how to create a…
asked 2020-11-11T14:28:45.487+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, 34%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
nbm-Syncronet
191
Reputation points
commented 2020-11-16T21:22:17.177+00:00
Grmacjon-MSFT
18,131
Reputation points
1 answer
One of the answers was accepted by the question author.
Powershell Insert Blank Cell for Nonexistent Users in a csv
Hello, I am trying to find managers for each user listed in a csv, then export the results. Here is what I have so far: $list = import-csv "C:\users.csv" $managers = ForEach($User in $list){ Get-ADUser $User.name -Properties…
asked 2020-11-16T19:27:24.157+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, 80%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECE%3C/text%3E%3C/svg%3E)
Charles Eaton
21
Reputation points
commented 2020-11-16T20:56:27.193+00:00
Charles Eaton
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure ACI for 11 hours everyday
Hi, i have an Azure VM with WINDEV and HFSQL Server which runs for 11 hours per day and 5 days a week. So total 55 hours during week. I am planning to containerize it . Is it good to go for Azure ACI for using 11 hours per day ? Please advise
asked 2020-11-09T10:46:46.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(96, 71%, 19%)' 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)
MS Techie
2,701
Reputation points
commented 2020-11-16T20:52:17.567+00:00
whoward-msft
2,766
Reputation points
1 answer
certification help
need help with my certification, test is not showing up on dashboard as passed.
asked 2020-11-16T20:24:49.767+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, 80%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEG%3C/text%3E%3C/svg%3E)
Edgar Grajeda
1
Reputation point
answered 2020-11-16T20:33:37.643+00:00
Anonymous
1 answer
Assign role Storage Contributor to a VM with Java SDK
Hello all, I am currently writing a Java program that creates a VM and wants to download a file from a storage into the VM. Therefore I need to assign access to the VM with role Storage blob data contributor. However, I cannot seem to be able to find how…
asked 2020-11-16T11:43:52.013+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, 1%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Stefanova Vesela (IOC/PDL-TQ)
1
Reputation point
answered 2020-11-16T20:29:36.107+00:00
deherman-MSFT
37,331
Reputation points Microsoft Employee