Actually, you need to specify OR in your where clause instead of AND.

A product id cannot be both 100 and 200, it is one or the other.

It works in a 2008 r2 instance, and as I say here is a post about it from 2003:
parsename

Here's a post about it from 2003:

using parsename

Try using the Parsename function:
https://docs.microsoft.com/en-us/sql/t-sql/functions/parsename-transact-sql?view=sql-server-2017

Lynn,

is there a reason why you put the iTVF access in a subquery? I use this form:

SELECT

isnull(HarvestYear,0) HarvestYear

FROM

[tblFuelFlow]

...

It is getting the average commission for each Job ID

You can wrap your query in double quotes:

declare @sql varchar(max)

set quoted_identifier off

set @sql = "SELECT Col1, Col2 FROM MyTable WHERE FOO = 'BAR' "

-- remember to reset quoted identifier after...

Why not import the whole file into a new table and then update your existing table with an update statement.

Once it has worked you can drop the imported table if...

You only need the update statement.

The code before that is me setting up test data on my machine so I could test that it works.

You just have to replace...

Just to add, in the code above, my Job_id field refers to the Op's PDF_JOB_ID field.

You could try something like the code below:

-- set up test data

if object_id('tempdb..#printtab') is not null

drop table #printtab

create table #printtab (

Letter_idvarchar(10),

job_idvarchar(5),

txtvarchar(5)

)

insert into #printtab

select '123','aaa','flg' union all

select null,'aaa','flg' union all

select null,'aaa','flg'...

SQL Server will have interpreted originating_Shift_Type as an alias for the To_work column.

It's the same as:

select To_work [originating_Shift_Type]

from dbo.dutyrostershift

where ...