Write a SELECT statement that returns the LastName, FirstName, and AnnualSalary columns of each instructor that has a unique annual salary. In other words, don
I have a master table and a detail table. Question 1: I would like my view to look like this master1 row, nulls master1 row, detail1 row for master1 master1 row
I have some query in which I am substituting 2 dates in a field "between". SELECT ... FROM ... WHERE o.EventDate between @startDate and @endDate How to make it
I have a table (Table 1) which is a list of employees and data points about them. The data that populated Table 1 is regularly changed and added to in its sourc
Currently, this is the only way I know Create @tempTable1 Insert into @tempTable1 Exec mySP1 input1, input2 Create @tempTable2 Insert into @tempTable2
I have a complex subquery within a query giving me this: Col 1 Col 2 value1 NULL NULL value2 value3 NULL NULL value4 value5 value5 But instead, I need this ou
I'm trying to select multiple values from 3 subqueries and combine them together. But I get the error "Only one expression can be specified in the select list w
Recently, I read an article with the below link and would like to know this property in my SQL server but the result is a kind of weird in my server. http://web
I am trying to export SQL table as multi-character delimited text file in python. I have tried using Pandas, but it is only supporting single character as delim
Currently, the sql code that I have is to check for the three fee_code records do any of them have election_code = NA. I'm trying to figure out how to change th
I am trying to get the resultList to my jsp using tag. public class DBUtil { public String getData()throws SQLException, ClassNotFoundException{
I get this error: System.Data.SqlClient.SqlException: 'Must declare the scalar variable "@refSlips".' Code: SqlConnection con = new SqlConnection(connectionSt
Please help me I tried to connect to the database The connection was successful and the rules were lifted, but I have this problem raise NotImplementedError("t
We have started a new project in .NET Core. We are just starting out and we are hitting a Web API endpoint to get some reference data of 8 records. We noticed
I´m trying to modify attributes using sql database and web api .Net 6 In a controller i have this method private void SetRefreshToken(RefreshToken newRefr
I have the below data in my sql server table Name Value ValueHash country aaa zzz lastname ccc yyy email [email protected] xxx firstName bbb www And I want the below Js
I'm trying to implement log shipping using Backup-sqldatabase command, but SqlCredential is a required parameter for Azure Storage uploads according to the docs
I am trying to insert data into a mssql database. I needed as fast method for this so I set the fast_executemany param to true. The upload works fine for most p
I pull data down from an Azure based SQL Server every now and then using the SQL Server Import and Export Wizard (which I already know isn't the best way to go
I have an API using ASP.NET Core 6 & EF6 and I reverse engineered my database (SQL Server) using the EF Core Powers Tool extension. When I try to insert a P