Nowhere in the code do you have a reference in a FROM clause to the KBAdminTemp.dbo.mstStores table so SQL cannot identify it. You either need to put the table...

Do you have a dataset? Does the query return data at any other time? Have you populated the detail rows with fields from the dataset?

I don't understand your question. Do you want to insert data from the 2 tables into a 3rd table or are you just selecting from the 2 tables? ...

Sergiy (10/7/2008)

---

Guys, I believe it's a good case when simple example would worth more than hours of reading.

Now for OP.

This is how your trigger FOR INSERT should look like:

Update ...

Dave (10/7/2008)

---

J (10/7/2008)

---

But where do you draw the line? In the early 1980s I worked at a software house that sold a package for medical billing and insurance claims....

You could try loading the files into a table and replay the trace from the table.

User mapping in the database is based on uid not the name so you should not get the same uid on a new server. You can use sp_change_users_login to...

Dave (10/7/2008)

---

It's been my experience that most "strategic" decisions are...

I think Lynn probably has an answer that works, so I'll just say that I'm glad the trigger will is written to handle sets. That's rare in these forums,...

Yelena,

Thanks for the link.

I'm not sure what you mean when you...

It's part of the SQL Server 2005 install. I can't remember the exact part you need to install, but it is part of Client Tools and Utilities.

dr_csharp (10/7/2008)

---

Jeff Moden (10/7/2008)

---

dr_csharp (10/7/2008)

---

thanks jack . i do this :

CREATE TRIGGER test ON CallRecorder

FOR INSERT

AS

DECLARE @RecId INT;

DECLARE @BeginTime NVARCHAR(8);

SELECT @RecId=RecId,@BeginTime=BeginTime FROM Inserted

set @BeginTime=substring(@BeginTime,1,3);

Update CallRecorder

...

Here is how I think I'd solve the problem, but without some data I can't guarantee accuracy:

[font="Courier New"];WITH cteUserTargets AS

   (

   SELECT

       U.userid,

       U.username + ' ' + u.surname AS...

Why won't DateAdd(Minute, 3, getdate()) work?

You cannot select from a stored procedure. If you need to query data from a stored procedure you need to insert the results of the stored procedure into a...