quote:

---

declare @Column4 varchar(50), @Column5 varchar(50)

select @Column4 = Column4,

@Column5 = Column5

from MyTable

where id...

I am not quite sure but I will try not to use this technique unless impossible to build a SET BASED solution

I would Follow "Racosta" Suggestion!

Create Separated Text files and all you will have to run is:

Copy /b *.txt AllCombined.asc

How about:

 CREATE TABLE CARS( Manufact int, Model int, Nbr int, Descr varchar(100), Other Varchar(100))

GO



INSERT INTO CARS(Manufact, Model, Nbr, Descr, Other) VALUES(1,1,1,'DESCr1','Other1')

INSERT INTO CARS(Manufact, Model,...

And to make it point to the right .MDW use the Following RegKey to set the Path

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\SystemDB

Me too. Keep up the good job!

over and ... out!

weissa,

The solution for this is a stored Procedure, As jxflagg Suggested

if you plan to retrieve more than 1 Parent Record at time

You will have to use...

weissa,

Can you answer jxflagg Last question?

I have no clue about what are your presentation requeriments and That makes it harder for me so I am guessing now:

Suppose you...

Tools --> Options ---> General Tab--> Query File Directory, Result File Directory, Template File Drirectory

Change and Apply

I agree with you 100% I just said that at THAT moment it was a little too fast to get to any conlusions. If the App can be architected that...

quote:

---

Even if this is best done as two queries, it would probably be better to write it into a stored procedure ...

quote:

---

quote:

---

There is no info as of now!! on how are things implemented (...

quote:

---

The left join query is as follows -- syntax is actually for ODBC MS Access, but logic holds for SQL Server.

For...

quote:

---

Even if this is best done as two queries, it would probably be better to write it into a stored procedure rather...

can you post something about the structure of your tables?

the short answer is I think you are doing the right thing (Formatting is a Front-End task). But I have almost...