Viewing 15 posts - 16,996 through 17,010 (of 18,926 total)
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...
June 10, 2005 at 9:58 am
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?
June 10, 2005 at 9:52 am
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...
June 10, 2005 at 9:51 am
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...
June 10, 2005 at 9:48 am
What part are you not understanding??
And I'll need to full table definition (with index, keys and constraints)
June 10, 2005 at 9:47 am
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...
June 10, 2005 at 9:46 am
Ya.. forgot to ask if they wanted only the new data.. or the updated data as well.???
June 10, 2005 at 9:39 am
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...
June 10, 2005 at 9:38 am
can you post the select statement you use now and the table definition. Maybe we'll figure something out.
June 10, 2005 at 9:34 am
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)...
June 10, 2005 at 9:32 am
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
June 10, 2005 at 9:30 am
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...
June 10, 2005 at 9:13 am
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...
June 10, 2005 at 9:11 am
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....
June 10, 2005 at 9:06 am
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,...
June 10, 2005 at 8:59 am
Viewing 15 posts - 16,996 through 17,010 (of 18,926 total)