how to write for loop and cursor in sql server

Question

how to write for loop and cursor in sql server

Viewing 3 posts - 46 through 47 (of 47 total)

You must be logged in to reply to this topic. Login to reply

Sivaganesh Tamilvendhan Hall of Fame Points: 3498 More actions · Answer 1

here i joined seven table for this i used your split function only there i nothing wrong in that execpt one thing if i exec the store proc means for example it depend on busness name are some words like this

EXEC [dbo].[SP_Searchengine] @VALUES = N' tvs automobile' it is providing output like this

AdSpaceId AdInfoId BusinessName AdSpaceName FileName TotalBlocks

31 33 Audii Jubilant Motors Audi Motors AMmail2.JPG 2

38 41 bikespot in banglore bike spot AMmail1.jpg 2

39 42 car spot in u.s car spot AMmail1.jpg 2

40 43 tata car production car production AMnewt.bmp 4

44 46 tvs automobile tvs sports img30.BMP 12

51 53 mahaidra show room mahindra AM.bmp 4

54 55 castrol oil castrol AMcast.bmp 6

i didn't get weightage for the word it was in the fifth position

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

sivag (4/6/2012)
here i joined seven table for this i used your split function only there i nothing wrong in that execpt one thing if i exec the store proc means for example it depend on busness name are some words like this
EXEC [dbo].[SP_Searchengine] @VALUES = N' tvs automobile' it is providing output like this
AdSpaceId AdInfoId BusinessName AdSpaceName FileName TotalBlocks
31 33 Audii Jubilant Motors Audi Motors AMmail2.JPG 2
38 41 bikespot in banglore bike spot AMmail1.jpg 2
39 42 car spot in u.s car spot AMmail1.jpg 2
40 43 tata car production car production AMnewt.bmp 4
44 46 tvs automobile tvs sports img30.BMP 12
51 53 mahaidra show room mahindra AM.bmp 4
54 55 castrol oil castrol AMcast.bmp 6
i didn't get weightage for the word it was in the fifth position

Okay. What do you want from me, a miracle? Perhaps I should buy a round trip ticket to where ever you live and work and come help you personally, would that help?

I have told you what is needed if you want help and yet you continue to REFUSE to provide that information. We can't help you if you are UNWILLING to help YOURSELF.

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Sivag you seem to be missing three items from your question.

1) ddl

2) sample data

3) desired output based on your sample data

Basically that means at this point you haven't posted a question, you have posted some random gibberish without nearly enough information to provide an answer. If you post those things you will get help. If you do not, then I wish you the best of luck.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/