Search results for query: *

Hi, Here's the way to write to a file from stored proc: Make sure your are having Service Pack 2 or higher installed. CREATE PROCEDURE usp_WriteToFile( @FileName varchar(255), @Text1 varchar(255) ) AS BEGIN DECLARE @FS int, @OLEResult int, @FileID int EXECUTE...

Hi, Also try adding incident_id to the reporter element as it will help you associate a reporter to incident. Here's the sample: declare @XmlHandle int declare @incident table ( inc_id int, inc_name varchar(25) ) declare @report table ( inc_id int, rep_id int, rep_name varchar(25)...

Hi, try this procedure CREATE PROCEDURE dbo.usp_get_service_pack_info AS /********************************************************************************************************************************************************* ** dbo.usp_get_service_pack_info ** ** Description: This Procedure...

Hi, When creating table try prefixing the owner name before the table. For ex: create table dbo.table1 create table sunny.table2 etc., Hope this helps. Thanks, Vaiyapuri Subramanian

Hi, Try the following: declare @XmlHandle int declare @MyTable TABLE ( prequal_id bigint NOT NULL , loan_term_type varchar (15) NOT NULL , borrower_credit_type varchar (30) NOT NULL , loan_rate varchar(6) NOT NULL ) EXEC sp_xml_preparedocument @XmlHandle...