Selecting Value by value From Records Of Specific view Stored procedure

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi every one

I have a view consist of two Column F1 and F2.

I want to loop through this View from first record To last record and select for each record the value of F2 if it satisfy some condition, do some actions and continue to the next record, otherwise continue to next record too.

Can any one help me in looping through the View From the first record to the last one as I mentioned above
using SQL ?

Thanks

Posted 3-Mar-11 14:10pm

Yasser El Shazly

Updated 3-Mar-11 14:45pm

v3

Add a Solution

Comments

Henry Minute 3-Mar-11 20:43pm

You do not say which language you want to use to do this.

Do you want to do it in one of the .NET languages, or SQL or what? :)

Yasser El Shazly 3-Mar-11 20:44pm

SQL

Albin Abel 3-Mar-11 20:59pm

It is a general question. You can use the view just like a table in sql. So for the loop and inner conditions you need to learn how to write stored procedure. First try yourself and post here if you get any problem.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

_Maxxx_ · Answer 1 · 2011-03-03T16:55:00

This is untested - from memory so excuse any errors - but it should get you started.

In your stored procedure do something like this..

DECLARE cursorForView
    CURSOR LOCAL FAST FORWARD FOR
       SELECT F1, F2 from yourView

OPEN cursorForView

Declare @f1 as int
Declare @f2 as int

Fetch next from cursorForView into @F1, @F2

WHILE @@FETCH_STATUS = 0
BEGIN
  IF @F2 = somecondition
  BEGIN
    dosomething
  END


Fetch next from cursorForView into @F1, @F2

END

CLOSE cursorForView
DEALLOCATE cursorForView