Solution TSQL Help!!!

• angelreynosog

  Mr or Mrs. 500

  Points: 595

  More actions

  May 16, 2016 at 1:45 pm

  #307565

  I have a database that was in Access, the amount to SQL Server and there, want to make a query to do the following, I have a table called anio_2015 , and containing employee , brand, and hours . I have another brand table contains the description of the marks and another table called employee , there is the user and the user name. I want to make a query to show me the name of the employee and all marks that appear there and I only movements in the brands that filled that employee.

  Table Anio_2015

  Cod_Employees

  Cod_Brand

  Hours

  Table Brands

  Cod-Brands

  Description_Brands

  Table Employees

  Cod_Employees

  Name_Employees

• J Livingston SQL

  SSC Guru

  Points: 51550

  More actions

  May 16, 2016 at 1:54 pm

  #1879369

  some sample data and expected results would help me thinks

  ________________________________________________________________
  you can lead a user to data....but you cannot make them think
  and remember....every day is a school day

• Pulivarthi Sasidhar

  SSCertifiable

  Points: 6706

  More actions

  May 23, 2016 at 1:10 am

  #1880672

  Use Joins correctly...

• Jeff Moden

  SSC Guru

  Points: 1004616

  More actions

  May 23, 2016 at 1:23 am

  #1880677

  angelreynosog (5/16/2016)

  ---

  I have a database that was in Access, the amount to SQL Server and there, want to make a query to do the following, I have a table called anio_2015 , and containing employee , brand, and hours . I have another brand table contains the description of the marks and another table called employee , there is the user and the user name. I want to make a query to show me the name of the employee and all marks that appear there and I only movements in the brands that filled that employee.

  Table Anio_2015

  Cod_Employees

  Cod_Brand

  Hours

  Table Brands

  Cod-Brands

  Description_Brands

  Table Employees

  Cod_Employees

  Name_Employees

  Looking at the fairly obvious join columns in those tables, I'm thinking this is homework. Even if it's not, at least try.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)