Try the below:

For the values and states

Up Arrow Indicator

Start = 1 End = 1

Down Arrow Indicator

Start = 2 End = 2

Some other indicator to capture where they are the same...

Not a happy chap with some of the help being offered! Go figure 🙂

http://www.sqlservercentral.com/Forums/Topic1604205-392-2.aspx

Thank you for the feedback. I have to say g.britton gave some very valid...

gbritton1 (8/18/2014)

higgim (8/18/2014)

Whilst this is fine and dandy when an insert occurs which fails the checks...

Whilst this is fine and dandy when an insert occurs which fails the checks an error...

or you could just do this 🙂

UPDATE dbo.process_ApplyJob_1

SET checkingStatus = 1

WHERE ( SexID = r_SexID )

...

Based on what you posted try the below. The only way I could think of doing this was using a massive case statement. (I'm sure someone may come...

That should sort it.

DECLARE @somedates AS TABLE ( update_time DATETIME )

INSERT INTO @somedates

( update_time )

VALUES ( '2014-08-14 14:14:35' ),

...

This any good?

SELECT DATEADD(dd, -( DATEPART(dw, update_time) - 1 ), update_time) AS [Week Commencing] ,

DATENAME(mm, update_time) AS 'Month' ,

...

By chance in one of the query windows are there any open transactions which have not yet been committed? (Just a guess which could be completely wrong)

Ignore the above...

Could you provide some sample data and what the expected result in please and I will have a look

What is the length roughly of each value you are passing into the text box and how many items when you "Select All" are in the list?

Are there...

More for Sean this one. Since I saw your comment it's been bugging me all afternoon (hate writing iffy code but still learning) so had another attempt which may...

Sean - Would be interested in seeing a better approach to this purely from a learning point of view.

You could try adding some primary keys etc onto the tables. An actual execution plan would be a good start