hi i need cursor program

• rajendra prasad-377679

  Mr or Mrs. 500

  Points: 520

  More actions

  July 3, 2010 at 5:56 am

  #1188506

  hey linn thanks,

  if i need any help means i ll scrap u..

  Regards

  Prasad

• LutzM

  SSC Guru

  Points: 107049

  More actions

  July 3, 2010 at 11:22 am

  #1188544

  rajendra prasad-377679 (7/3/2010)

  ---

  ...

  now i am working in one organisation they ask me to write the program for that scenario using cursor..

  that s y i ask help to the experts..like u and gail etc.

  Prasad,

  usually, an organization has a business case that needs to be resolved (in your case: tons per day based related to some inventory information).

  Based on the data you have and the expected result it should be up to you what method you use to solve the issue.

  Like Gail, Lynn and Jeff I'd vote against a cursor. Jeff even posted a code snippet that might get you started...

  If you need help on how to get an expected result based on given sample data you should follow the links mentioned before and give us something "to play with".

  If you need to transform a business case description into database related requirements (e.g. table def, data type, stored procedures) you might want to get someone in helping you to do it.

  Side note: you'll get the fastest answers if you try to help us help you. Sample data in a ready to use format and expected result would be a good start. 😉

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

• Jeff Moden

  SSC Guru

  Points: 1004638

  More actions

  July 3, 2010 at 6:10 pm

  #1188589

  rajendra prasad-377679 (7/2/2010)

  ---

  hi dude

  hey can u send me the sample table with queries by using trigger..

  Regards

  prasad

  So! Dude! What did you end up doing?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)