SQL Server – Query! doubt in SQLServer how to join columns with the same data types, in one

Hello! I start programming on vb.net and I have encountered a problem.

I realize a program in which I simulate three operations that generate income for me.

In the same database, I generated 3 tables (tabla1, tabla2, tabla3) and all 3 have the same columns: SERIE , OPERACION Y MONTO.
SERIES as idKey, Surgery It is a fixed datum that is different for each operation: OP1, OP2 and OP3 and the Amount What's one? decimal (10.2). Everyone has the same configuration

Now my question is, after trying the program and adding data. I expected that during the consultation in SQL (at the moment, I use the Visual Studio query generator), I run a sort of table with 3 columns with all the values ​​and at the end the sum of the amounts.

But instead, he throws me 9 columns, the 3 of each table.
and I do not know how to search this question directly on Google.

I hope you can help me, sorry if it's something simple, come learn! Thank you

magento2.3 – Magento 2: View data from a custom table in the grid

Battery Exchange Network

The Stack Exchange network includes 175 question-and-answer communities, including Stack Overflow, the largest and most reliable online community on which developers can learn, share knowledge and build their careers.

Visit Stack Exchange

node.js – Different data in Windows / Ubuntu

Hello, I create graphs with nodejs / mongo and chartjs, but the data returned are different if they are returned from localhost (windows) or vps (ubuntu).

has a date type entry in my html, gets its date directly and sends it to mongo via the new date (input string) on ​​a nodejs server in express, but rendering is different if the server is on localhost or vps, see:

Windows:
enter the description of the image here

Ubuntu:
enter the description of the image here

In both cases, the same date was spent using the same code. and out of curiosity, the correct data comes from Windows on localhost

Does anyone have any idea what this could be?

asp.net core – Backing up inherited data in C #

Guys, good night.

I'm studying C #, and one of the questions that's asked is this:

I have a course Student:

public class Aluno
{
    public String Nome { get; set; }
    public String Ra { get; set; }
    public Decimal NotaB1 { get; set; }
    public Decimal NotaB2 { get; set; }


    public Decimal getMedia()
    {
        return (NotaB1 + NotaB2) / 2;
    }

}

A class Technological student who inherits from Student:

 public class AlunoTecnologo : Aluno
{
    public Decimal NotaPim { get; set; }

    public Decimal getMedia()
    {
        return NotaPim * 0.2m + base.getMedia();
    }
}

I simulate the persistence of the data in a database, so I created the class Dao Student where I create a list to save students in memory:

public class AlunoDao
{
    private List alunos;

    public AlunoDao()
    {
        alunos = new List();
    }

    public void Adicionar(Aluno aluno)
    {
        alunos.Add(aluno);
    }

    public List Listar()
    {
        return new List(alunos);
    }
}

However when backing up a Technological student In this list, the average is calculated using the class method Student and no class Technological student where another note is inserted. Here is an example of what the code looked like:

static void Main(string() args)
    {
        Aluno vizu = new Aluno()
        {
            Nome = "Joao Vizu",
            Ra = "N300361",
            NotaB1 = 7.5M,
            NotaB2 = 10M
        };

        AlunoTecnologo lais = new AlunoTecnologo()
        {
            Nome = "Lais Silva",
            Ra = "545454",
            NotaB1 = 7.5M,
            NotaB2 = 10M,
            NotaPim = 9M
        };

        AlunoDao dao = new AlunoDao();

        dao.Adicionar(vizu);
        dao.Adicionar(lais);

        foreach (Aluno aluno in dao.Listar())
        {
            Console.WriteLine($"Nome: {aluno.Nome}tNotaB1: {aluno.NotaB1}tNotaB2: {aluno.NotaB2}tMedia: {aluno.getMedia()}");
        }

        Console.ReadKey();
    }

What should I do to be able to add to this list the correct data for each student, after the inheritance? Should I create a CAD course for StudentTechnologist?

2013 – Different IDs for Managed Service "Application Data Collection Service for Use and Integrity"

I am working on the sharepoint on site 2013. And I am trying to get the ID of "the application of data collection service of use and integrity" but I got different IDs: –

1] When I launch this powershell, I receive this ID: –

PS C:Usersspfarm.user> Get-SPServiceApplication -Name  WSS_UsageApplication

DisplayName          TypeName             Id
-----------          --------             --
WSS_UsageApplication Usage and Health ... 80ace510-005c-4786-86fc-bfd3848e2d79

Using this PowerShell, I had this ID

PS C:Usersspfarm.user> Get-SPServiceApplicationProxy

    DisplayName          TypeName             Id
    -----------          --------             --
    WSS_UsageApplication Usage and Health ... 21c44849-db6e-4be8-9d2e-84755dcc664a

So what credentials should I trust? or I have a problem inside our farm?
Thank you

Collection data is not visible in the mongo

Battery Exchange Network

The Stack Exchange network includes 175 question-and-answer communities, including Stack Overflow, the largest and most reliable online community on which developers can learn, share knowledge and build their careers.

Visit Stack Exchange

save data from 2 forms but in the same row of columns

I have two forms.
1 login and another password, I have to save the data of both in the base date, I can do it, but they are each in separate columns from the base date, and then I just came back 1 as in the code, what should I do to leave the data in the same column?

Website Design – How to Effectively Obtain Data from the Integration Process?

We currently have a very basic integration process when registering to the platform.
It is composed of 3 screens:

  1. Welcome to the platform
  2. Request to enter personal data (date of birth, sex, city in which they currently reside, country, place of birth)
  3. You are asked to write a brief description of yourself, to choose general skills from a drop-down menu as well as professional skills in another drop-down menu.

We can say that we are asking for somewhat sensitive data, but the reason is team reconciliation. We want to group users into teams based on their current residence and the combination of soft and soft skills. However, the process of integration does not seem motivating and rather aggressive.

Reading various integration methods, I mainly gathered information on the fact that there should be an introduction of the platform, then a kind of tutorial (quite simply). But I did not find anything on how to efficiently obtain user data in the integration process.

So, how can we make users more motivated to integrate and not jump? Is there a logical order on the questions to ask first and last? Make it gamified? Maybe also make tokens instead of drop-down menus?

google sheets – How to sort data by size, not by ABC order

I'm new to Google Sheets and use only a little Excel. Google Sheets is a little different. I want to rank the uniforms of our group in order of size, from the smallest to the largest, but Google Sheets only sorts them in alphabetical order, so that my XS ends at the end. I would like to sort them from the smallest (2XS) to the largest (4XL)
After reading the answers to other questions on this site and trying what was suggested, here's what I've had so far:
I've created an extra column (on the page that I want to sort) with the jacket sizes in the order I want and a second column with the numerical order that I want to have. they sort.
JACKET Sort order
2XS-Short 1
2XS-Regular 2
XS-Short 3
XS-Regular 4
SM-short 5
SM-Regular 6
SM-Tall 7
MD-Short 8
MD-Regular 9
MD-Tall 10
LG-Short 11
LG-Regular 12
LG-Tall 13
XL-Short 14
XL-Regular 15
XL-Tall 16
2XL-Short 17
2XL-Regular 18
2XL-Tall 19
3XL-Short 20
3XL-Regular 21
4XL-Regular 22
4XL-Tall 23
DM XS-Short 24
DM SM-Short 25
DM SM-Regular 26
DM MD-Regular 27

This is a formula I have created so far from previous examples: = sort (A2: G201, match (B2: G201, {"2XS-Short", "2XS-Reg", "XS- Short "," XS-Regular ")", "SM-Short", "SM-Regular", "SM-Large", "MD-Short", "MD-Regular", "MD-Large", "LG- Short "," LG-Regular "," LG-Regular "," LG-Tall "," XL-Short "," XL-Regular "," XL-Top "," 2XL-Short "," 2XL-Regular " , "2XL-Large", "3XL-Short", "3XL-Regular", "4XL-Regular", "4XL-Tall", "DM XS-Short", "DM SM-Short", "DM SM-Regular" "," DM SM-Regular "},
I do not know what comes next. Is it even going to work? If so, where should I type the formula for Google Sheets to know I want to sort them in that order? Help me! Thank you so much! -mactoomey

drop-down list – how can I dynamically add data in the contact form 7 drop-down list

Battery Exchange Network

The Stack Exchange network includes 175 question-and-answer communities, including Stack Overflow, the largest and most reliable online community on which developers can learn, share knowledge and build their careers.

Visit Stack Exchange