How to create sequence and insert data into database using sp

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

i have a table in c# code which has 3 column fist first row column data will insert in database and it will generate a id and based on that id 2nd row data will insert and based on generated id by 2nd column 3rd row data will insert into database

value can be repated

like

like 3 table i ihave
kra goal criteria

kra1 goal1 criteria1
kra1 goal1 criteria2
kra2 goal2 criteria3
kra2 goal3 criteria4
like this

kra goal and criteria can be repeated
one kra can contail multiple goal and one goal can contain multiple criteria

What I have tried:

i am unable to do in sp ,while trying in c# it failing in different sceneria and that is not right to do in c# also what i feel

Posted 23-Jul-16 19:57pm

Member 12650435

Updated 23-Jul-16 21:38pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2016-07-23T21:38:00

Don't.
Instead, organise it as three tables:
kra is one table: the ID is an IDENTITY field.
Goals is a second table: it too has an IDENTITY ID field, and a foreign key to the ID in the kra table.
Criteria is the third: again, and IDENTITY ID field, and a foreign key to the ID in the Goals table.
Then when you want to retrieve the data, you use JOINs to build up your SELECT.
That way, you don't duplicate information unnecessarily.
It's then trivial to do the INSERTs in your SP.