arrays in c# ?

Question

Hi fellas 

I tried and done with below requirement but i am not sure ..

Requirement is : 

Write an app that calculates the product of a series of integers that are passed to method product using a variable-length argument list. Test your method with several calls, each with a different number of arguments.


Thank you for help ... 

Answer 1

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

Answer 2

Here i coded Cursor based Logic for you !!

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

Answer 3

Kiran,

Can you post the tSql you have now and I can look into it.

Thanks,
Bryian Tan

Answer 4

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

Answer 5

hello,

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

Thanks,
Bryian Tan