Thank you Lowell. This is very helpful. I am very new with EDI.

Thank you Ron. Here is the EDI 271 File sample: I would truly appreciate if someone can help.

ISA*00* *00* ...

Using .Net app to connect to sql and get the data using store proc, creating excel file in the app and opening the file. There are no problems with this...

The site is used by over 100,000 users. Version of Excel cannot change.

Cannot do that because that will require too many changes in the application.

I am creating and then opening the excel file in MVC application. If the file is not small, then it opens without problems. But if it is small, it errors...

With new security featues of Excel, if an Excel file is small size then one cannot programmatically open the file otherwise it errors out. So if the file size is...

I worked exactly the way I wanted.

Thanks for your time.

Thanks to all

Hi Lovel,

I need the format "4-8 had 5".

Thanks.

Thanks Jeff, it is a good idea to use max for all vars. I will try that.

I am using SQL Server 2008.

Michael is right. The issue is completely because of SSMS limitations. Thanks for your time.

Also, I forgot to mention that it is a dynamic query and here is the SP:

Create PROCEDURE [dbo].[MySP]

(

@OrgId int,

@DivId int = null,

@EmpId nVarChar(MAX) = NULL,

@year int

)

AS

DECLARE @sql...

The closing quote is correct. After the long string, I have a year, '2012' as a variable. If I run the proc as follows then there are no problems:

myproc...