How to transpose this display. SeqNo Step Date By 1 Quoted 2018-03-01 Person1 2 Checked 2018-03-02 Person2 3 A
Ok, this one has me stumped. I'm hoping it's not something stupid/obvious... I'm trying to fix addresses in a client database. I have a function that takes a
I am doing POC on Snowflake and exploring this product. I have a question: in SQL Server, we have 400-500 stored procedures and these stored procedures are get
What SUM(IIF([CONDITION], 1, 0)) does is very simple. So simple, that what I really just want to write is COUNT([CONDITION]) (but that's invalid). Is there a sh
My goal is to create a stored procedure that generates new GUIDs using NEWSEQUENTIALID that can then be used when inserting data into a different table in the s
We have an Azure VM with SQL Server installed on it. We have our Visual Studio SQL Server database project in an Azure git repository. I've got the project to b
I have the following table [_teste_calendario_Table] and when "Monstrengo" has the same value, I'd like to make a pivot, adding new columns "De1", "Ate1", "Ven
After creating a new Azure SQL server using az sql server create, how can I enable the following options through PowerShell(Azure CLI)?
I have a table like this: I would like one address for each account number, if the account number has two addresses, I want to get the one wi
I have a table with hierarchical data: This is a sample of data with id, parent id, name, code (which is sometimes not filled), level and isroot column. In r
On a SQL 2016 Server I have a job that calls an SSIS package. That package is in a project in the SSISDB and has parameters. One of those parameters is a str
I'm working on my databases class final project, which consists of making an application that can access and do operations in a database. My t
I'm trying to get data using Sequelize in my Express app and I'm using SQL Server as database. Here is my code: Order.findAll({ attributes:[ [Sequ
I am working on a database that hold specific session data in separate tables for each session. e.g. I'd have a table called ProductsABCD, which holds products
I m trying to migrate my data base using EF core when i run this commande "dotnet ef migrations add Init --context PersistedGrantDbContext -o Migrations/Persis
I am generating an XML using SQL Server and I need the following name space: xmlns:ns0="http://www.w3.org/2001/XMLSchema-instance" ns0:noNamespaceSchemaLocation
I'm wondering if there is an easier way to reverse an Active Directory canonical name in SQL. I found a way to do this, but it only works with a set number of O
I am new to SQL and SQL Server and I am using SQL server 2012. but recently I encountered a weird thing while working with SQL server. I got that adding DISTINC
I'm running SQL Server 2016 Enterprise edition. I have a table with 24 columns and 10 indexes. Those indexes are vendor defined so I cannot change them. I have
I'm running SQL Server 2016 Enterprise edition. I have a table with 24 columns and 10 indexes. Those indexes are vendor defined so I cannot change them. I have