Solution TSQL Help!!!

Question

Solution TSQL Help!!!

angelreynosog

Mr or Mrs. 500

Points: 545
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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 1

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 · Answer 2

Pulivarthi Sasidhar

SSCertifiable

Points: 6706

May 23, 2016 at 1:10 am

#1880672

Use Joins correctly...

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 3

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)