Let's assume the requirement to store the file in a table is really required (instead of just the insert of a link to the file system...).

If it needs to be...

Something like this?

SELECT

A.Account,

A.Symbol,

SUM(CONVERT(INT, A.exeQty)) / 2,

CASE

WHEN SUM(CONVERT(INT, A.exeQty)) / 2 < 1000 THEN 'Chunk 1'

WHEN SUM(CONVERT(INT, A.exeQty)) / 2...

There's a missing GROUP BY:

SELECT

A.Account,

A.Symbol,

SUM(CONVERT(INT, A.exeQty)) / 2

FROM

( SELECT

RPM.Account,

RPM.Symbol,

...

duplicate post. no replies please.

Discussion already started here.

duplicate post. no replies please.

Discussion already started here.

duplicate post. no replies please.

Already discussed here

duplicate post. no replies please.

Already discussed here

duplicate post. no replies please.

Already discussed here

I wonder if the following scenario should be implemented, too:

One person can play different instruments in either the same band or in different bands (e.g. Bass guitar and Acoustic guitar).

From my point of view there's no valid argument for comparing Excel and a relational database (or the baby version of it AKA MS ACCESS):

Excel is a bunch of spreadsheets...

It seems like you also decided not to use the split function based on the link I referenced in my signature.

How do you expect us to help you if you...

I already did. See the code snippet above. It returns almost exactly what you're looking for.

It shouldn't be too hard to adjust it to your needs.

I've asked you to run the code I posted. Why don't you just do that?

The code you've posted is different.

If you complain the code doesn't work, it might very well...

Please post the code you're running.

The code runs just fine on my system.

Using the DelimitedSplit8K function refernced in my signature I would start with

DECLARE @RowColumn VARCHAR(30)

SET @RowColumn ='1_2|2_3|1_3'

SELECT

Itemnumber AS adbid ,

LEFT(item,CHARINDEX('_',item,1)-1) AS [row] ,

STUFF(item,1,CHARINDEX('_',item,1),'') AS [column]

FROM ...