using the select statement you listed and changing it a bit. try this. Since I can only see an example of one record and not the table definition...

When I used to do extracts for third party clients that needed this format we usually used a char(13) return to start the next record in the txt file.

maynor_ramirez (8/9/2011)

---

I have to write a query that will output a ---fixed lenght -- sequential text file? for example I have 100 records (100 rows) and the way client needs...

kwoznica (7/27/2011)

---

Brandie Tarvin (7/27/2011)

---

Could you clarify what you're looking for in the result set. As you can see from the back-n-forth here, we all have different thoughts about what you're...

I believe that the basic problem you are having is in your GROUP BY within the first query. You have the following fields being used in calculations only but...

DECLARE @test1 varchar(50)

,@Test2 varchar(50)

SET

I believe your issue is this statement

exec usp_stored_proc_name V1,v2

You are sending in two variables into the proc you need to bracket them

exec usp_stored_proc_name (V1,v2)

Try and let...

There are many ways you can do this depending on your criteria. If you are assuming a 52 week year the statement above will work. ...

I don't understand why you would even be trying to adjust HL7 messages within SQL. Most Health facilities use an interface engine such as Biztalk or Rhapsody to name...

Don't forget that they way the data is pulled could change any given pattern when there are columns before the search column that may order by a key field. ...

I'm glad it helped. I guess my backwards thinking is a good thing at times.

Also you might want to start with char(32) in case there is a [space] between...

I sent the code via email. For some reason SSC didnt like something within it so I couldnt post it here. Let me know if it works for...

I would check with the developer of the application. Make sure he or she has the connection and the command timeouts set correctly.

Thanks, I will try that. 

try this

 

declare @bigd datetime

declare @d1 datetime

declare @d2 datetime

declare @dc varchar(8)

declare @d2c varchar(8)

set @dc = null

set @d2c = '1/1/2005'

set @d1 = cast( case

          when @dc IS Null THEN  '1/1/3900'

   ...