The way I usually do this is:

In QA go to Tools, Options, Results tab and set Results output format to Tab delimited.

Then select * from the table you are interested...

Thank you.

here is my statement

INSERT table1 (col1, col2, col3

SELECT col1,col2,col3

FROM rdwMHSmedmas AS l

JOIN table2 x

ON l.clm = x.clm

JOIN table3 AS pl

l.poscod...

There is one more way to do this. After creating a package save it as VB file. It will create a .bas file which you can use in your app.

...

You have to add IUSR_servername as a user to the users group in SQL.

[Thank you. Let's wait until next version rolls out.]

Sorry I agree with GRN and made and error when I posted. My mistake.

"Don't roll your eyes at me. I will tape...

See "User-Defined Functions That Return a table Data Type"...

[Thank you very much.

Liya

]

It's really two ways of doing the same thing. One way or another to open a connection (a connection object in ADO) you have to have...

Thank you.

quote:

---

Could you please help me figure out my problem.

When I login as a sa and set IDENITITY column ON for a table....

quote:

---

In this solution I am assuming everyone has a grade for english

select studentid,class1,grade1,class2,grade2,class3,grade3,class4,grade4 from

(select g1.studentid,g1.class class1,g1.grade grade1,

g2.class class2,g2.grade grade2,g3.class class3,g3.grade grade3,

g4.class class4,g4.grade...

quote:

---

Try this:

print Dateadd(day, -1 * (day(getdate())), getdate())

Unless there's a system proc that does it, I think this is about as clean as...