Search results for query: *

Hi, I am trying to make a join between two tables but finding it tough. Tables are like: FIPS Table: ------------- State CountyCode PA 12345 MI 77777 RULES Table: -------------- State CountyCode PA 88888 PA 00000 Now, when I try to make a join between the...

The table does have other columns, but its more like some junk data.

Ok, let's add a column say DateTime also to the data. Will it be possible to do it then? I can try to get the date data.

Can we do something like adding a new column in the original table providing some sort of ranking to the data for each employee: EmployeeID Came_Late Rank 125175 No 1 125175 Yes 2 125175 No 3 334321 Yes 1 334321 No...

The last entry for the EmployeeID in the table is the last value for the employee. Fro example, EmployeeID 125175 has the last entry of Came_Late as "No". For 77889 it is "Yes". But I don't know how to find this using a query!

This table was provided to me. There is no date or row number column in it! IS there anything we can do about this? All Employee Data is stacked together, I didn't sort anything. In the table I have at most three entries of each employee together, then next employee...and it goes on like that...

Hi, I have a simple but tricky for me question. I have a table that has two columns: "EmployeeID" and "Came_Late". This table keeps track if an employee came late or not. The data kind of looks like this: EmployeeID Came_Late 125175 No 125175 Yes 125175 No 334321...