Hi there,

Could you give us the structure of your table please.

thanks

Chris

HI There,

You can't "Select * from"  nvarchar.

You need to use a table or table variable.

What is it that you are trying to do?

HI There,

That is very strange.

Here is the script I used to replicate the problem.

The trigger fire 100% every time.

--CERATE TABLES FOR TESTING

CREATE TABLE log_authors

      (au_id INT );

Hi,

Please could you send the logic in your Trigger so that we can see if there is something wrong there.

Thanks

Chris

Hi,

Depends what your Procedure is actually doing?

Are tyou saying that you run a proc that does something on a table and that table has insert/update and delete triggers on it?

Thanks

Chris

Hi Sam,

Try this...

SELECT

CONVERT(DATETIME,@latestUpdate,103)

Thanks

Chris

HI Nick,

Make sure that you cast Field2 to a varchar before trying to concatenate the fields.

If both vars are varchars at the point on concatenating then it will def work.

Thanks

Chris

Hi Mark

You can put a clustered Primary key on a table variable.

I would suggest testing with both a table variable with indexes and a temp table with indexes.

Let me know...

HI Nick,

What are the data types of your fields?

If they are both INT's then if you cast both of them to VARCHAR it should work 100%

Thanks

Chris

Hi Mark,

Have you tried putting indexes on your tables?

Thanks

Chris

Hi Jeff,

Wow that is a really good way of doing it.

I like you code it very nice and neat and easy to ready 🙂

I'll be using this in the future...

Is this an exam question?

I suggest you create the table and insert that many rows into it and give it a test.

Thanks

Chris

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a54f7373-b247-4d61-8fb8-7f2ec7a8d0a4.htm

Hi Marc,

Not sure if this is the best method.

It uses what some people call a magic numbers table.

My example does this for a single string value so if you put...

HI There,

Another way to work is have the results displyed in there own screen.

Click on the Query file opion -> Query Options -> Results -> on this screen there is...