Viewing 15 posts - 541 through 555 (of 621 total)
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2007 at 4:22 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2007 at 3:03 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2007 at 2:59 pm
Sergiy (10/24/2007)
Start Profiler and do whatever you do to update the table.See if there are 2 calls instead of 1.
Sergiy, that is freakin awesome! I had no idea what...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2007 at 2:48 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2007 at 2:35 pm
Sergiy (10/24/2007)
Greg Snidow (10/24/2007)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2007 at 2:14 pm
Tomm Carr (10/24/2007)
1 - in this context, "work days" are Monday through Friday, inclusive.
2 - the duration of a work day is immaterial. One...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2007 at 1:51 pm
Rich (10/24/2007)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2007 at 1:39 pm
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
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2007 at 11:55 am
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,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2007 at 11:51 am
Matt Miller (10/24/2007)
Kind of hard to compare the functions prior...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2007 at 11:18 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2007 at 9:19 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 23, 2007 at 2:13 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 23, 2007 at 10:35 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 23, 2007 at 9:25 am
Viewing 15 posts - 541 through 555 (of 621 total)