regarding validations in stored procedure

• p.avinash689

  SSC-Addicted

  Points: 435

  More actions

  October 29, 2013 at 1:48 am

  #278636

  Hi all,

  1.I have input parameters like @age,@date, @time And @gender and output parameter was @paid amt.

  2. I have a conditions like

  a)between monday to friday(upto 9 pm) the doctor consultation fee was like

  Above 10 years -- 200 rs

  between 5-10 years -- 100 r.s

  below 5 years-- 0 r.s

  b) On saturdays the doctor consultation fee was like

  between 0-10 years -- 300 r.s

  above 10 years-- 500 r.s

  c) On sundays the doctor consultation fee was like

  between 0-10 years -- 300 r.s

  above 10 years-- 700 r.s

  d) on nights the consultation fee was like

  between 0-10 years -- 200 r.s

  above 10 years-- 500 r.s

  so i want to write validation in a storedprocedure to met the above conditions.

  please help me out from this task.

  Thanks in Advance,

  Avinash P

• Stuart Davies

  SSCoach

  Points: 19505

  More actions

  October 29, 2013 at 2:04 am

  #1662231

  Multiple post - see http://www.sqlservercentral.com/Forums/Topic1509192-391-1.aspx

  -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
  There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
  I would never join a club that would allow me as a member - Groucho Marx