User Profile

Collapse

Profile Sidebar

Collapse
cris1978
cris1978
Last Activity: Sep 28 '07, 01:35 PM
Joined: Sep 12 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • cris1978
    replied to Comparing more than one column & update
    in SQL Server
    _______________ _______________ _______________ _______________ __

    I tried to use your idea, but doesn't work...It's not reporting any error.
    Any suggestion?...
    See more | Go to post

      Leave a comment:

    • cris1978
      started a topic Comparing more than one column & update
      in SQL Server

      Comparing more than one column & update

      Hi,

      I'm trying to do this query to update the results in a table, it's compiling and running without problems, but it's not updating the table, could you guys help me?

      Many Thanks!

      _______________ _______________ _______________ _______________ ____
      DECLARE
      @COUNT INT
      BEGIN

      SET @COUNT=(SELECT (Segunda-Sexta) FROM tblMedicao WHERE IDItem = '15')

      ...
      See more | Go to post
      • cris1978
        replied to SQL Query to sum accross the row
        in SQL Server
        _______________ _______________ _______________ _____________

        Thanks!!!

        This works very fine!!...
        See more | Go to post

          Leave a comment:

        • cris1978
          replied to SQL Query to sum accross the row
          in SQL Server
          ------------------------------------------------------------------------------------------------------------

          I run the query, but it's the results of the Total column is '0'.

          Do you have any idea?...
          See more | Go to post

            Leave a comment:

          • cris1978
            replied to How to insert another WHERE
            in SQL Server
            Thanks!! Works fine with status = active
            See more | Go to post

              Leave a comment:

            • cris1978
              started a topic SQL Query to sum accross the row
              in SQL Server

              SQL Query to sum accross the row

              Hi,

              Can someone help to write a query that will sum the information across the row, not down the column.

              nome_item Sunday Monday Tuesday Wednesday Thursday Friday Total
              item1 12 5 5 9 4 23 58
              item2 2 6 2 2 45 3 60
              item3 3 7 3 3 4 3 23
              item4 4 8 4 4 4 5 29
              See more | Go to post
              • cris1978
                started a topic How to insert another WHERE
                in SQL Server

                How to insert another WHERE

                Hello,

                I would like to know if it's possible to insert a filter in the field "a.Status", but I don't know how... Is there someone who can help me?

                Below is the query that I'm trying to do...

                Thanks!
                -------------------------------------------------------------------------------------------------------------------
                SELECT
                a.eds_Billable, a.eds_System_Na me, a.SerialNo, a.AssetTag,...
                See more | Go to post
                No activity results to display
                Show More
                Working...