You can't do that directly like that. You could insert the results of your proc to a table variable first though.

declare @MyTable table

(

ValueColumn varchar(20),

...

I assume you are trying to figure out your data structures for this type of thing? Why not take a stab at it yourself and then post your table create...

Try CAST(s.productId AS VARCHAR(10)). The way you had it made it think that CAST is a column in s. Your convert would work the same way.

Yeah just me being dense. 😛 Hope that helps explain it.

OH this is a ddl trigger. You can't add a signature to DDL triggers. http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/1333eecd-4c66-43d4-ab8f-03511cad4174

Not exactly sure what you need but either dateadd or datediff functions should get you what you need. check them out on BOL.

Your syntax looks right. I am guessing that since you are still uncertain about the ability of adding this signature to a trigger that you didn't look at the article...

That sounds like a permission issue. You can add a signature to a trigger. http://msdn.microsoft.com/en-us/library/ms181700.aspx

Sounds like a running total problem. Check out this article from Jeff Moden. http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D Make sure you read all the way and pay close attention to the quirky update method....

Brandie Tarvin (11/7/2011)

---

Sean Lange (11/4/2011)

---

Sounds like you need the cascading delete and an insert trigger on the master. In your trigger just insert into the peer review table the new...

Take a look at this article from Jeff Moden. http://www.sqlservercentral.com/articles/T-SQL/74118/%5B/url%5D

I realize you are not counting but your join is the same concept. It explains why performance gets awful as the...

Cool. Glad you figured it out and thanks for letting us know and welcome!!!

Sounds like you need the cascading delete and an insert trigger on the master. In your trigger just insert into the peer review table the new metric. No need to...

klc0000 (11/4/2011)

---

I'm sorry, first time I've ever posted a help request.

Ok so I have 3 tables:

- a table of employee info (tblEmployee), like ID, firstname, lastname, department, etc.

- a table...

You bored Tom? You keep answering and commenting on qotd from 4 years ago. 😛