User Profile

Collapse

Profile Sidebar

Collapse
eniada
eniada
Last Activity: Dec 11 '13, 02:33 PM
Joined: Sep 17 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • eniada
    replied to Please see this problem i need it soon possible!
    in SQL Server
    what to do in this case?
    See more | Go to post

      Leave a comment:

    • eniada
      replied to Please see this problem i need it soon possible!
      in SQL Server
      Code:
      select OrderId, OrderGroupId, dtCreated,  DORNum, (select  intPercentageFill  from orders where OrderStatus='sh' ) as intPercentageFill
 from orders where OrderStatus='sb'
 order by DORNum

      is opening this error:Msg 512, Level 16, State 1, Line 3
      Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
      See more | Go to post
      Last edited by Rabbit; Sep 20 '13, 05:33 PM. Reason: Please use code tags when posting code or formatted data. Second warning.

        Leave a comment:

      • eniada
        started a topic Please see this problem i need it soon possible!
        in SQL Server

        Please see this problem i need it soon possible!

        Code:
        select OrderId, OrderGroupId, dtCreated,DORNum , (select top 1 intPercentageFill from orders where  OrderStatus='sh' )
 as 'intPercentageFill'  from orders where OrderStatus='sb'
        i am try to display on intPercentageFi ll column the data that have a status="sh" no sb like the other ,in this case is displaying but only the first record,the others are equal with first.In first picture is displaying what i am getting and...
        See more | Go to post
        Last edited by Rabbit; Sep 17 '13, 08:41 PM. Reason: Please use code tags when posting code or formatted data.
        No activity results to display
        Show More
        Working...