Viewing 15 posts - 18,451 through 18,465 (of 26,484 total)
Ian Scarlett (11/6/2009)
That will entitle you (and only you) to install and use as many copies of the software included...
November 6, 2009 at 2:31 pm
Second generic answer, read Books Online.
November 6, 2009 at 12:36 pm
aravind.s (11/5/2009)
Hi.Try this
Select a.col1,a.col2,(select sum(hrs) from table where emp_id <=a.emp_id) ‘col3’
From table a
assuming empid is your key to the table and You want the running total of HRS column.
As Flo...
November 6, 2009 at 12:31 pm
First of all, the clustered index is required for this to work. I also believe that Jeff will tell you to put a TABLOCKX hint on dbo.EmpTime in the...
November 6, 2009 at 12:17 pm
First, watch SSC for Jeff's rewritten article on Running Totals. IIRC, it is coming out on 11/10/2009. It will be extremely enlightening.
With that, here is a another solution...
November 6, 2009 at 12:13 pm
It may help if you provided the entire query not just part of it. Going further, it would help even more if you could provide the DDL (CREATE TABLE...
November 6, 2009 at 9:46 am
Interesting topic. During the luncheon, I am sure they weren't talking about just the computer or information technology fields, correct? Well, how about this, my middle daughter (now...
November 4, 2009 at 9:35 pm
Can you explain in slightly greater detail what you are doing in the package? SSIS is harder to debug since it is difficult to post graphic images to show...
November 4, 2009 at 9:29 pm
MTY-1082557 (11/4/2009)
This is my scenario on the same server right now:
ArchiveDatabase:
Table2008_1
Table2008_2
Table2008_3
Table2008_4
Table2009_1
Table2009_2
Table2009_3
Where each table contains 3 months of data, the _# means...
November 4, 2009 at 5:32 pm
Thanks for the feedback. Now for a little follw-up. Do you understand what that bit of code is doing?
November 4, 2009 at 12:54 pm
A co-worker of mine at a previous employer is so hooked on it the UltraEdit is the first thing he installs on a new computer. He then hacks the...
November 4, 2009 at 12:14 pm
D.Oc (11/4/2009)
And here is Grant 😀
Doesn't get much sun, does he? Wait, except for about an inch or so on each side of my knees my legs are probably...
November 4, 2009 at 12:11 pm
PSB (11/4/2009)
Below is a sample of my query
select Columnnames
from...
November 4, 2009 at 12:07 pm
UltraEdit. I love the column mode. I can also do syntax highlighting in a variety of languages using it.
I actually use UltraEdit Studio, but UltraEdit is still at...
November 4, 2009 at 12:05 pm
Alvin Ramard (11/4/2009)
Take a look at Steve in his kilt:
Cute! I think my kids would disown me if I wore one, especially in public. 😛
I guess i should...
November 4, 2009 at 12:03 pm
Viewing 15 posts - 18,451 through 18,465 (of 26,484 total)