err, should work... are you sure that the temp table is still created? Are you in the correct database?

follow my template... open the connection at the last second and CLOSE it right after the call is made.

make a new asp file in the same directory, with just the include line and response.write adCmdStoredProc

If that fails then this is your problem, if not then you just found...

Long shot but does this help?

http://www.sqldts.com/default.aspx?254

is the include file working?? that shouldn't fail with that on.

I wasn't seing th eobvious either... well I guess it's one of those days.

So all is fine now?

Dudette, make a new page, or take a old one that worked before you started doing that page and run it. If this one works then the error is...

Hmm.. was wondering what the heck I was missing. I couldn't believe you'd miss a simple exotic join like this.

Glad you figured it out.

That's select into with a stored proc... not select .

Select *

into #T1

from Openrowset('SQLOLEDB','Trusted_connection=yes;Data Source=YOURSERVER','exec sp_who') dt

select * from #T1

drop table #T1

Can you send the sample results for any of the 3 possible values of the parameter? I'm not sure of what you need.

Sorry dudette. That's what I meant, make something small work first, then go takle that monster. I can't make it work for you if I'm not there and...

tell me what day this is :

1981/03/03.

If you can't, that's because dates are confusing (non deterministics) with 2 format exceptions. While I don't remember the 2nd one. ...

Dude, make a new sp with 1 parameter like I already asked you to do.

Take the original code I sent you, MAKE IT WORK WITH THAT SP, then modify this...

Can't you normalize the design??

Patients?

Diagnos?

Diagid

Patientid

then it's a piece of cake to merge those 2.

Yup you have one too much... the script will fail because you haven't set any parameters yet.