I have two tables: Job(ID,Name, etc.) and Address(ID, Job_ID, Name etc). I want to get result like this: [ { "Job_ID": 1, "JobName": "Test", "Addresses": [ { "ID": 1, "Name": "King street" }, { "ID": 2, "Name": "Queen`s street } ] } ] My current query that gets only one address for a job looks… Read More How can I put SELECT result set to SELECT column?
I need to add a foreign key column in an existing table using alter statement. And need to set default value to insert default in case of null. For that I added below alter query: ALTER TABLE COM.USER_GENERATED_TASK_LIST ADD Application_ID INTEGER NOT NULL CONSTRAINT DK_Application_ID DEFAULT (5) WITH VALUES, CONSTRAINT FK_Application_ID FOREIGN KEY (Application_ID) REFERENCES… Read More Add foreign column with default value
In a SQL Server query, I’m trying to figure out how to combine two rows of data into one row for specific records. The following is an example of table data. Below it is how I would like the data to be displayed. I want to display all available columns for each employee but on… Read More SQL Server display 2 rows of data as 1 row
I am getting error in microsoft sql server because the data I want to update is contains (‘) symbol in the data. update Employee_table set brokername=’Angie’s Broker’, where ID=7788; Please someome resolve the problem. >Solution : For single quotes used inside a string literal, you put another single quote before it. This is called "escaping"… Read More How to update a table column data, containing ( ' ) symble in data
I have a table that has a bunch of different servers most of them are listed as servername.ad.edu. I want to remove everything after the first dot. so it just shows as servername in my table. The code I was provided for the population of the table was not written by me but I did… Read More Removing parts of a server name using SQL
declare @a Int, set @a=(SELECT TOP 1 UserTableID + 1 AS FisNo FROM ET_MalzemeveHareketleri order by UserTableID desc) select @a this is the code I have a table id of 4000 thousand I want to put the last number in @a variable >Solution : Do something like this declare @a Int; select @a = colname… Read More I have a table id of 4000 thousand I want to put the last number in @a variable
declare @a Int, set @a=(SELECT TOP 1 UserTableID + 1 AS FisNo FROM ET_MalzemeveHareketleri order by UserTableID desc) select @a this is the code I have a table id of 4000 thousand I want to put the last number in @a variable >Solution : Do something like this declare @a Int; select @a = colname… Read More I have a table id of 4000 thousand I want to put the last number in @a variable
I created a stored proc in a database called DBA_Test. I went to another server and tried to execute the SP using EXEC LinkedServerName.DBA_Test.dbo.spLoad_Clients_Monthly_Filings. When I try to Execute the query I get the following error: Server ‘LinkedServerName‘ is not configured for RPC. When the line is in the query window of SSMS, the DBA_Test… Read More Trying to EXEC a Stored Proc on another server
I have a table here in which I want to write a SELECT query in SQL Server that allows me to get the following: For each unique combination of SalesPerson x Country, get only the rows with the latest Upload_DateTime However, I am trying to do a group-by and inner join, but to no avail.… Read More Group By and Inner Join Together To Get Unique Values By Maximum Date
I’ve got this table and I wish to add a column that gives the total number of rows in the table: Table now: Name PAT_ID ——————— Brian 123 Brian 356 Brian 3546 Brian 987 Desired output: Name PAT_ID TOTAL ———————————— Brian 123 4 Brian 356 4 Brian 3546 4 Brian 987 4 Thank you! >Solution… Read More How to add a column that shows the total number of rows in a table in SQL Server