increasing value without using cursor

Question

0.00/5 (No votes)

See more:

SQL

create table #tmpTable
(
ProductName varchar(200),
Price float
)


insert into #tmpTable values('Cake',10),('Chocolate',20),('bun',30),('bisckit',40)

select * from #tmpTable
drop table #tmpTable

how to increase value of cake bun and biscuit by 10 and choclate by 5 without using cursor

Posted 23-Jan-12 19:44pm

elinashrestha

Updated 23-Jan-12 19:45pm

v2

Add a Solution

Comments

MingyiWang 24-Jan-12 2:06am

What's your meaning?
What's cursor?

4 solutions

Solution 4

update #tmpTable set price =price+ 10 where productname in ('Chocolate','Bun','Cake');
update #tmpTable set price =price+ 5 where productname='Bisckit'

the result will be--
ProductName Price
Cake 20
Chocolate 30
bun 40
bisckit 45

Posted 24-Feb-12 1:26am

The Doer

Updated 24-Feb-12 1:30am

v2

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Swapnil3 · Accepted Answer · 2012-01-23T20:02:00

Solution 1

There is a one way that u can use Update statement after insert statement in your stored procedure.

Posted 23-Jan-12 20:02pm

Swapnil3

Updated 23-Jan-12 20:20pm

v2

Comments

elinashrestha 24-Jan-12 2:13am

It should be in loop increment cake bun and biscuit by 10 and choclate by 5 as we use cursor it is done bze cursor value return one value bt cursor shouldnt be use .so in loop i wanna increment

Abhi KA · Accepted Answer · 2012-01-23T20:10:00

Solution 2

uisng update only u can increase .how to increase using cursor?

Posted 23-Jan-12 20:10pm

Abhi KA

Comments

elinashrestha 24-Jan-12 2:22am

plz can u send me code how to do that??
declare cursor ,open cursor after fetch put that query insert then close it will incremented one by one ..bt plz send me code how to do

manognya kota · Accepted Answer · 2012-01-23T20:36:00

Do you want to loop through the table and where ever you find choclate/bun/cake by 10 and where you find biscuit..increase the price by 5?

You can do it in 2ways.

1.Write update statements which will update all the corresponding rows.

update #tempTable set price =price+ 10 where productname in ('Choclate','Bun','Cake');
update #tempTable set price =price+ 5 where productname='Biscuit'

2. Loop through the table using a cursor and update the table accoridingly row by row.
See the below example

SQL

DECLARE vendor_cursor CURSOR FOR
SELECT BusinessEntityID, Name
FROM PurchasingVendor;

OPEN vendor_cursor;

FETCH NEXT FROM vendor_cursor 
INTO @vendor_id, @vendor_name;

WHILE @@FETCH_STATUS = 0
BEGIN
..... Do your updates here

Hope this helps.

increasing value without using cursor

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

increasing value without using cursor

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us