Hi,

I finally succed in getting the correct data which needs to be reversed.

My data 

CREATE TABLE mycompanytable2(
 CompanyName NVARCHAR(50) NOT NULL PRIMARY KEY
,ItemName ...

Hi,

I finally succed in getting the correct data which needs to be reversed.

My data 

CREATE TABLE mycompanytable2(
 CompanyName NVARCHAR(50) NOT NULL PRIMARY KEY

Hi,

Here is the changed Insert statements

CREATE TABLE mycompanytable(
 Companyname         NVARCHAR(50) NOT NULL
,item_name          NVARCHAR(50) NOT NULL
,Stock_last_month        NUMERIC(6,2) NOT...

Hi all,

I not sure what to do now.

Do you want me to create a different set of insert statements without Group_ID and convert decimal values...

Hi all,

I rewrote the post using the suggested tools.
se here: https://www.sqlservercentral.com/Forums/1877075/Reverse-ouput?Update=1#bm1877089

HI,

Parent_Group_ID will be used group fields from 'Sold in current time frame in KILOS'  and companyname are the name to display in the final output.

I...

Hi,

Thank you for responding

The original data consists of 6 tables.
The data from these are packed into the test tabel above., for easier understanding (i hope).

Hi Luiz

Thank you for answer.
I will provide a better question with sample data.

Would you plz. remove the image in your last post. It might...

Hi again,

this is the ouput i am trying to achive.

Hi Chris,

I believethat a simple query with just one column, would be something like

SELECT cus.CompanyName, kc.SalesItemId, N.ItemName AS...

Hi

I am trying to build records like shown on the image. There can be more Columns like procent1 and procent2

I have the company names in one table

SELECT ...

Hi,

Just read your posts.

It could also work, the way you describe, where i only submit either of the 4 values or all 4, in some cases.

Didn´t know,that my statement 'I...

Hi John,

Yes COALESCE is the way.

Thanks a lot!!

Changed to this and it works perfect.

DECLARE @CarName nvarchar(max)

DECLARE @carage int

DECLARE @TyreId int

DEclare @TyreType int

DECLARE @Zipcode int

DECLARE @CarId int

DECLARE @RegionId int

SET...

Hi John,

So far i have this.

DECLARE @CarName nvarchar(max)

DECLARE @carage int

DECLARE @TyreId int

DEclare @TyreType int

DECLARE @Zipcode int

SET @TyreId = 65

SET @CarName = 'CITROEN'

SET @carage = 2002

SET @Zipcode...

I found the solution.

Sometimes it helps, when you write your problem down on 'paper'.

SELECT

T.c.value('../../@Id[1]','int') AS PropertyId,

T.c.value('(CountryCode/text())[1]', 'varchar(256)') as CountryCode,

T.c.value('(Number/text())[1]', 'varchar(256)') as PhoneNumber

FROM @x.nodes('//Property/PhoneList/Phone') T(c)