Try something like this. It will obviously have to be adjusted for your exact requirements.

select 'CREATE TRIGGER trg' + st.name + '_AfterInsert' + '-- the rest of your trigger code'...

Greg J (6/16/2010)

---

anybody got a link they could post? How do I obtain the media? Will the same install key work? can I have them send the...

research-1077696 (6/16/2010)

---

I have two tables where I want to link the tables in effectively a one to one relationship.

Table 1

CustID (PK, nchar(9), Not Null)

Cname(nvarchar(75),Not Null)

Table 2

CTEID(PK, int, Not Null)...

2Tall (6/16/2010)

---

I am attempting to write a nested IIF. The second IIF generates a syntax error.

=IIF(SUM(Fields!DemandMinutes.Value + Fields!TimeBooked.Value) >= Fields!ActivityCentreCapacity.Value,0,IIF(SUM(Fields!DemandMinutes.Value - Fields!TimeBooked.Value) / (Fields!ActivityCentreCapacity.Value) *100)<0,0,SUM(Fields!DemandMinutes.Value - Fields!TimeBooked.Value) / (Fields!ActivityCentreCapacity.Value)*100) &...

In the object explorer window, right-click the server and select "Facets".

Sorry Gaby, but I just have to ask... would that be enough? :w00t::-P;-)

scott.pletcher (6/16/2010)

---

WHERE date_col1 >= DATEADD(DAY, DATEDIFF(DAY, 0, date_col2), 0)

AND date_col1 < DATEADD(DAY, DATEDIFF(DAY, 0, date_col2) + 1, 0)

Or:

WHERE date_col1 BETWEEN DATEADD(DAY, DATEDIFF(DAY, 0, date_col2), 0) AND DATEADD(MS, -3, DATEADD(DAY, DATEDIFF(DAY,...

GilaMonster (6/16/2010)

---

Both temp tables and table variables are allocated space in TempDB. They are both preferentially kept in memory and only spilt to disk in case of memory pressure. It...

I'd also suggest reading the first link in my signature for a better way of posting your data... a way that will get people to actually help you out, since...

miss.delinda (6/15/2010)

---

My question is

1. How can I prevent others transaction changing the particular value in @SysRunno untill my transaction is finish?

2. This prevention is VERY IMPORTANT to make sure, there's...

ahmet erispaha (6/15/2010)

---

Hello,

I have a SQLServer database on a web server and would like to INSERT data from a .csv or .xls file. I just learned about the BULK...

gmamata7 (6/15/2010)

---

If we perform in-place upgrade from clustered SQL Server 2005 to 2008 with NOT having same features installed on all clustered node, then will the in-place upgrade continuous with...

You only need the client tools and SSIS on the passive node if, and only if, you think you might want to use them when the cluster has failed over...

Did you look at BOL? Specifically, read the section "Using EXECUTE with a Character String".

I think that this link would help you out.