Employees
Id Name
1 Joe
2 Carol
3 Susan
DateLog
ID date Employee Note
1 10-1 1 Fun
2 10-1 1 Great
3 10-10 3 monkeys rule
3 12-12 3 i like elephants
So I want All employees with their earliest date applied, but also the...
We have a 2003 server that is having the daily problem of the time becoming unsynchronized. It seems to be off 2-3 minutes everyday. I changed the wendows time synch to update daily, but that seems to be a bandaid to the problem. It startet out being off a couple minutes a week. I dont want...
Looking at the estimated execution plan for these they look the same, i think. Are there any differences?
Select * from Table1 T1 INNER JOIN Table2 T2 ON T1.ID=T2.T1ID WHERE T1.Field1=@var
Select * from (SELECT * From Table1 WHERE Field1=@var) AS T1 INNER JOIN Table2 T2 ON T1.ID=T2.T1ID...
This problem comes from an access database and old asp code. The program is basically a punch clock. People punch in and out. This is the basic guts of a punch record
The date and time are separate because it was originally put together in access and looked prettier then. It is now beind...
I am having serious slowness issues for something that should be speedy. Basically I want to find the highest point value(pv) for a referral(excluding pv's that are smaller for duplicate account numbers)
So if the table looked like this
ID AccntNum EmpID PointValue
1..3444.....45....60...
I have a DropDownList and a Repeater which is based on the selection in that List. When the SelectedIndex is changed I need the Data in the Repeater to be updated. (It doesn't have to be a repeater, I used that because it was displaying the recordset)
my aspx file is basically...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.