What do you mean by "data access interface inconsistent"? Why can't this be done? I mean it's just two conditions.

By the way, do you know how to add multiple conditions to a IF NOT EXISTS query. I need to check two conditions instead of one. I first...

thanks Elliot, you are correct. Sorry I didn't acknowledge your query.

Yes, I do need to get this in one row, so that the result set will be

Supervisor

Joshua Miller

Employee

Raymond Greer

Can you get this?

Let me be clearer.

The first table is just the employee table. the second table is the relationship between the people in the first table. What I would like...

Problem solved. Thanks for everyone who responded with their expertise. Apparently, the code in the app was postbacking every second due to the timer control and therefore updating...

Can someone teach me about triggers. My experience with sqlserver is pretty much limited to creating stored procedures, so I don't know know anything about logging tables as Sam...

I ran the profile trace, and when it went through the code, there was nothing unusual: The procedure only has one parameter "@username" and the command text for the...

There are no triggers on the table at all!

I executed the stored procedure within sqlserver and the column updated fine. However, when done through the code of the application,...

Thanks for the reply, but this query will not do when you are dealing with paging on gridviews, or datalists.

The problem I have with his solution is that he has a predefined set. No one has a predefined set of data in the real world. My data...

I ran the query as suggested, but the result was the same as the result as my query, it only sorted it by Correct, but not by the Totaltime.

Correct needs...

I have used your code, however this doesn't work either. Thanks for replying though. I hope someone could come up with a solution for this and explain it...

I figured it out after fiddling around with it. In the end, it was a simple solution, a one of sql grammar you might say. The problem was...

Thanks for responding.

Here is what I get when I print the @sql

SELECT id, ViewDate, AutoID, Fullname, Person, Color, Price, State

FROM(SELECT ViewDate, AutoID, Fullname, Person, Color, Price, State,

...