Viewing 15 posts - 18,451 through 18,465 (of 26,489 total)
Just took a cursory look at DPM. I'm going to have to look at it further and see what it can and can't do. May actually be worth...
November 6, 2009 at 3:45 pm
s_shah-977123 (11/6/2009)
This has probably been asked several times before, I have been using MS Access previously but now moving to SQL, my server has SQL 2005 workgroup edition installed.
- Is...
November 6, 2009 at 3:41 pm
Based on your post? No. Not enough information to be of real help. It would help to see the DDL for the view and the underlying tables....
November 6, 2009 at 3:37 pm
Ian Scarlett (11/6/2009)
Lynn Pettis (11/6/2009)
I thought there was a limit of 10 systems (computers).
I don't think there is, Lynn... this is from the MSDN site
MSDN subscriptions are licensed on a...
November 6, 2009 at 3:30 pm
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
Viewing 15 posts - 18,451 through 18,465 (of 26,489 total)