User Profile

Collapse

Profile Sidebar

Collapse
gadall
gadall
Last Activity: May 4 '08, 01:22 AM
Joined: Mar 18 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • gadall
    replied to Trying to get data by distinct field values
    in SQL Server
    Working solution:

    Code:
     SELECT DISTINCT Account_Num,
   
            Work_Order_Num,
   
            Schedule_Date,
   
            Assigned_Installer,
            
            MIN(Short_Description) as Short_Desc,
   
            QCID,
   
            QCPassFail
  
      FROM QCData 
  
	  WHERE QCPassFail IS NOT NULL AND Schedule_Date
    ...
    See more | Go to post

      Leave a comment:

    • gadall
      replied to Trying to get data by distinct field values
      in SQL Server
      I need all the information shown in the records (the actual records have a lot more information) This information is pulled into an excel spreadsheet for a detailed report (the count is done by formula in excel)....
      See more | Go to post

        Leave a comment:

      • gadall
        replied to Trying to get data by distinct field values
        in SQL Server
        Code:
        Account_Num  Work_Order_Num   Schedule_Date    Short_Desc   TechID  QCID QCPassFail
20661406	 25853100	       2007-10-12       VIDEO DISC  73002   73011  1
20661406	 25853100	       2007-10-12       CHSI DISC	 73002   73011  1
        For the purposes of this report, I only need 1 of these records, which one, is irrelevant.
        See more | Go to post

          Leave a comment:

        • gadall
          started a topic Trying to get data by distinct field values
          in SQL Server

          Trying to get data by distinct field values

          I have a table that has job data, Account_Num, Work_Order_Num, Date, Short_Desc, TechID, QCID, QCPassFail.

          In this table there may be multiple records with the same Account_Num and Work_Order_Num, however when it comes time to check the QCPassFail, I need to only count 1 for each unique Account_Num/Work_Order_Num pair.

          My problem comes in that I need more than just those 2 fields for reporting purposes so a SELECT DISTINCT...
          See more | Go to post
          • gadall
            replied to Retrieving data that matches a list
            in SQL Server
            Thanks this works with the minor edit of removing the "," after the last end of the case statements....
            See more | Go to post

              Leave a comment:

            • gadall
              replied to Retrieving data that matches a list
              in SQL Server
              My problem is I need *multiple* FCodeDescriptio ns returned for each record in Table 1.

              Some Sample data:
              Table 1
              ----------
              Schedule_Date Work_Order_Num FCode
              03/12/2008 13259127 F02F03


              Table 2
              -----------
              FCode FCodeDescriptio n
              F01 Work Not Completed
              F02 Trash in Work Area
              F03 ...
              See more | Go to post

                Leave a comment:

              • gadall
                started a topic Retrieving data that matches a list
                in SQL Server

                Retrieving data that matches a list

                I've got two tables that I need to match data, the part that has me stymied is that in table1 there is a field that can hold 1 to 3 codes, that will match up against table 2.

                Table 1
                ----------
                Schedule_Date (DateTime)
                Work_Order_Num (nchar(8))
                FCode (nvarchar(9)) <--- 3, 3 character codes



                Table 2
                -----------
                FCode (nchar(3))
                FCodeDescriptio n (nvarchar(100))...
                See more | Go to post
                No activity results to display
                Show More
                Working...