Ahh, I feel like a real dumb *** right now ...

It's working much better now, it still struggles on some part numbers though.

If I enter ERR3340, then everything is good:

ERR3340KIT...

This, for example, returns 0 rows for the last segment.

CREATE TABLE #Supersessions

(

PartNo VARCHAR(20)

,PNPrior VARCHAR(20)

);

INSERT...

I didn't realise there was a third part to the query. The second part returns all of the supersessions (6 rows) of the chosen number, in the PartNo column -...

These are the results I am getting - there are four images in total:

https://skydrive.live.com/?cid=97BDA2515235BDF6&id=97BDA2515235BDF6%213286&v=3#cid=97BDA2515235BDF6&id=97BDA2515235BDF6%213286&v=3

The last query doesn't seem to be doing a lot.

Thanks.

Ok, so it seems to be working with this:

CREATE TABLE #Supersessions

(

PartNo VARCHAR(20)

,PNPrior VARCHAR(20)

);

INSERT INTO...

Apparently, SELECT INTO statements are not supported in Azure SQL Server .... nicely played, Microsoft. Do you have any suggestions?

Color me stupid but where exactly do I need to declare it?

Thanks.

Hi,

Thanks for your hard work, it's appreciated. As it stands, executing that query results in:

[Err] 42000 - [SQL Server] Must declare the scalar variable "@N"

just after

JOIN #Source b ON a.PartNo...

Hi,

I would like the result returned as

'SFP500160','KIT BRAKE LINING',58.02,{array of previous and current part numbers}

ie

'SFP500160','KIT BRAKE LINING',58.02,{ 'RTC5756','STC8572','STC3765','STC9150','STC9191','SFP500160' }

or two split results, whichever is easier

'SFP500160','KIT BRAKE LINING',58.02

'RTC5756'

'STC8572'

'STC3765'

'STC9150'

'STC9191'

'SFP500160'

Baring in...

Hi,

Many thanks for your prompt reply and patience.

What I'm really trying to achieve is, a user inputs a part number, ie STC8572 (the customer does not necessarily have access to...