how to merge two query in parallel in sql server

Question

0.00/5 (No votes)

See more:

i want to merge two query data into one ,and the second query should be merge in parallel

SQL

SELECT  ccew.cce_weightages_Id,ccew.Weightages,Criteria_Type,ccecat.ExamCat_Name  from tbl_CceWeightage ccew inner join tbl_CceExamCategory  ccecat on ccecat.CceExamCat_Id=ccew.CceExamCat_Id

select cwc.Course_Id  from tbl_CceWeightagesCourse cwc  where cwc.cce_weightages_Id in(select we.cce_weightages_Id from tbl_CceWeightage we)

Course_Id column output merge with first query output.
plz help me .

Posted 8-Jan-14 21:17pm

manvendra patel

Updated 8-Jan-14 21:19pm

v4

Add a Solution

Comments

Aarti Meswania 9-Jan-14 3:43am

provide sample table data and required o/p

manvendra patel 9-Jan-14 3:56am

actually i am using two table

table 1-

CREATE TABLE [dbo].[tbl_CceWeightage](
[cce_weightages_Id] [int] IDENTITY(1,1) NOT NULL,
[Weightages] [int] NULL,
[CceExamCat_Id] [int] NULL,
[Criteria_Type] [nvarchar](50) NULL,
[Created_At] [datetime] NULL,
[Updated_At] [datetime] NULL,
CONSTRAINT [PK_tbl_CceWeightage] PRIMARY KEY CLUSTERED
(
[cce_weightages_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

output from first query is-
1 123 FA dsfgdsf
2 32 SA frwewrw
3 20 FA frwewrwwqer
4 12 FA minterm exam
5 13 FA minterm exam
6 20 SA minterm exam
7 25 SA minterm exam

and second table is -

CREATE TABLE [dbo].[tbl_CceWeightagesCourse](
[WeightagesCourse_Id] [int] IDENTITY(1,1) NOT NULL,
[cce_weightages_Id] [nvarchar](50) NULL,
[Course_Id] [nvarchar](50) NULL,
[Created_At] [datetime] NULL,
[Updated_At] [datetime] NULL,
CONSTRAINT [PK_tbl_CceWeightagesCourse] PRIMARY KEY CLUSTERED
(
[WeightagesCourse_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

and output of second query is

3
3
3
3
2
2
2

i want to merge second query output with first query output as a column not row.

2 solutions

Solution 2

I suggest reading my first SQL article here[^], which explains what joins are.

Posted 9-Jan-14 12:48pm

Christian Graus

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)

Maciej Los · Accepted Answer · 2014-01-08T22:06:00

If you want to join data, please see this:

SQL

SELECT  ccew.cce_weightages_Id,ccew.Weightages,Criteria_Type,ccecat.ExamCat_Name, cwc.Course_Id
FROM tbl_CceWeightage ccew
    INNER JOIN tbl_CceExamCategory  ccecat ON ccecat.CceExamCat_Id=ccew.CceExamCat_Id
    INNER JOIN tbl_CceWeightage cwc ON cwc.cce_weightages_Id = ccew.cce_weightages_Id

[EDIT]

SQL

SELECT  ccew.cce_weightages_Id,ccew.Weightages,Criteria_Type,ccecat.ExamCat_Name
FROM tbl_CceWeightage ccew
    INNER JOIN tbl_CceExamCategory  ccecat ON ccecat.CceExamCat_Id=ccew.CceExamCat_Id
WHERE ccew.cce_weightages_Id NOT IN (SELECT cce_weightages_Id FROM tbl_CceWeightage)

[/EDIT]