How's this? (comments in the code)

;

WITH cte AS

(

-- get the columns we actually need

-- add a row number that restarts whenever the ind_id changes

-- order the row number by the...

The CROSS JOIN is what you're looking for. Here's an example:

-- For information on how a tally table works, please see the article

-- 'The "Numbers" or "Tally" Table -...

And assuming that the order number won't always start at the same position, this will handle extracting it.

;WITH cte AS

(

-- get the position of the first numeric character

SELECT OrderNumLine, pos...

What's up with all the old threads being resurrected lately? I've seen several this week already... 🙁

So, do we need to recalculate the IsCorrect column with all of the rules that you provided, or just use it's current right/wrong value to update? If the latter, the...

From PM from the OP:

In the Direction column for IN its '1' for OUT its '0'.

Yes, I want to update the current IsCorrect column with 1(right) and 0(wrong)

Below is the...

I think when Paul starts teaching, that most of us get that way. Maybe we need to start bugging him for more articles???...

I went iPad.

Thanks for the feedback.

Check out this article: Loading XML Data into SQL Server (SQL Spackle)[/url]

Would you mind sharing with us so that we (and anyone that stumbles across this in the future) know what actually worked for you?

If I understand this right, here's two methods for accomplishing this:

1:

SELECT PKeyItem,

ItemName,

IsUserItem = CASE WHEN EXISTS...

So that someone in the future that stumbles across this thread knows, can you post your procedure here so that it can be referenced?

Grant Fritchey (5/23/2011)

I can help you with the wife, it's...

Why doesn't the GUI work? Is it generating an error?

The T-SQL code to run is:

ALTER TABLE <YourTable> ALTER COLUMN <YourColumn> DATETIME <NULL?>