how to use cursor

Question

hi friends i need to know about cursors in sqlserver....i have a table called "kkk" with a column "status"...two values "present" and "absent" represents the column "status"...i want to count how many values represent "present" and "status"..i want this task to be done using cursors...i am very new to sqlserver....any other method is also appreciated....help me friends....

Mauricio Rosa · Answer

Hi Kiran, I think that you´re only tring to understand how to cursos work in SQL Server, rigth? How you´re new in SQL Server, it´s important keep in mind that cursors must be used only if have not another way to do what you need to do. Look using good eyes to temporary tables once SQL Server is optmized to work with them. Used on SQL Server, cursors deprecate the server perfomance in higher levels Regards

Kirtan Patel · Answer

Here i coded Cursor based Logic for you !! .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: Consolas, "Courier New", Courier, Monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { background-color: #f4f4f4; width: 100%; margin: 0em; } .csharpcode .lnum { color: #606060; } declare @total_absent numeric (5) declare @total_present numeric (5) declare @status varchar (50) declare c1 cursor for select * from kkk set @total_absent =0 set @total_present = 0 Open c1 fetch next from c1 into @status while @@FETCH_STATUS = 0 begin if ( @status = 'present' ) set @total_absent = @total_absent+1; else set @total_present = @total_present+1; fetch next from c1 into @status end print @total_absent print @total_present close c1 DEALLOCATE c1

Bryian Tan · Answer

Kiran, Can you post the tSql you have now and I can look into it. Thanks, Bryian Tan

kiran kumar · Answer

hi bryian,i want to know about this thing....after fetching a row value how to compare it to a constant string...all the way when i try to execute the cursor it showing error....never mind if it is a silly question..i am very new to sqlserver

Bryian Tan · Answer

hello, try this example http://blog.ysatech.com/post/2009/08/02/SQL-2005-Cursor-Template.aspx Thanks, Bryian Tan