Thanks for the quick reply

But how do I assign one a value and one a label ?

I have it setup to get avalable values from a query via dataset2 example:...

thanks for getting back...

so on table assessment there is a field called assessment_nodes and has the values like

(@@)@@/1/140/@@/1/2/3/84/6/11/12/82/7/28/@@/1/2/3/84/6/11/12/82/7/28/76/@@/1/2/3/84/6/11/12/82/7/28/76/77/@@

representing a path of a tree where assesements are

each last set on numbers...

BTW: Wilson query is just a test 🙂

Thanks for the info ,

It is now working using

declare @sql varchar(255)

set @sql='bcp "SELECT lname as last, fname as first FROM DB.client where LName = ''wilson'' FOR XML PATH(''REFERRAL''), root(''CLUB''),type" queryout...

Sorry for being vague..

I want to sched this to run daily once and keep thirty days

Thanks

Thanks for all the Help,

I do have more one question...

Is there a command to write the same file to a drive?

This is now working ... Thanks!!

DECLARE @OUTPUT xml

SET...

So I found out that I needed

, TYPE on The @QUERY

EXEC msdb.dbo.sp_send_dbmail

@QUERY= 'SET NOCOUNT ON SELECT lname as last, fname as first FROM dbo.client where LName = ''wilson''...

Now that I can spell correctly, it is running... Thank you

Of Course I have another problems with the out put but will start a new thread..

Thanks Again

Thanks for the info so now I have this

EXEC msdb.dbo.sp_send_dbmail

@profile_name='DBMail',

@recipients = 'mygmail@gmail.com',

@query = 'select FName as first,

LName as...

Can I Rename the <Detail> section?

Thanks

Thanks for getting back ,

so something like this ?

EXEC msdb.dbo.sp_send_dbmail

@recipients = 'me@email.org',

@query = 'select FName as first,

LName as last

from client where LName = ''wilson''...

Thanks Ray...

I feel dumb.. I never use the property window........

I'm going to be back with more dumb questions about this.... soon

While I'm here is there a way to surpress the...

I don't seem to have that option...

I RC > report Properties .. I have PAge Setup, Code References and Variables

Hi Ray

Sorry I really didn't work it correctly

What I really want is just the data on the output

with tags

<name>joe</name>

with no other stuff.......

If I could get it vertical even better(I Think)...

Now that you actually typed it out, I'm probably over thinking it....

I''m thinking in the millisecond between getting the data and emailing the report sqlserver goes down...lol

and in reality if...