Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Shio
Starting Member
1 Post |
 Posted - 2015-01-14 : 17:39:00
|
| I just found out what a SQL was about 5 minutes ago. Apparently I need one to pull queries for a big report that I need to do. No one knows how to do one. I need to pull up all the employees that worked for 2014 along with the regular hours, overtime hours worked, and gross pay. Can some please help me.Complete Noob at SQL |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-01-15 : 12:27:59
|
| Sounds like your manager is a noob, too!Anyway, you will need to know the database tables that contain the information you want and how they are related to each other. If you post the table definitions as CREATE TABLE statements, we can take a look at it. |
 |
|
|
viggneshwar
Yak Posting Veteran
86 Posts |
Posted - 2015-01-21 : 03:56:43
|
| Just refer the data model and then prepare for query. If you dont have data model then search for the corresponding tables and columns using sys.tables and sys.columnsRegardsViggneshwar A |
|
|
|
|
|
|
SQL for YTD info for work