home
I'm trying the sample below to connect to a remote SQL server from Python in Docker....
Say I used a query below: select * from GenericTable order by ID, DATE and received the...
For the purposes of developing and deploying SSIS (SQL Server Integration Services) packages, does...
How can select first value of a column order by another column when I'm in a group by ? My...
I am somewhat new to MS SQL but I have been able to figure out how to get a Foreign key to return...
I'd like to union two tables with different columns: Table 1: ...
I already have an existing question, but i still cannot solve my problem even though the answers...
I have attempted to build an SQL script in MS SQL Server T-SQL to split a Sales Invoice Revenue...
I am receiving the exception bellow when trying to drop a temporary database created by one of our...
I have downloaded SQL Server 2016 from this link...
SELECT * FROM dbo.TABLE LEFT JOIN table_insp insp ON TABLE.FORM_NO =...
First of all sorry for the confusing code sample, simplifying my problem is proving tricky. select...
I have a records like below : Name Count 123456M2.txt NULL 123456M2.txt ...
This question already has an answer here: How do I retrieve decimals...
I have a merge query similar to the one below: MERGE [Unshipped] u USING [Order] or ON or.ID =...
I've been researching why AspNet.Users.Id uses nvarchar(450) and reached the following...
According to http://jtds.sourceforge.net/ "jTDS is an open source 100% pure Java (type 4) JDBC 3.0...
I am trying to create the query to display the tickets month wise I attached the query the result...
I am attempting to find the revenue per distinct user in this query but seem to be running in this...
Setup: dotnet core 2.1 aspnet host, so we mostly IServiceCollection stuff up docker, linux image...
I work at a company that sells many versions of a product to several different resellers, and each...
Select max marks from math subject and select min marks from physics subject. I can only think of...
I've got a column that shows the date as a decimal such as 101118 for 10-11-18 and 90118 for...
:) I have this defined type: CREATE TYPE dbo.MyType AS TABLE ( name varchar(255), value...
I have a AS Database (SQL Server 2005). I need to restore the database in a SQL Server 2014. When...
I have a large table that has 8 row numbers with an associated loss and carrier. I am trying to...
I am trying to clean public company names by removing certain character patterns from the end of...
I'm looking for an API that allows client programs to access on MS SQL Server 2017 in native way. I...
This question already has an answer here: Efficiently convert rows to...
How to write the distinct Union query with ignore one column in all the tables. I would like to...