Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,652 questions
2 answers
Find different procedure amount on the same date
Hi, I have a table like below create table #mytable (vouno varchar(20), voudate date, procedure varchar(10), Amount decimal(18,3)) insert into #mytable values ('1001','01/01/2021','A', 100) insert into #mytable values ('1001','01/01/2021','B',…
asked 2021-02-04T11:31:15.88+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, 85%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
kasim mohamed
581
Reputation points
commented 2021-02-09T01:37:11.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(236.8, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EchoLiu-MSFT
14,581
Reputation points
2 answers
One of the answers was accepted by the question author.
Unable to add External user to Teams
I am unable to add an External user to Teams from within the Teams App. (see screenshot) When attempting to add the user via the Microsoft Teams Admin Portal, the search results with "We can't find any team members to add." I have…
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,289 questions
asked 2021-02-02T21:16:32.443+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, 88%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFH%3C/text%3E%3C/svg%3E)
Frank Hernandez
96
Reputation points
commented 2021-02-09T01:33:55.447+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(112.00000000000001, 24%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
JimmyYang-MSFT
53,761
Reputation points Microsoft Vendor
4 answers
Joins can be replaced by "," as shown below but i have mixed them , is it valid , pls send the document
-- the question is the second stmt has join and "," both is it valid , and if it is valid pls send the document where it is written for mixed mode. declare @t table(tid bigint,f decimal(13,4),tto decimal(13,4)) insert into @t…
asked 2021-02-05T08:41:48.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(291.2, 75%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERY%3C/text%3E%3C/svg%3E)
rajesh yadav
171
Reputation points
commented 2021-02-09T01:20:39.31+00:00
MelissaMa-MSFT
24,201
Reputation points
1 answer
SharePoint News publications - how do I get the STATS by Report for individual publications for Unique Views
Hello I'm looking to gather report data on all SharePoint News publications. In particular by publication the report needs to contain data on the following: Publication title Number of unique views by publication Number of views by publication …
asked 2021-02-01T10:26:13.71+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(67.2, 2%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELG%3C/text%3E%3C/svg%3E)
Lee Graham-Carlyle
1
Reputation point
commented 2021-02-09T00:58:19.863+00:00
Li Zhang_MSFT
1,566
Reputation points
2 answers
Is there a way to allow users search by list fields in SharePoint 2016?
Hello, Our case is that we have a custom list where the user wants to do search by any of its fields and get the filtered results so is there a way to achieve this using views (having dynamic filters) or is there any other way to achieve this…
asked 2021-02-02T12:05:29.523+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, 65%, 13%)' 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)
Marwa Mostafa
1
Reputation point
commented 2021-02-09T00:56:37.97+00:00
Li Zhang_MSFT
1,566
Reputation points
1 answer
Windows Insider"STOP GETTING INSIDER PREVIEW BUILDS WHEN NEXT VERSION OF WINDOWS RELEASES
Opted for Stop Getting Insider build when next version of windows releases after updated to Build 20226.rs_prerelease.200925-1415 but till date i am not able to get out of the Preview Releases
asked 2021-02-08T14:40:01.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, 38%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
VINAY MEHROTRA
1
Reputation point
commented 2021-02-09T00:19:32.947+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(51.2, 83%, 14%)' 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)
abbodi86
3,891
Reputation points
1 answer
SharePoint Syntex not tagging managed metadata terms from Synoyms
I am trying to use SharePoint Syntex to automatically add tags based on content. I have a managed metadata column that is mapped to a term set. Some of these terms have synonyms defined. When the extractor identifies the labels, that are exactly…
asked 2021-02-07T20:23:43.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(35.2, 55.00000000000001%, 13%)' 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)
vignesh subramanian
1
Reputation point
commented 2021-02-09T00:13:22.417+00:00
ChelseaWu-MSFT
6,326
Reputation points
1 answer
backup azure sql db
i have a database on azure which is more the 1 TB in size. i need to get a backup of this wihtout slowing down the clients. how can i do it?
asked 2021-02-03T11:38:55.207+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, 21%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETJ%3C/text%3E%3C/svg%3E)
Thanzeel Jalaldeen
1
Reputation point
answered 2021-02-09T00:07:59.617+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, 93%, 37%)' 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)
Navtej Singh Saini
4,226
Reputation points Microsoft Employee
2 answers
Why can't I schedule an exam?
When I click on schedule an exam, it says it is loading and taking me to the exam page to make a selection for the test, but it comes up as there was an error or something and then it tells me to contact support.
asked 2021-02-08T22:54:42.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(118.4, 72%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Bradley Gurien
1
Reputation point
commented 2021-02-08T23:15:43.203+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
14 answers
Need info on my exam of Microsoft
Hi Team, This link is not opening. I want to give a Microsoft exam and want to know on validity of my exam. Please reply FYI... Regards,Kapil Dhingra Forwarded message --------- From: Microsoft <Microsoft@e-mail.microsoft.com> Date: Wed,…
asked 2021-02-08T00:46:15.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(121.6, 92%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Kapil Dhingra
1
Reputation point
answered 2021-02-08T22:50:49.043+00:00
Anonymous
1 answer
One of the answers was accepted by the question author.
TSQL: Stored Procedures: Convert your block into two procedures. One that creates all of your data on your tables, and one that deletes all data in your tables
TSQL: Stored Procedures Convert your block into two procedures. One that creates all of your data on your tables, and one that deletes all data in your tables i need a help with it
![](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, 90%, 14%)' 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)
0 answers
Field which can lookup against multiple tables
I have a SQL Database with multiple tables of similar but distinct data (e.g.: Workstations, Virtual Servers, Physical Servers, Switches, ...) All these tables have Primary Keys defined the same in the CREATE TABLE statement: ID UNIQUEIDENTIFIER…
asked 2021-02-08T17:37:32.677+00:00
Gary Burch
1
Reputation point
commented 2021-02-08T22:40:35.083+00:00
Erland Sommarskog
112.7K
Reputation points MVP
0 answers
AzureAD Guests Invite
Hi, I'm using New-AzureADMSInvitation to invite guest to my Tenant Now, I have to new requirements: 1- I need to find programmatically in advance (before sending the invite) if the user domain is configured on my Tenant whitelist 2- I need to…
asked 2021-02-07T18:12:47.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(195.2, 28.000000000000004%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHC%3C/text%3E%3C/svg%3E)
Henrique Carvalho
1
Reputation point
commented 2021-02-08T22:33:48.973+00:00
James Hamil
25,006
Reputation points Microsoft Employee
0 answers
Will the upcoming elimination of Edge Legacy mean that it will be removed from Microsoft Word as well?
I read an article about how the time for Edge Legacy is coming to a close. I am on a team that is currently looking at developing an Add-in for Word and one of the things we have been struggling with has been getting modern web frameworks like Angular…
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,974 questions
asked 2021-02-08T22:18:41.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(153.6, 47%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Matthew Gaiser
1
Reputation point
asked 2021-02-08T22:18:41.817+00:00
Matthew Gaiser
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Error when trying to migrate from IOTCentral v2 to V3
I am getting a message that I need to migrate from v2 to v3 in Azure IoT Central. I click on the migrate button and then enter a new application name and get this error: We couldn't create your new app Something went wrong when we tried to create…
asked 2021-02-03T01:31:59.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(256, 14.000000000000002%, 34%)' 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)
Cameron Backus
41
Reputation points
commented 2021-02-08T22:07:31.563+00:00
Cameron Backus
41
Reputation points
5 answers
One of the answers was accepted by the question author.
Resource governor: How to write a classifier function?
Dear colleagues, Our management wants a start screen with tiles for certain tasks. Each tile must show a number. The user (or an application manager or super user) must have the option of writing a query that produces a number to be shown on the tile.…
asked 2021-02-04T16:26:02.723+00:00
Chris Sijtsma
106
Reputation points
commented 2021-02-08T22:04:22.423+00:00
Erland Sommarskog
112.7K
Reputation points MVP
5 answers
One of the answers was accepted by the question author.
How to check the new entries of a file that might contain a specific error
I have a log file and I am trying not to capture the same error in the log when the below script runs. The script is running every 5 minutes through task scheduler. (so, if there are new entries with the specific error an email should be sent, if 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(284.8, 73%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
1 answer
Unable To Set Blob Service Properties
0 I have an issue with azure storage blob is not returning 206 Partial content for video files. Problem: videos are fully downloaded(20-40s for 300mb videos) and the seek bar is not working. I am using Laravel and this problem occurs only when I…
asked 2021-02-05T15:19:34.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(96, 23%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Boyan Petrov
1
Reputation point
commented 2021-02-08T21:57:38.31+00:00
deherman-MSFT
37,411
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Windows Server 2019 CALs per user
HI i bought 300 users CALs (Windows server 2019 CALs) and i want to know how install them on the server and register them to microsoft portal.
asked 2021-02-08T16:42:27.073+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, 32%, 24%)' 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)
M.Boudiwane
21
Reputation points
commented 2021-02-08T21:05:08.447+00:00
Anonymous
0 answers
ADF triggers when stopped using azure cli powershell commands keeps on running the triggers even after the scheduled. time period
Hi, We have setup CI/CD pipelines in Azure for Azure Data Factory. But before the Deployment we need to stop the triggers in ADF. So we have used Azure Powershell task and used the command Start-AzDataFactoryV2Trigger This command starts the…
asked 2021-02-03T15:17:02.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(6.4, 67%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Subramani, Sree Susmitha
1
Reputation point
commented 2021-02-08T21:04:15.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(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