I have a query like this return await _ctx.Activities .Include(a => a.Attributes) .Include(a => a.Roles) .Include(a =
I'm trying to perform a PIVOT but getting an error. I'm trying to see which patients have more than one Interval session. The column is a text type. I attempted
I am trying to learn how to use transactions and error handling. Got stuck with custom error messages. The stored procedure generates badges for AdventureWorks
I'm studying of Azure Synapse. In dedicated SQL pool database, 'actual execution plan' of SSMS was disabled. In serverless pool database, SSMS says 'set statist
I am trying to run a query to return all rows that are not null. But, I am not able to get that done. How is this possible? Please assist.
I have this sample table +--------+-------------+ | DBName | Description | +--------+-------------+ | A | Car | | A | Boat | | B
I am making merge upserts to my data warehouse. I don't need to keep the history on this particular object, so I'm using a type i slowly changing dimension. I'm
While connecting to SQL Server database by attaching to an MDF file, the following error is returned: The database cannot be opened because it
I have these two SQL tables: Bills (BillId, Folio, Date, ProductId) BillsRows (BillRowId, BillId, ProductId, Lot, Quantity, Price) ProductId is optional in Bil
I have a SQL script with a function (function drops at the end of the script) and temporary table definitions and variables to process the data that gives me on
I want to establish a MSSQL Connection from Ubunutu 18.04. It was quite hard to get this set up, but know it works so far that I can use sql_srv class or pdo cl
I am running into an issue where my .net application (C#) will not connect to SQL Server when ran by a domain user. Exception is: The underlying provider faile
I have a query with a few columns. I need to find the avg of a particular column and then use the average value to calculate other values. I am finding avg with
I have the following connection string in ASP.NET Core, but I get the following error: Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open dat
I need to migrate .SQB files to Snowflake. I have a data relay where MSSQL Server database files are saved in .SQB format (Redgate) and available via sSTP with
I am defining a new WITH statement as newStaff, and then I am taking that data and filling it into other tables. It doesn't seem to let me ref
I need to get a comma separated list with quotes and I'm almost at that point but I get a list with commas but a leading space at the start bu
I already uploaded PDF files into my SQL Server database as binary data file. I want to retrieve this file and open it with Adobe Reader on my form. Please hel
I am just starting to look at Apache Superset and wondered if anyone knows or has been able to hook SQL Server Analysis Services up as a datasource? I want to p
I am doing an outer join between two market data tables. The two tables have trading volume reported differently, therefor I need to query them separately and t