I have set of data and wants to split multiple rows based on the column value. For Example, Source Data: Expected Output: Thanks, Lawrance A
Let's say I have an object like this: public class ObjectA { public int Id {get;set;} public DateTime CreatedOn {get;set;} ...etc } I want to partitio
EDIT: I have edited my original post to add some clarity. 1) Is it possible to write a query that will return database, schema, table, column, and column type
SELECT DISTINCT {c2.name} FROM {BrandCategory AS c JOIN CategoryProductRelation AS c2p ON {c.pk} = {c2p.source} JOIN Product AS p
I want to force a user's string input in a stored procedure to uppercase. I tried writing UPPER prior to the @parameterName but I got a syntax error. Is this
I want to force a user's string input in a stored procedure to uppercase. I tried writing UPPER prior to the @parameterName but I got a syntax error. Is this
We have a .Net Core 3.1 application which is using EF Core to connect wit the SQL Server database. We are facing one problem, that when an exception occurs in o
We have a .Net Core 3.1 application which is using EF Core to connect wit the SQL Server database. We are facing one problem, that when an exception occurs in o
Test platform Used - HackerRank | MySQL/MSSQL Recently attempted an code assessment for a job post involving SQL questions. I was able to get the correct output
I'm trying to work on the statistics, and as a part of it, I'm trying to look at the execution plan of certain SELECT * commands with a WHERE condition on a par
I'm working with Postgres from SSIS thru ODBC Unicode driver ver 13.01. 32-bit connection. I can successfully connect to all Postgres tables but can not able t
Can I use SqlConnection in Xamarin.Forms? I tend to use this in Windows and Web applications developed in Visual Studio, but I don't know how it would work in
I am attempting to display a table from my Azure SQL database on a webpage. I have been looking around and can't seem to figure out why this isn't working This
Here's an example of a connection configuration that has stopped working (it's for connecting to an Azure managed database): { "server": "sqldb.12345abcde.dat
I have a CRM software on my local machine. In the SQL DB of the software, I added a linked server (our test website with our test DB: Windows Small Business Ser
I have a data that combines inventory, sales forecast, and future supply data for different parts. I have combined it to give me a table that gives a net quanti
I am trying to connect to an Azure database using SQLAlchemy in Python. My code is the following: engine_azure = \ create_engine('mssql+pyodbc://{Server admin
I am trying to create a report table in SSRS 2016 but I am not sure how to go about it or if it is possible. I am trying to recreate something similar to that
I use lookup tables commonly and sometimes I have some default record in the Lookup table and I think for this record I can use 0 as Primary Key a as shown belo
I'm trying to create a query with a variable number of parameters, giving to the program the name of the table and an Array for the names of parameters and anot