Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,692 questions
5 answers
One of the answers was accepted by the question author.
Select all duplicate records
How do I return all records that have the same last 6 digits or characters? For example: 000123456 009123456 123456789 100456789 201456789 987654321 112233445 I need to return: 000123456 009123456 123456789 100456789 201456789
asked 2020-10-14T15:51:30.563+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, 14.000000000000002%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jen
61
Reputation points
commented 2020-10-14T18:46:22.37+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, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
26,471
Reputation points
4 answers
One of the answers was accepted by the question author.
Websockets in C# for UWP ping pong
I use this Microsoft example to build UWP app for Windows IoT Core on C#. I use npm ws client for the browser and the same npm ws for Node.js server. The Server uses standard ping (opcode 0x9) and pong frames. How to get "ping" from the…
asked 2020-10-13T17:09:39.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(19.2, 78%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
Victor Denisenko
76
Reputation points
accepted 2020-10-14T18:03:38.397+00:00
Victor Denisenko
76
Reputation points
0 answers
forgot my password, no SSPR
I am learning Azure and was going through a Microsoft learn class on SSPR.....Ironically I think I changed my password without enabling SSPR and now I can't get back in. I am the only user on the subscription so I'm stuck...Whenever I go to try and reset…
asked 2020-10-12T19:40:29+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, 25%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJZ%3C/text%3E%3C/svg%3E)
Joel Zemanek
21
Reputation points
commented 2020-10-14T17:39:27.477+00:00
JamesTran-MSFT
36,821
Reputation points Microsoft Employee
1 answer
ComboBox's SelectedValue doesn't work without BindsTwoWayByDefault
I've 2 custom controls: 1) Combo and 2) ComboField. Combo is based on ComboBox and defined styles for ComboBox. ComboField is a composite control with a TextBlock in first column of a Grid and Combo on the second column. In the Generic.xaml, I've these…
asked 2020-10-13T01:04:21.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(6.4, 51%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEH%3C/text%3E%3C/svg%3E)
Emon Haque
3,176
Reputation points
commented 2020-10-14T17:36:04.163+00:00
Emon Haque
3,176
Reputation points
1 answer
Linker failure when building using Visual Studio 2019
My project is being moved from Visual Studio 2010 to Visual Studio 2019 and I am trying to evaluate and solve issues. When I build my project using VS2019 I get the following linker errors: libpost.lib(sucfile.obj) : error LNK2019: unresolved external…
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
asked 2020-10-09T14:16:32.687+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(246.4, 43%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Peter Mortimer
1
Reputation point
commented 2020-10-14T17:23:14.55+00:00
RLWA32
47,611
Reputation points
1 answer
One of the answers was accepted by the question author.
Is it possible to add custom parameters (User Inputs) to an ADF Template I've created?
I saved an ADF copy pipeline as a template. When a user selects the template, in addition to the linked services, I would like to prompt the user to enter two additional string parameter values that would be used to set values in the pipeline. Is that…
asked 2020-10-08T14:30:51.72+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, 33%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Brian Barnett
116
Reputation points
accepted 2020-10-14T17:12:48.137+00:00
Brian Barnett
116
Reputation points
1 answer
Automate Flow - billing restrictions message
Dear MS team, After 2 weeks of vacation, I see the message as following 'your flow was saved, but could not be enabled because of billing restrictions.' If I click Learn More, the link leads me to a page about Data loss prevention (DLP) policies.…
asked 2020-08-31T09:57:26.457+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, 35%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Choi, Baekyong
11
Reputation points
commented 2020-10-14T17:12:26.37+00:00
Joe C
1
Reputation point
2 answers
Permissions for /me/drive/recent
I want to get the recent files for a user and am trying to use the /me/drive/recent API. The docs suggest that Files.ReadWrite.All should be sufficient permission for this but I get a 403 error on that call with a token that only has…
asked 2020-10-10T08:22:39.54+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(291.2, 38%, 38%)' 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)
Nalin Singal
1
Reputation point
commented 2020-10-14T17:01:09.317+00:00
Jeremy Thake
6
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Azure Service Bus - Message storage for analytics
Hi, I'm planning to create an application that uses Azure Service Bus Topics to transport information among diverse microservices. I want to store a copy of the data that is distributed by ASB Topics so at some point I can either go back and check the…
asked 2020-10-13T04:45:57.887+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, 73%, 17%)' 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)
Dave Moore
96
Reputation points
accepted 2020-10-14T16:59:05.267+00:00
Dave Moore
96
Reputation points
1 answer
One of the answers was accepted by the question author.
Powershell convert json
Have a powershell script to pull alerts from graph api and converts it to a JSON file. The JSON file has to be flat (ConvertTo-Json -Compress) for use in a different system. The script works great when it only returns a single alert if multiple alerts…
asked 2020-10-12T21:24:40.49+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, 64%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Barry Cuda
26
Reputation points
accepted 2020-10-14T16:54:20.963+00:00
Barry Cuda
26
Reputation points
1 answer
One of the answers was accepted by the question author.
/Gh causing infinite loop
Topic: https://github.com/MicrosoftDocs/cpp-docs/issues/2278 mentioned that the _penter function must compile along, I countered another problem, I need to use functions from other libraries in _penter function, for example void myfunc(){ //…
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,880 questions
Visual Studio Debugging
Visual Studio Debugging
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Debugging: The act or process of detecting, locating, and correcting logical or syntactical errors in a program or malfunctions in hardware. In hardware contexts, the term troubleshoot is the term more frequently used, especially if the problem is major.
1,033 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(297.6, 2%, 38%)' 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)
2 answers
One of the answers was accepted by the question author.
System.Drawing.Image Image is not working when in run mode.
I am using ITeamExplorerNavigationItem2 to add a button in the Team Explorer. When I am using the property public System.Drawing.Image Image to control the button Icon. public System.Drawing.Image Image => null // Button comes up without any…
asked 2020-10-05T08:59:46.7+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(249.60000000000002, 23%, 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)
RAMSANKAR MANTRY
96
Reputation points
accepted 2020-10-14T16:10:43.26+00:00
RAMSANKAR MANTRY
96
Reputation points
0 answers
The MAC signature found in the HTTP request is not the same as any computed ...
I used azure-storate-blob == 12.5.0 azure-core == 1.8.2 I tried to access my blob storage account using connection string with Python v12 SDK and received the error above. The environment I'm running in is python venv in NixShell.
asked 2020-10-14T00:05:51.953+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(19.2, 89%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Mingzhao Liu
6
Reputation points
commented 2020-10-14T16:07:09.717+00:00
Mingzhao Liu
6
Reputation points
1 answer
One of the answers was accepted by the question author.
main function: argc is negative number
Hi fellow programmers; I am writing a cross platform linker using the Microsoft SDK but the argc argument is negative. I have written a batch script to build the test program which is called main_Test1.bat. The following is the batch script: cl.exe…
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,880 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(140.8, 36%, 23%)' 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)
1 answer
Management Points flip
We have a Primary Site Server(PS) and a segregated child domain/site serviced by a Site Server with the MP and DP roles. I can install the client without issue, but in the ClientLocation.log it shows the MP is set to the Site Server then it checks AD…
asked 2020-10-14T15:05:44.81+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, 91%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LostITSoul
21
Reputation points
answered 2020-10-14T16:04:26.493+00:00
Jason Sandys
31,406
Reputation points Microsoft Employee
0 answers
Delete Application Oauth Callback not triggered
I have approved one app & that app is listed into Enterprise applications | All applications. While deleting that app from my manage page, call back URL is not get any info(not triggered).
asked 2020-10-13T08:56:34.67+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, 0%, 28%)' 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)
muthuvel
31
Reputation points
commented 2020-10-14T15:38:13.617+00:00
Alfredo Revilla - Upwork Top Talent | IAM SWE SWA
27,496
Reputation points
3 answers
WSUS Offline - The latest Windows 10 update is not avilable
Hello I am performing a test of the WSUS Offline tool in a private network where there is no internet connection is available. I am using the very latest version of WSUS Offline version available form this location :…
asked 2020-08-05T17:17:34.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(304, 21%, 39%)' 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)
Jossy Vazhaparambil
1
Reputation point
answered 2020-10-14T15:35:24.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(64, 89%, 16%)' 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)
Robert Hardy
6
Reputation points
1 answer
Why i can't schedule an exam for certification DP-200
Hello, When i want schedule an exam for certification DP-200 . I have a blank Page "waiting for examregistration" Do you know why please ? Thanks, Best Regards
asked 2020-10-14T15:23:34.7+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, 55.00000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAE%3C/text%3E%3C/svg%3E)
Alexandre Eboyeye
1
Reputation point
answered 2020-10-14T15:34:30.817+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
2 answers
Remote Desktop web client is not installing the latest version
Hello, I'm trying to upgrade the Remote Desktop web client to the latest available version 1.0.22.0. However, the Install-RDWebClientPackage is pulling only the previous version 1.0.21.0. How to get the latest version installed? Best regards, …
asked 2020-10-05T11:40:42.773+00:00
Lukasz Chomin
1
Reputation point
commented 2020-10-14T15:25: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(204.8, 28.999999999999996%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
Dag Arne Kirkerod
1
Reputation point
0 answers
Invalid memory pointer read error causing window applicatin crash
Hi, I am analyzing a crash dump of my window application which runs for 3 days and then crashes with "INVALID_POINTER_READ" error. below are the register details: CONTEXT: (.ecxr) rax=0000000000000000 rbx=0000026591824f40…
asked 2020-10-13T04:49:10.413+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(249.60000000000002, 76%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKY%3C/text%3E%3C/svg%3E)
Kunal Yadav
1
Reputation point
commented 2020-10-14T15:17: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(294.40000000000003, 39%, 38%)' 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)
Andy ONeill
361
Reputation points