Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,690 questions
2 answers
One of the answers was accepted by the question author.
manupulate strings in sql server
I have a string like "WITH MEMBER [Service Rate].[Service Rate].[#~~fdd-7796-4295-a59d-affdfd~~#] AS AGGREGATE([#~~fdfdf-4b4e-4e3a-b0f1-fdfd~~#]) , Caption='Current Period' , SOLVE_ORDER=0 , Scope_Isolation=CUBE SET…
asked 2021-03-23T13:23:56.467+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(211.20000000000002, 21%, 30%)' 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)
jehen joshi
21
Reputation points
commented 2021-03-26T05:54:53.937+00:00
jehen joshi
21
Reputation points
1 answer
Unable to receive emails from internet via TLS
We are unable to receive emails from external domains over TLS, they are accepted over non TLS channels. It does not appear the internet receive connector on our on-premises exchange server box is not offering the STARTTLS option. (I am trying to…
asked 2021-03-11T17:54:19.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(310.4, 38%, 40%)' 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
206
Reputation points
commented 2021-03-26T05:52:00.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(25.6, 67%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Joyce Shen - MSFT
16,691
Reputation points
4 answers
DP Used in a Task Sequence
I have a client that built a DP at his home lab, set it up with PKI, and it using it to test OSD Task Sequences. The Boundary and Boundary Group is set for his IP Address range and does not overlap any other boundary. The Boundary Group Site Server is…
asked 2021-03-08T14:09:53.13+00:00
Matt Dillon
397
Reputation points
commented 2021-03-26T05:51:12.66+00:00
Simon Ren-MSFT
38,751
Reputation points Microsoft Vendor
2 answers
Different profile on different devices [iOS]
Hello, I have 2 kind of devices in my organisation. iPad - Company owned. iPhone - Personally owned I want to create different configuration profile for those devices. Is there any way for Intune to distinguish those two kind of devices? Some…
asked 2021-03-10T12:12:49.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(147.20000000000002, 72%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Pawels
71
Reputation points
commented 2021-03-26T05:50:01.727+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, 30%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Crystal-MSFT
51,981
Reputation points Microsoft Vendor
3 answers
ADO.NET source export data very slowly
Hi I am using ADO.NET Source in Data Flow task. I have to transfer more than 1 million rows, cannot use OLEDB source because of encrypted data. I have set Default Buffer Max Rows - 40000 Default Buffer Size - 16777216 Still data…
asked 2021-03-18T14:37:18.267+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(22.400000000000002, 52%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Nicky
116
Reputation points
commented 2021-03-26T05:46:17.68+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, 37%, 38%)' 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)
Monalv-MSFT
5,906
Reputation points
2 answers
Delete a folder within a Mailboxbox Office365
I struggling to delete a specific folder with Office365 Exchange online Get-MailboxFolderStatistics mailbox in question | Select Name,FolderSize,ItemsinFolder This is the folder: Auto replies 8.721 GB (9,363,929,634 bytes) Tried PS…
asked 2021-03-13T10:15:56.663+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, 71%, 27%)' 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)
Alan
1
Reputation point
commented 2021-03-26T05:44:53.787+00:00
Joyce Shen - MSFT
16,691
Reputation points
2 answers
Office Web App
I am trying to send a digital signature and encryption from my OWA. There is not an icon for me to select those features. Is there a way I can enable this? I do not have office 365.
asked 2021-03-13T14:44:13.86+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, 51%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Smil-ey
1
Reputation point
commented 2021-03-26T05:44:22.783+00:00
Joyce Shen - MSFT
16,691
Reputation points
0 answers
What happens if I manually change "uidnumber" value in a user attribute in active directory?
I have a request from a Linux user to change the uidnumber in our active directory for his user. I don't know if this change will affect his user performance on our side (windows)as well or not!
![](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, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
0 answers
Migration siteweb ASP.NET from Windows Server 2008 to Windows Server 2016
A website built with ASP.NET on Visual Studio 2008 is running currently on Windows Server 2008. The project is to upgrade the server to Windows Server 2016. The problem is that the application pool stops running as soon as the web page is accessed.…
asked 2021-03-25T13:04:05.85+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, 5%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVC%3C/text%3E%3C/svg%3E)
VOISEMBERT Christian
1
Reputation point
commented 2021-03-26T05:32:13.347+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, 24%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Sam Wu-MSFT
7,541
Reputation points Microsoft Vendor
2 answers
sharing contacts and DL's with O365
We have migrated from Exchange 2013 and we were using the Public folders to share the contacts and DL's with members of the company. How would I accomplish now that we are using Office 365 / Exchange online?
asked 2021-03-16T18:50:01.83+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, 98%, 17%)' 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)
dirkdigs
921
Reputation points
commented 2021-03-26T05:31:36.637+00:00
Joyce Shen - MSFT
16,691
Reputation points
2 answers
MS Exchange Hybrid environment - System volume information
Hi, I have a MS Exchange Hybrid environment with Office 365 and all our Mailboxes are in Office365 and hybrid is being only used for management. On that server, I have a space of 1TB out of which 675 GB is filled by System Volume Information already…
asked 2021-03-21T05:27:42.613+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, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Abdullah Tahir khan
61
Reputation points
commented 2021-03-26T05:31:06.777+00:00
Joyce Shen - MSFT
16,691
Reputation points
1 answer
screen saver apply through GPO but its not working, we having windows 2012 r2
We have 2012 R2 DC's and deployed a GPO to start screen saver on windows 10 machines with below GPO settings. I can see GPO is applied on windows 10 machine via gpresult but its not starting the screensaver. Any idea whats going on.We applied GPO in …
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,816 questions
asked 2021-03-19T11:51:50.217+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, 43%, 17%)' 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)
sachin pawar
1
Reputation point
commented 2021-03-26T05:30:54.003+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' %3EFF%3C/text%3E%3C/svg%3E)
Fan Fan
15,361
Reputation points Microsoft Vendor
2 answers
Visual Studio How can I enable editing tabs?
I was modifying some options int Tools->Options and accidentally turned off all editing tabs. When I press the <tab> button, not space is inserted. I've tried to reset formatting and done other strange and wonderful things but, not tabs. How can…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,448 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
1,093 questions
asked 2021-03-25T16:45:56.35+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, 31%, 37%)' 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)
slipbits
16
Reputation points
answered 2021-03-26T05:28:42.917+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, 11%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDZ%3C/text%3E%3C/svg%3E)
Dylan Zhu-MSFT
6,421
Reputation points
0 answers
accessing id of a particular event using microsoft Graph Api
I want to delete a particular calendar event with graph API, is it possible that i can match the subject line of the event to the needed subject line and extract the id somehow?
asked 2021-03-25T04:47:39.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(156.8, 46%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
t
21
Reputation points
commented 2021-03-26T05:27:19.863+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, 9%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFM%3C/text%3E%3C/svg%3E)
Fiona Matu
91
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Dynamic database connection string
Hi, Can anyone help me how to Activate/Create Dynamic database connection string In azure Data Factory Regards, Eshwar
asked 2021-03-19T12:55:19.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(57.599999999999994, 40%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEN%3C/text%3E%3C/svg%3E)
Eshwar Nakkala
106
Reputation points
accepted 2021-03-26T05:25:32.913+00:00
Eshwar Nakkala
106
Reputation points
1 answer
Automatic upgrade Serice Fabric
When cluster is set on automatic upgrade mode The upgrade does not start even though there is a new version of the cluster. As it is said in documentation "You can set your cluster to receive automatic fabric upgrades as they are released by…
asked 2021-03-22T09:24:55.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(304, 97%, 39%)' 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)
Marszalko Pawel
1
Reputation point
commented 2021-03-26T05:19:04.193+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, 15%, 10%)' 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)
singhh-msft
2,431
Reputation points
1 answer
"@azure/communication-calling" npm package | new CallClient() geting error when we take the build in react.
In my ACS project when i take the build, code line -> this.callClient = new CallClient(options); getting an error which mentioned bellow. " ReferenceError: this hasn't been initialised - super() hasn't been called at e.exports…
asked 2021-03-24T18:22:22.037+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(188.79999999999998, 30%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
Freb
6
Reputation points
answered 2021-03-26T05:15:44.677+00:00
Grmacjon-MSFT
18,816
Reputation points
3 answers
ADFS 4 and SharePoint 2016 with non-claims-aware applications ISSUES
We have successfully deployed ADFS v4 + WAP (on-prem Windows server 2016) and we are publishing SharePoint 2016, Skype for Business and also using ADFS as an IDP to access a quite few cloud based applications with SAML. Now, in order to have…
asked 2021-03-01T00:38:20.11+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(265.6, 33%, 35%)' 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)
Mike Yabar
1
Reputation point
answered 2021-03-26T05:09:05.653+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, 44%, 19%)' 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)
Marcel Palme
1
Reputation point
2 answers
Configuration Profiles and Shared iPads
Is it possible to push a configuration profile to a shared iPad? My profile will push to a traditional or unshared iPad. However, it will not apply to a shared iPad. I can push application policies and software to the device though.
asked 2021-03-24T22:05:00.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(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
commented 2021-03-26T05:05:43.65+00:00
Lu Dai-MSFT
28,446
Reputation points
1 answer
Form Recognizer API Compatibility Error 1027
I am getting below error. I have trained my model in labelling tool - https://fott-preview.azurewebsites.net/ . with open(path_to_sample_content, "rb") as f: poller = form_recognizer_client.begin_recognize_custom_forms(model_id =…
asked 2021-03-20T08:13: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(220.8, 3%, 31%)' 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)
Rucha Sawarkar
1
Reputation point
commented 2021-03-26T04:57:41.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(22.400000000000002, 11%, 12%)' 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)
Ramr-msft
17,821
Reputation points