storedprocedure quarie....display only distinct name and mo

JAYRAM

13y2.4kSQL

I have a table with 10 field ..

name , fname, mobile, area, hno,,refid,refname,refadd,refmob,dob
.....
how to write storedprocedure quarie....display only distinct name and mobile...

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Arul Manivannan13y ago
Accepted answer
Hi,
Pradip Pandey's solution seems correct. So thumbs upped that reply. sv r said he wants to display, not to insert into that table.

Please execute the following

CREATE PROCEDURE sp_displayNameMobile
AS
BEGIN
SELECT DISTINCT name, mobile from tablename
END

Arul Manivannnan
Pradip Pandey13y ago
Yes
Arul you are right and hope sreejesh will also get the question.

Hope it will help.
Sreejesh SP13y ago
Dear pradeep,

He want insertion query

thanks

sreejesh

Pradip Pandey13y ago

Select distinct from

Hope it will help.

Sreejesh SP13y ago

Dear sw,

First you set your table field unique as name and mobile

create procedure usp_address
(
@name varchar(50),
@fname varchar(50),
@area varchar(50),
@hno numeric(18,0),
@rfid numeric(18,0),
@refname varchar(50),
@refadd varchar(50),
@refmob varchar(50)
@dob varchar(50)
)
DECLARE @AFFECTEDROWS INT
DECLARE @Message VARCHAR(1000)

AS
BEGIN TRAN
BEGIN TRY

INSERT INTO TABLE1(name,fname,mobile,area,hno,refid,refname,refadd,refmob,dob)
VALUES(@name ,@fname ,@area ,@hno ,@rfid ,@refname ,@refadd ,@refmob ,@dob )
SET @AFFECTEDROWS =@@ROWCOUNT;
IF(@AFFECTEDROWS<=0)
BEGIN
ROLLBACK TRAN
END
ELSE
BEGIN
COMMIT TRAN

END

END TRY

BEGIN CATCH
SET @Message = ERROR_MESSAGE();

PRINT @Message
END CATCH

PLEASE TRY THIS CODE

THANKS

SREEJESH