I've used also:

DECLARE @C varchar(100)

SET @C = '<div>Sunshine</div>'

SELECT SUBSTRING(

@C,

CHARINDEX('>',

Thanks Sean,

this is really helpfull.

However all the specification you gave are very terrifying, i'm only a rookie.

The work i'm in now requires the separation of the data into levels, like...

Thanks!

Based on this query and this example (http://www.sqlservercentral.com/Forums/Topic1416551-391-1.aspx), which only retrieves only four levels:

With MySampleData (AllLevels)

AS

(

SELECT 'Analysis»Letters»Numbers»Detail' UNION ALL

SELECT 'Description»Letters»Numbers»Detail' UNION ALL

SELECT 'Planning»Letters»Symbols»Detail'

)

SELECT

...

Thanks Guys.

Lowell, yes there are more levels indeed.

Regards

I'm creating the query from scratch, can't really expose data.

Can you start based on that? This is mostly a query problem.

AllLevels

Analysis»Letters»Numbers»Detail

Description»Letters»Numbers»Detail

Planning»Letters»Symbols»Detail

Thanks in advance.

Regards

It is possible to add a Group By inside each Select?

If yes how do you do it?

Thanks.

Thanks Very Much! Helped a lot.

Could you geniuses take a look at this topic:

http://www.sqlservercentral.com/Forums/Topic1409896-391-1.aspx

Thanks again.

Best regards

Select whitin Select, in order to group by?

Any solution please, thanks

regards

SQL Newbie here!

Sorry, don't have any data on the table yet, this is a projection of what it will contain.

I apreciate all the help I can get for this query.

thanks

regards

Purchasing these kind of features is not an option. If you find any solution, put it here, thanks.

Regards

Thanks anyway.

You r talking about Aspose.Slides for Reporting Services right?

Thanks

Regards

Very usefull, Thanks!

Regards

THANKS MEN!

I agree with you davos, report prettyness is getting to much in the way.

But we must answer to what orders the client.

Thanks for the reply

Thanks!

Very helpfull!

Regards