Dear Tavis.

my goal is to create word mail merge with T-sql in a store procedure use of creating xml from query result.

is there Easier way to do this if you...

thank you so much for your reply.

you suggest me that create html from query result and It is easier than you think.please guide me how to do it?

thanks for your reply Tevis.please give me a link for more information about Title,Body,Font,Table,etc in xml from sql server.Meanwhile please give me a sample xml with word document style from...

i use this:

alter PROC makeXML

AS

DECLARE @myXml xml,@SQL varchar(max)

SET @myXml = (SELECT QMS_QmsBaseName FROM QMS_QmsBase FOR XML AUTO)

--SET @sql= 'bcp "exec @myXml" QUERY OUT f:\azizi\filename.xml -w -r -t -SNik-Azizi...

thank you for your reply,

i use your note but get the same error:crying:

I fine this procedure for export from sql to word:

create procedure [dbo].[spExportToWord] ( ----------------Exporting from SQL Server to Word

@SourceServer varchar(30)=null,

@SourceUID varchar(30)=null,

@SourcePWD varchar(30)=null,

@SourceDatabase varchar(100)=null,

@QueryText varchar(200),

@ConnectionString varchar(255) =null,

@DocumentFile varchar(100),

@TableFormat varchar(100)='professional',

@tableHeading varchar(7000)=null)

/*

create...

I want to create mail merge document direvtly from sql server with stor procedure.Is it possible?

I mean that how to create Ms word mail merge with store peocedure in sql?not send email from sql server!!!!!!!!

thanks for you reply.but please suggest another way.thanks

thanks alot from you.

I want to have this:

select column1 from table1

column1

a

b

c

and result:a,b,c

and i donot want to use cursor or virtual table.please help me.thanks

yes get command complete succesfully.

but when insert into identity table get error:

An explicit value for the identity column in table 'WOS_WorkOrderType' can only be specified when a column list is...

my error :

An explicit value for the identity column in table 'WOS_WorkOrderType' can only be specified when a column list is used and IDENTITY_INSERT is ON.

and I have only...

my error just is:

An explicit value for the identity column in table 'WOS_WorkOrderType' can only be specified when a column list is used and IDENTITY_INSERT is ON.

sa is db_owner and when I select dbo.ddladmin for my database ,get error:can not use the special principal dbo.

how do i do?