Gazareth Solution Works!

Sorry DWalker, That made no difference.

Almost every entry starts with the word "Select..." What I need is the field word PlanCode to appear before the very first entry of...

Never mind if it is too much work, I figured out by adding 2 more variables. So now my file name has the SERVER_NAME, DB_NAME included as well.

Still I have...

I am not against, but it requires keeping track of parenthesis and commas and syntax.

Instead if you can ( i am not sure at the moment if there was...

Thanks Luis, Works Fine ( See at the very end ) . Instead of replacing HHMMSS, I narrowed it down to replacing only the HH part so the following expression...

Thanks.. I think I can handle from here.. Shall post the solution later..

Thanks a lot , I need some syntax help here ....

The syntax is wrong below,

How would I extract the INITIAL CATALOG and the [Data Source] from the <ConnectString> ...

Question

Consider the segment of xml pasted below

<DataSources>

<DataSource Name="EDW">

<DataSourceReference>EDW</DataSourceReference>

<rd:SecurityType xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">None</rd:SecurityType>

<rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">91905df0-3a05-4d1b-a59b-568a018c7ad1

</rd:DataSourceID>

</DataSource>

</DataSources>

The Query works fine, except i am not getting a value for the <DataSourceReference> ,

So the last item in my SELECT...

All set for now ... Just by adding a line to the where clause I managed to get rid of that error..

WORKS fine.. but I do have...

This seems like a close solution to what I want. However I am getting a syntax error ( listed below ) Can you help me with the syntax.

WITH XMLNAMESPACES( 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'...

Sorry forgot to paste the code in my previous post, so here it is. What I meant was after the word <DataReference>

if object_id('tempdb..#t') is not null DROP TABLE #t;

create table...

Thx but that is not really the challenge...

What I need is an expression that will give me the 3 letters that follow the nth occurrence of the key word if...

Thx Luis

But I had to change it as follows to take care of any string

if object_id('tempdb..#t') is not null DROP TABLE #t;

create table #t( str varchar(4000) );

insert into #t(str)...

Select EXPR(str) FROM #t;

Output should be as follows

1

3

2

3

I mean in each row how many times does the word fox appear ?