DECLARE @ActiveID int,@SourceID int

SELECT @ActiveID = 4,@SourceID = 1


SELECT *
FROM table
WHERE Source_ID = @SourceID
AND ACTIVE_ID = @ActiveID

quote:

---

Originally posted by adit

Thanks for responding.

My query is below:
select a.e_id,b.l_name,c.new_id
from a
inner join b on a.s_id=b.s_id
inner join c on b.l_id=c.l_id and b.r_id=c.r_id and b.source_id=c.source_id
where c.source_id = <yourvalue>
and c.active_id = <activeidvalue>
Here c corresponds to the table posted. Also there is one other table 'd' which contains the field - 'active_id' from where in data flows to 'active_id' column of table c.

Thanks.

---

quote:

---

Originally posted by adit

Hi,
Can you please suggest a way I can do it by query instead of stored procedure with cursors, because the data is very huge and I have to map it the way as described.

---

quote:

---

Originally posted by adit

Hi,
Can you please suggest a way I can do it by query instead of stored procedure with cursors, because the data is very huge and I have to map it the way as described.

---

CREATE PROC MyProc
@source_id int,
@active_id int
AS
select a.e_id,b.l_name,c.new_id
from a
inner join b on a.s_id=b.s_id
inner join c on b.l_id=c.l_id and b.r_id=c.r_id and b.source_id=c.source_id
where c.source_id = @source_id 
and c.active_id = @active_id 
GO

quote:

---

Originally posted by visakh16

quote:

---

Originally posted by adit

Hi,
Can you please suggest a way I can do it by query instead of stored procedure with cursors, because the data is very huge and I have to map it the way as described.

---

there's no need for cursor. you can just have parameters for passing values and create a procedure with them

like

CREATE PROC MyProc
@source_id int,
@active_id int
AS
select a.e_id,b.l_name,c.new_id
from a
inner join b on a.s_id=b.s_id
inner join c on b.l_id=c.l_id and b.r_id=c.r_id and b.source_id=c.source_id
where c.source_id = @source_id 
and c.active_id = @active_id 
GO

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

quote:

---

Originally posted by adit

quote:

---

Originally posted by visakh16

quote:

---

Originally posted by adit

Hi,
Can you please suggest a way I can do it by query instead of stored procedure with cursors, because the data is very huge and I have to map it the way as described.

---

there's no need for cursor. you can just have parameters for passing values and create a procedure with them

like

CREATE PROC MyProc
@source_id int,
@active_id int
AS
select a.e_id,b.l_name,c.new_id
from a
inner join b on a.s_id=b.s_id
inner join c on b.l_id=c.l_id and b.r_id=c.r_id and b.source_id=c.source_id
where c.source_id = @source_id 
and c.active_id = @active_id 
GO

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

I am sorry if i did not get you, but actually i need the query to run on all distinct active_id's in the table. the data posted is only a sample. without a cursor, how can we pass values to parameters?

---