My table column datatype is

[nvarchar](max) NULL,

The data is imported from xml, so it is coming in new line with carriage return

I am unable to get result since,

My Table column is having data as stored as below in the nvarchar(max) datatype

---------------------------------------------------------------------------------

'(Type is HO) and

(Location is Europe)...

declare @t table

(

s varchar(8000)

)

insert @t

values('(Location is Asia)'),

('(Location is Asia and Location is Africa)and Branch in AR and Branch in SE'),

('(Location is Europe)and Branch in AR and Branch in SE'),

('(Type is...

CREATE TABLE #SampleData(

SomeText varchar(1000))

INSERT #SampleData SELECT

'( Branch is not CA and Branch is not MX)' UNION ALL SELECT

'( Branch is not CA and Branch...

Thanks Luis for the code.

How to send them to different column ?

Like,

select dbo.GetRelevantCity(ColumnA , 'BI') as BranchIn , dbo.GetRelevantCity(ColumnA, 'BN') as BranchNotIn ,

dbo.GetRelevantCity(ColumnA, 'BN') as OtherInfo from...

Thanks for the link and scripts.

dwain.c (1/9/2014)

---

Something like this perhaps?

WITH rCTE AS

(

SELECT b.Mode_ID, b.Mode_info, Mode_Detail=Mode_info, QA, QC, QY, Mode_Sno, b.Has_Nodes

FROM Travel_Quantity a

JOIN Travel_Master...

Since my Values are NULL, I was not getting the complete result for QY Column.

Instead of

ROAD AUDI 0 0 84

ROAD BMW 0 0 36

I need result as.. calculation against the immediate parent only.

ROAD AUDI 0 0 18

ROAD BMW 0 0 42

Kindly suggest

Hi,

Thanks for your SQLQuery !

But, In The QY Column, I am NOT getting values for all chils.

Data is showing only for

CAR BMW ...

Sean Lange (1/9/2014)

---

Shanmuga Raj (1/9/2014)

---

Sean Lange (1/9/2014)

---

Excellent job posting ddl and sample data. I can't understand what you want for output. I can't seem to figure out the relationship between...

Luis Cazares (1/9/2014)

---

You might want to review your sample data as it won't give the expected results. Root for ship and boat is air and some multiplications won't give the...

Sean Lange (1/9/2014)

---

Excellent job posting ddl and sample data. I can't understand what you want for output. I can't seem to figure out the relationship between these tables.

I think that...

Error In My query, I need to have ROAD instead of car.

Expexted

AIR 0

SEA SHIP ...

below is the solution

thanks

with cte

as (select load_id

,mode_sno

...

dwain.c (12/19/2013)

---

Note that if you want Quantity on the line with the SubProduct to be zero, just change this line:

VALUES(a.[Product Id], SubProduct, NULL), (a.[Product Id], NULL,...