sql 2008 quary

• ashwiniranju14

  SSC Journeyman

  Points: 78

  More actions

  March 2, 2012 at 3:51 am

  #256901

  Hi sir,

  In the below coding no compilation error but using this quary i am not getting the answer please give me the answer for this below quary

  select ProductID,Name,

  NameResults.Rank as NameRank,

  DescriptionResults.Rank as DescriptionRank

  from Product

  left outer join

  containstable(Product,Name,

  'Formsof(INFLECTIONAL,red)and FORMSOF(INFLECTIONAL,blue)',

  language 'english') as NameResults

  on Product.ProductID=NameResults.

  left outer join

  containstable(Product,Description,

  'Formsof(INFLECTIONAL,red)and FORMSOF(INFLECTIONAL,blue)',

  language 'english') as DescriptionResults

  on Product.ProductID=DescriptionResults.

  where(NameResults.Rank is not null)and(DescriptionResults.Rank is not null)

  order by(isnull(NameResults.Rank,0)* 3 + isnull(DescriptionResults.Rank,0))desc

• manukumar

  SSC-Addicted

  Points: 489

  More actions

  March 2, 2012 at 6:58 am

  #1454139

  its like you are not getting any result after firing above query?

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  March 2, 2012 at 7:34 am

  #1454169

  You posted this query in two forums about jobs???

  I will attempt to respond to your question.

  In the below coding no compilation error but using this quary i am not getting the answer please give me the answer for this below quary

  I am not sure what the answer is because I don't know what the question is.

  _______________________________________________________________

  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/