Having doubt on procedure with joins

• raghuldrag

  Hall of Fame

  Points: 3160

  More actions

  January 8, 2013 at 10:45 pm

  #272540

  Hai friends

  i ve 5 tables now i wanna make a join with in that and i m done join

  now the problem is how to pass that joins in procedure

  Thanks & Regards

  Raghuldaggi

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  January 8, 2013 at 11:22 pm

  #1575070

  it seems that you are quite familiar with this forum . so table defintion , index , test data was expected. it is better to get the result faster.

  Anyways

  see these links

  http://www.mssqltips.com/sqlservertip/1495/getting-started-with-sql-server-stored-procedures/

  http://msdn.microsoft.com/en-us/library/aa258259(v=sql.80).aspx

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• vinu512

  SSCoach

  Points: 15729

  More actions

  January 9, 2013 at 11:58 pm

  #1575609

  raghuldrag (1/8/2013)

  ---

  Hai friends

  i ve 5 tables now i wanna make a join with in that and i m done join

  now the problem is how to pass that joins in procedure

  Thanks & Regards

  Raghuldaggi

  From your post I can only assume that you have written a JOIN query which uses 5 tables.

  Just put that query in procedure code as follows :

  Create Procedure <Procedure_Name>

  As

  Begin

  <Paste your JOIN query here>

  End

  If this is not what you are looking for(and I presume this is not) then please post DDL and sample data for your requirement to explain what you want to do. That would get you a solution in no time.

  Vinu Vijayan

  For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉