I'm assuming that's what the poor specialist would be doing...cursing...a LOT....:w00t:

Hey -...

Of all the problems you could possibly have - picking the wrong date range on the the verification is the easiest one to fix....:D All I can say is...

It's late on a thursday before a holiday, so I had...

SQL Profiler will capture the info if you use the stored proc sp* events. If will show you what is being fired....

The CASE statement needs to be able to consistently return a single data type (so all of the "then's" are getting cast to a single datatype). In this case...

Jim - that trigger is working. It's just not doing what you want of it.... you're looking for some kind of runing total, and that syntax ain't going...

The OP mentioned that the DAY column is the clustered index key. Assuming that's the case - there's not going to be a table scan, but a clustered index SEEK....

Rod at work (7/3/2008)

---

You're right, I did forget to mention the data types. In the MoneyPools table both the AnnualAllocation and the RemainingValue columns are of type money.

In the...

Assume you had the following

Employee table

employeeID Title

1 boss

2 ...

GSquared (7/3/2008)

---

Didn't say...

sead.j (7/3/2008)

---

I didn't look details, but now I see that your code is (almost) the same - just remove '@' before Employees and Orders.. that's all...

BTW. Now I'm breaking my...

andy.gray (7/3/2008)

---

Hi guys, thanks for the prompt replies.

I understand your concerns about performance but I do need to do a lot of string manipulation. I'm trying to work around a...

You have to build the entire string in a variable FIRST, then issue the exec on the variable.

Something like:

DECLARE @FirmCode as varchar(5)

SET @FirmCode = 'File1'

declare @sql as varchar(500)

set @sql =...

Just curious - what made you go for a CLR trigger instead of a T-SQL one? This would be a whole lot more straightforward if the process stayed in...

rbarryyoung (7/3/2008)

---

Woo-Hoo! Way to go Gail! :w00t:

What an excellent choice by Microsoft. What really strike me about Gail is the incredible precision and accuracy of her responses. Despite...