The last table I see is 'sysusers', and it is not in there. The closest I can find is sysxlogins.name, but that has the domain + '\' tacked on...

Also, I see a column in the profiler called 'NTUserName'. Can you tell me what table that is stored in? I have looked in what I thought would...

So, Sergiy, I'm looking at the profiler and I see a button that opens something called 'performance monitor', that seems to be akin to the performance monitor in the task...

Sergiy, that is freakin awesome! I had no idea what...

And the winner is ...

IF OBJECT_ID('TempDB..#Test','u') IS NOT NULL

DROP TABLE #Test

CREATE TABLE #Test

(

ID INT IDENTITY(1,1),

forecast INT,

demand INT

)

INSERT INTO #Test

SELECT 100,99 UNION ALL

SELECT 567,800 UNION...

Sergiy (10/24/2007)

---

Greg Snidow (10/24/2007)

---

... one person came to me to say emails were coming a day late, and another person said they were coming right on time. That is...

Tomm Carr (10/24/2007)

---

Here is what I've come up with.

1 - in this context, "work days" are Monday through Friday, inclusive.

2 - the duration of a work day is immaterial. One...

Rich (10/24/2007)

---

When you are looking to restrict the DISPLAY of the answer, unlike the precision (as you first asked), it would normallly be handled by the front end application that...

This did exactly what I needed

VARIANCE = LEFT(ROUND(SUM(CONVERT(DECIMAL,demand_q))/SUM(CONVERT(DECIMAL,forecast_q)),2),4)

Thanks for the help

Greg

Thanks Rich. That worked, but the result has 6 digits to the left of decimal, where I only want 2. Is there a way to restrict? Also,...

Matt Miller (10/24/2007)

---

Then the req's got a little muddy after that (with making the "count the start date", rolling forward vs rolling backwards)

Kind of hard to compare the functions prior...

I think it would be safe to assume if someone entered once, the exited once, unless they spent the night. Why couldn't there be an update script to set...

Jason, you probably will not be able to "see" most of your files directly on the server using SQL. Unless you have Adobe installed on your machine, for...

I'm glad you got it. I was just about to suggest IF UPDATE(), since I just found out about it here last week. I was also going to suggest...

I have been known, when testing, to end up with the same trigger on the table twice, with different names. Are you sure the trigger is only on the...