Just run the proc you just created (into a recordset)

in you don't have any records, check the errors collection for your messages, they should be there. Then you'll simply...

I already answered that question for you.

BTW, what do you mean by show?

Do you want to have a messagebox? an html (asp, aspx) file? a form?

Create an access data project. It'll use sqlserver to store the data. But you'll be able to access it as if it were residing in access.

What's the task...

I think that the prints are returned as error messages in .net. But I'm not sure of that.

I agree that it would be best to fix the dll than...

What part are you not understanding??

And I'll need to full table definition (with index, keys and constraints)

This is as nice exemple where there's no need to beat around the bush.

Declare @Total as int

set @Total = (Select count(*) from dbo.Hit_Tracker)

SELECT Keyword, SearchEngine, SourceString, Count(*) As NumLeads, @Total...

Ya.. forgot to ask if they wanted only the new data.. or the updated data as well.???

This may sound harsh, but

1 - Kill the excel developper (sorry but he simply doesn't know what he's doing)

2 - can you show us what the excel sheet looks like??

Maybe...

can you post the select statement you use now and the table definition. Maybe we'll figure something out.

SET NOCOUNT on would surely help for print statements.. but you'd still have to know in which sp to put it.

Can you fire up the profiler and run the page(s)...

CREATE Trigger Temptrigger

On Temp

FOR Insert

As

set nocount on

Insert into Temp1 (Temp1_Id,Temp1_Nm) Select Temp_Id, TempName from Inserted

End

You can't hide it without causing the dll to fail...

You could try to rename the sps to see what happens.

You could modify the select statements and add a Where 1...

This design is flawed, you must assign a primary key to each table and join using those keys, this problem can no be solved (easyly) with TSQL. You'll have...

First of all, this trigger assume that you have only 1 line in each update.

2nd of all, in the instead of trigger, the data IS NOT inserted in the table....

It'll work in this case but I'm not sure it'll solve your problem :

Select min(col1) as C1, min(col2) as C2, min(col3) as C3, min(col4) AS C4, min(Col5) AS C5,...