Starting here https://
Download dotnet core 3
https://
dotnet core samples page https://
1 min read
Starting here https://
Download dotnet core 3
https://
dotnet core samples page https://
1 min read
private async Task CallServiceAsync()
{
string schedulerServiceName = "fabric:/DataServices/Scheduler";
var resolver = ServicePartitionResolver.GetDefault();
var partition = await resolver.ResolveAsync(new Uri(schedulerServiceName), ServicePartitionKey.Singleton, CancellationToken.None);
var endpoints = JObject.Parse(partition.GetEndpoint().Address)["Endpoints"];
var endpoint = endpoints[""].ToString().TrimEnd('/');
string method = "/api/scheduler/classes/sync";
var client = new HttpClient();
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
var getTask = client.GetAsync(endpoint + method);
var msg = await getTask;
}
Probably what I should read next
Was a great help this morning gettig this stuff into github
1 min read
private async Task CallServiceAsync()
{
string schedulerServiceName = "fabric:/DataServices/Scheduler";
var resolver = ServicePartitionResolver.GetDefault();
var partition = await resolver.ResolveAsync(new Uri(schedulerServiceName), ServicePartitionKey.Singleton, CancellationToken.None);
var endpoints = JObject.Parse(partition.GetEndpoint().Address)["Endpoints"];
var endpoint = endpoints[""].ToString().TrimEnd('/');
string method = "/api/scheduler/classes/sync";
var client = new HttpClient();
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
var getTask = client.GetAsync(endpoint + method);
var msg = await getTask;
}
1 min read
{ "type": "node", "request": "launch", "name": "Jest All", "program": "${workspaceFolder}/node_modules/.bin/jest", "args": ["--runInBand"], "console": "integratedTerminal", "internalConsoleOptions": "neverOpen", "windows": { "program": "${workspaceFolder}/node_modules/jest/bin/jest", } }
1 min read
Find your duplicates
SELECT [col1], [col2], COUNT(*)
FROM [db].[mstar].[table1]
GROUP BY [col1], [col2]
HAVING COUNT(*) > 1
THEN
begin transaction
SET NOCOUNT ON
SET ROWCOUNT 1
while 1 = 1
BEGIN
DELETE
FROM [mstar].[InvalidFundShareClassAttribute]
WHERE [FundShareClassId]+ [CustomState] IN
(SELECT [FundShareClassId]+ [CustomState]
FROM [mstar].[InvalidFundShareClassAttribute]
GROUP BY [FundShareClassId]+ [CustomState]
HAVING COUNT(*) > 1)
IF @@Rowcount = 0
BREAK ;
end;
SET ROWCOUNT 0
rollback;
or commit;
;WITH CTE AS ( SELECT EmpName, ROW_NUMBER() OVER ( PARTITION BY EmpName ORDER BY EmpID ) RowNumber FROM dbo.Employee ) SELECT *FROM CTE WHERE RowNumber > 1
Then
;WITH CTE AS ( SELECT EmpName, ROW_NUMBER() OVER ( PARTITION BY EmpName ORDER BY EmpID ) RowNumber FROM dbo.Employee ) DELETE FROM CTE WHERE RowNumber > 1
1 min read
Find your duplicates
SELECT [col1], [col2], COUNT(*)
FROM [db].[mstar].[table1]
GROUP BY [col1], [col2]
HAVING COUNT(*) > 1
THEN
begin transaction
SET NOCOUNT ON
SET ROWCOUNT 1
while 1 = 1
BEGIN
DELETE
FROM [mstar].[InvalidFundShareClassAttribute]
WHERE [FundShareClassId]+ [CustomState] IN
(SELECT [FundShareClassId]+ [CustomState]
FROM [mstar].[InvalidFundShareClassAttribute]
GROUP BY [FundShareClassId]+ [CustomState]
HAVING COUNT(*) > 1)
IF @@Rowcount = 0
BREAK ;
end;
SET ROWCOUNT 0
rollback;
or commit;
;WITH CTE AS ( SELECT EmpName, ROW_NUMBER() OVER ( PARTITION BY EmpName ORDER BY EmpID ) RowNumber FROM dbo.Employee ) SELECT *FROM CTE WHERE RowNumber > 1
Then
;WITH CTE AS ( SELECT EmpName, ROW_NUMBER() OVER ( PARTITION BY EmpName ORDER BY EmpID ) RowNumber FROM dbo.Employee ) DELETE FROM CTE WHERE RowNumber > 1