Sql server (insert one row for each nested result)

I got 3 different tables on sql server (attrib,att_art, art). 'attrib' has a list of attributes, 'art' has a list of items and att_art should join both, like this:

ATTRIB
att1
att2
att3
...

ART
ar1
ar2
ar3
...

Both tables have an unique id that joins on att_art on id_att and id_ar

This is what I need to do:

For each item on art and for each attrib at the same time, I need to insert a new row on att_art. Like this:

att1   ar1
att2   ar1
att3   ar1
att4   ar2
att5   ar2
att6   ar2
....

How could I do this? i'm kinda new on sql and it's been overwhelming!

Use Cross apply.............

Select * from ATTRIB a
cross apply (select * from ART) b

How to insert a row for each unique value found in column

How could I, in SQL Server 2008, write a SQL statement that would insert one row for each distinct value it finds in one column in the same table? Edit: The table I want to add rows to the same table I'm checking. I have normalized table with a colum

Create the plpgsql function that inserts a row for each element into an array in the array

I need to create a plpgsql function that inserts one row for each item in an array into table. For example: the_array = [1,2,3] The result after inserting the_array into temp_table: col ---- 1 2 3 I found the following code from the this link: http:/

Join two tables, returning one row for each single row in the first table

So, I'm trying to pull data from two tables. I need each unique row in the first table Tickets to be a unique row in the result set. Each ticket might have multiple ticket tags associated with it in the TicketsTags table. When I run the following que

SQL Server - Triggers & amp; Cursors - For each inserted row, update an associated value on another table

For a homework assignment, I'm trying to build a trigger that allows for multiple inserts/updates/deletes by utilizing a cursor. We have to use a cursor in order to practice the syntax. We know that there are very few practical scenarios for cursors

SQL Server tabulating survey data for each month

I have a survey table with many columns but i am focusing on these 2, survey_date and over_rating. i am not sure if it is possible to be done in a single query. I am using sql server 2012. This is my sample data. select survey_date, overall_rating fr

SQL Server inserts new rows only based on multiple columns

I searched in SO but couldn't find anything for my purpose. I need to insert unique rows ONLY from one table into another. I have: table1 id name bookid bookname start_date end_date rel_date rel_id 1 horror 1221 rockys 04/01/2016 04/30/2016 05/01/201

Returns all distinct values in column B in one row for each distinct value in column A

Take the following table: CREATE TABLE boxes ( box integer, color character varying, size integer, ... ); where both box and color can assume not unique values out of a small set. Querying this table with: SELECT color, box FROM boxes; the result wil

sql server insert copy rows multiple tables a field change

I'm not sure of the best way to ask this, so it will be through example. I have a good size database that contains about 800 tables each containing a key piece of information for all data - For the example we'll call it Department. This is part of th

SQL JOIN - returns a row for each array A, regardless of whether or not Table B has values

The below query that should return a row for every Reading_Type, plus either the saved Reading value for that Reading_Type and date, or 0 if no Reading has been saved. SELECT t.* , ISNULL(r.Reading, 0) AS Reading FROM Reading_Type t LEFT JOIN Reading

Unstack a dataframe in R that has only one row for each category

If I have the following data frame called pets in R: > pets name animal 1 Amy dog 2 Bob cat 3 Carol dog 4 Danny cat 5 Eustace horse 6 Frances horse I can unstack the data frame to set the animal categories as columns headers like so: > unstack(pets,

SQL Server: Run the function for each row based on the provided row value

I am still learning SQL and I was wandering how can I pass a row value into a function in a cross apply query. Assuming that this is my first table SELECT [Project], [emp_id], [Allocation_start], [Allocation_end] FROM First_table I have a function th

explode a SQL table and insert a row for each day that there is none

I have a table like so which I generated from modestly reworking this data + SQL to display by day, but I want to add in empty days as well with a running tally on the right hand side. ╔════════════╦════════╦═════════╦════════╗ ║ day ║ num1 ║ num2 ║

SQL Query - Insert multiple rows with each row having an incremental date (+7) other identical values

I need to create an INSERT query so that all columns except 1 are the same but the one column that isn't is a date that increments by a week up to a selected date. E.g.: Row UserID Date Out In Reason Details ------------------------------------------

Write the SQL query to send rows for each dataset

I have the following table for student's fee payments [fee_id] INT [user_id] INT [payment] DECIMAL (18, 2) [date] DATETIME [fee_remaining] DECIMAL (18, 2) [year] INT [payment_method] NVARCHAR (50) [fee_required] DECIMAL (18, 2) This is my current que

Related Articles