User Profile

Collapse

Profile Sidebar

Collapse
mgalvan
mgalvan
Last Activity: Jul 16 '07, 07:22 PM
Joined: Jul 19 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mgalvan
    started a topic Create Ranking Column
    in SQL Server

    Create Ranking Column

    I need to write a sql statement that will look at values in a column, sort them accordingly, and then create a new column
    that ranks the values...essent ially just creates a column of increasing integers in the order of the sorted column.
    See more | Go to post
    • mgalvan
      started a topic Yeartodate
      in SQL Server

      Yeartodate

      I'm creating a view and would like to get a report that will give year to date information. Any help would be appreciated. :)
      See more | Go to post
      • mgalvan
        started a topic Subquery Help
        in SQL Server

        Subquery Help

        I'm new to SQL and I'm trying to do a subquery.
        I'm not having any success. Can someone look at this query and tell me what I'm doing wrong.

        Thanks,

        :confused:

        SELECT I.ItemID, D.ShortDesc, K.KitItemKey
        FROM timKitCompList KL
        INNER JOIN timItem I ON KL.CompItemKey = I.ItemKey
        INNER JOIN timKit K ON KL.KitItemKey = K.KitItemKey
        INNER JOIN timItemDescript ion D ON...
        See more | Go to post
        No activity results to display
        Show More
        Working...