Probably its a quite simple problem to solve

Probably its a quite simple problem to solve - but im not

Assignment Help Database Management System

Reference no: EM13466795

I really would appreciate your help.

Probably it's a quite simple problem to solve - but I'm not the one .. ;-)

I have two tables in SQL Server:

article

prices

Now I want to select a certain set of ids and insert some entries into the prices-table with those ID.

e.g. (wrong and not working SQL)

INSERT INTO prices group, id, price

VALUES (7, (select articleId from article WHERE name LIKE 'ABC%'), 1.50); SQL Error -> subquery has more than 1 value

Reference no: EM13466795

Questions Cloud

Contract amp procurement question good thoughts on ptn : contract amp procurement question good thoughts on ptn. however post tender negotiation sometimes gets to bid-shopping

Determine whether there are electronic privacy laws that : research websites and other technologies that provide private information on u.s. citizens.3-4 page paper list and

Art and bill were leaving work one afternoon when they were : art and bill were leaving work one afternoon when they were approached by charlie who was wearing a mask and carrying a

Provide real-world criminal justice examples to illustrate : write a 1050- to 1750-word paper in which you describe the followingthe process of verbal and nonverbal communication

Probably its a quite simple problem to solve - but im not : i really would appreciate your help.probably its a quite simple problem to solve - but im not the one .. -i have two

Prepare a 1050-to 1400-word report in which you determine : prepare a 1050-to 1400-word report in which you determine supplier alliance requirements and appropriate metrics for

Compare and contrast some of the options or technologies : compare and contrast some of the options or technologies available to secure a wi-fi network. what are the benefits of

You have been hired by a big company with branch offices : you have been hired by a large company with branch offices around the country to assist with rollout of a new

Perform the internet search of new product development : do an internet search of the new product development process of any product of your choice and analyze the process for

User Account

All Pages

Probably its a quite simple problem to solve - but im not

Reference no: EM13466795

Reference no: EM13466795

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT