How to add data in a table whch will be added to other columns as well

Question

1.00/5 (1 vote)

See more:

I want to add some leves in my table ... but that table has got different company as well .. i want to add only once and that will be get added to all companies .. how can i do that in sql

Posted 18-Jul-13 0:32am

Torakami

Add a Solution

Comments

Maciej Los 18-Jul-13 6:38am

I don't get you... ;(
Please, be more specific and provride more details including example data and expected output.

Torakami 18-Jul-13 6:50am

I have column companyId compnayNames Leaves
all has got some leavenames.. say Annual,study n all .. now what if I just want to add new leaves but that will be applicable for all companies .. that means all companies will have new leaves .

ArunRajendra 18-Jul-13 6:59am

Is it all in a single table or two different tables?

Torakami 18-Jul-13 7:00am

Its in single table.. I wanted to add new leaves and avalaible companies will also get updated with that new leave that means .. all comanies will have new leaves

Torakami 18-Jul-13 7:28am

This is my Table details

CompanyId AbsenceTypeName AbsenceTypeId colorcode TotalLeaves DataForYear
41 Casual Leave 124 #800000 NULL NULL
41 Paid Leaves 125 #A52A2A NULL NULL
41 Annual Leave 126 #800080 200 2013

Torakami 18-Jul-13 7:12am

Can you show me how to import into sql table from excel sheet .. i was thinking to add it in excel sheet first and then i will directly upload it into table .. that will be much easier i guess

Maciej Los 19-Jul-13 14:45pm

No, it wouldn't be easier ;(
Direct way is better way ;)

2 solutions

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)

ArunRajendra · Answer 1 · 2013-07-18T01:44:00

Solution 2

Try this solution. Replace @t with your table name and also inclue other fields which you need to add to the records.

SQL

insert into @t (CompanyId,AbsenceTypeName)
select distinct CompanyId,'New Leave' from @t

Posted 18-Jul-13 1:44am

ArunRajendra

Maciej Los · Answer 2 · 2013-07-19T08:55:00

Have a look at example:

SQL

DECLARE @tmp TABLE (CompanyId INT, AbsenceTypeName VARCHAR(30), AbsenceTypeId INT, colorcode VARCHAR(30) NULL, TotalLeaves INT NULL, DataForYear INT NULL)

INSERT INTO @tmp (CompanyId, AbsenceTypeName, AbsenceTypeId, colorcode, TotalLeaves, DataForYear)
SELECT 41, 'Casual Leave', 124, '#800000', NULL, NULL
UNION ALL SELECT 41, 'Paid Leaves', 125, '#A52A2A', NULL, NULL
UNION ALL SELECT 41, 'Annual Leave', 126, '#800080', 200, 2013

SELECT *
FROM @tmp

INSERT INTO @tmp (CompanyId, AbsenceTypeName, AbsenceTypeId, colorcode, TotalLeaves, DataForYear)
SELECT CompanyID, 'New Leave', (SELECT MAX(AbsenceTypeID) +1 FROM @tmp), NULL, NULL, NULL
FROM @tmp

SELECT *
FROM @tmp