Thank you Chris,

I have implemented that already, based on user's requirements to apply only the described approach.

Thank you for the reply.

I have only posted 3 lines, as for each itinerary I am able to eliminate the rest of the segments and to remain with 3 only:

the...

Without the DDL for the table(s) and sample data, how do you expect us to help with the code you need? We can't see what you unless you give...

Sean Lange (4/24/2015)

---

BOR15K (4/24/2015)

---

Sean Lange (4/24/2015)

---

We can help but first you have to help us. We need some information here to offer any assistance. Please take a few minutes and...

Sean Lange (4/24/2015)

---

We can help but first you have to help us. We need some information here to offer any assistance. Please take a few minutes and read the first...

This depends...

I would use CHARINDEX

WITH myString AS (

SELECT '001' AS num

UNION ALL

SELECT '002' AS num

UNION ALL

SELECT '003' AS num

UNION ALL

SELECT '001.' AS num

UNION ALL

SELECT '004' AS num

UNION ALL

SELECT '002.' AS num)

SELECT...

Looks like a perfect start to me!

Thank you!

Thank you for pointing me to CLR - I will look for some examples as well.

What I need to achieve is to generate Word docx based on MSSQL data, where...

Thank you, Eric

The DB is in AU and only SQL Studio is on my machine, which is in the UK.

Grant Fritchey (2/20/2015)

---

Yeah, the queries run on the server. Filtering, ordering, etc., that are defined within the query, will all be done on the server. Now, once you have the...

Thank you, Grant

Is it correct to assume that SQL Studio will ALWAYS only send a request, e.g. EXEC stored procedure, and receive the result and all the queries and calculations...

SORTED: Security issue - whilst upgrading, for some reason, the DBA has removed the access rights. Sorted now.

Thank you.

Eirikur Eiriksson (10/15/2014)

---

BOR15K (10/15/2014)

---

Apologies for the complete blunt question.

I have created Countries_View and placed the problematic CASE within the view and then JOINT Cities A table with Countries_View B

and all...

Apologies for the complete blunt question.

I have created Countries_View and placed the problematic CASE within the view and then JOINT Cities A table with Countries_View B

and all works like a...