CREATE Table Customer
(
CustomerID int,
FirstName varchar(50),
LastName varchar(50),
EmailAddress varchar(50),
PCity varchar(50),
PState varchar(20)
)
INSERT INTO Customer VALUES(1,'Vinay','k','vinay.k@xyz.com','Bangalore','KA');
INSERT INTO Customer VALUES(2,'Manoj','m','manoj.m@xyz.com','Hyderabad','AP');
INSERT INTO Customer VALUES(3,'Varun','k','varun.k@xyz.com','Hyderabad','AP');
INSERT INTO Customer VALUES(4,'hari','Singh','hari.singh@xyz.com','Bangalore','KA');
INSERT INTO Customer VALUES(5,'mano','k','mano.k@xyz.com','Hyderabad','AP');
--Declare whichever fields you would like to use inside the while loop. In this example I just want to print the customer email address
--and so I have used only 3 fields
SET NOCOUNT ON
DECLARE @Cust TABLE(CustomerID int,FirstName varchar(50),EmailAddress varchar(50))
INSERT INTO @Cust
SELECT CustomerID,FirstName,EmailAddress FROM Customer WHERE PCity='Hyderabad'
DECLARE @CustomerID int
DECLARE @FirstName varchar(50)
DECLARE @EmailAddress varchar(50)
WHILE( (SELECT COUNT(*) FROM @Cust) > 0 )
BEGIN
SELECT TOP 1 @CustomerID=CustomerID, @FirstName = FirstName, @EmailAddress = EmailAddress FROM @Cust
--I am just printing the values in the variables. You may do whatever you need based on your need.
PRINT @FirstName + ' ' + @EmailAddress
DELETE FROM @Cust WHERE CustomerID = @CustomerID
END
SET NOCOUNT OFF
DROP TABLE Customer
(
CustomerID int,
FirstName varchar(50),
LastName varchar(50),
EmailAddress varchar(50),
PCity varchar(50),
PState varchar(20)
)
INSERT INTO Customer VALUES(1,'Vinay','k','vinay.k@xyz.com','Bangalore','KA');
INSERT INTO Customer VALUES(2,'Manoj','m','manoj.m@xyz.com','Hyderabad','AP');
INSERT INTO Customer VALUES(3,'Varun','k','varun.k@xyz.com','Hyderabad','AP');
INSERT INTO Customer VALUES(4,'hari','Singh','hari.singh@xyz.com','Bangalore','KA');
INSERT INTO Customer VALUES(5,'mano','k','mano.k@xyz.com','Hyderabad','AP');
--Declare whichever fields you would like to use inside the while loop. In this example I just want to print the customer email address
--and so I have used only 3 fields
SET NOCOUNT ON
DECLARE @Cust TABLE(CustomerID int,FirstName varchar(50),EmailAddress varchar(50))
INSERT INTO @Cust
SELECT CustomerID,FirstName,EmailAddress FROM Customer WHERE PCity='Hyderabad'
DECLARE @CustomerID int
DECLARE @FirstName varchar(50)
DECLARE @EmailAddress varchar(50)
WHILE( (SELECT COUNT(*) FROM @Cust) > 0 )
BEGIN
SELECT TOP 1 @CustomerID=CustomerID, @FirstName = FirstName, @EmailAddress = EmailAddress FROM @Cust
--I am just printing the values in the variables. You may do whatever you need based on your need.
PRINT @FirstName + ' ' + @EmailAddress
DELETE FROM @Cust WHERE CustomerID = @CustomerID
END
SET NOCOUNT OFF
DROP TABLE Customer
No comments:
Post a Comment