Viewing 15 posts - 16 through 30 (of 44 total)
K, it's somewhere in this thread a few back, but here is my expected results, again :unsure:
# of Tasks(Count) Week(No?) Year Wk_Begin Wk_End
----------------------------------------------------------
240 ...
June 1, 2011 at 11:57 am
I do appreciate your reply LutzM. Close, but not exactly. The missing element is the week period PeriodBegin AND PeriodEnd. Let me try to further explain. ...
June 1, 2011 at 11:47 am
Ok, todd - do my best to oblige. Thx
CREATE TABLE [Tasks](
[task_name] [nvarchar](30) NULL,
...
June 1, 2011 at 10:54 am
Wow. A lot of criticism, not a lotta help :w00t: I'm sorry if I'm not explaining it right. Right now don't have access to what the results...
June 1, 2011 at 9:22 am
It doesn't matter when the period starts, part of the code calculates that based on the date in the table. So, for ex, if its 6/1/2010, the period will...
June 1, 2011 at 8:03 am
I tried that before, but only got one "SHIFT". I was doing it on a test, and realized my data was messed up. BUT, THAT'S IT! THANKS!.
Only thing...
May 20, 2011 at 2:53 pm
Wes, the script is interesting. I'm trying this, but not working:
Select COUNT(Tickets),
CASE WHEN DATEPART(hour,(CrDate)) between 0 AND 8 THEN 'SHIFT 1'
WHEN DATEPART(hour,(CrDate)) between...
May 20, 2011 at 2:40 pm
No, I am totally open to using datepart. Show me how.
In my ex, I do get shift. (by name if not time)
Please advise
May 20, 2011 at 10:19 am
If I was sure how to go about this, I would have posted my code. I don't have any b/c I need help. I figured this is a...
May 20, 2011 at 9:55 am
Just wanted to follow-up to follow-uppers....thanks for your replies. 3rd times a charm after 2 rebuilds. Not sure if it made the difference, but I instructed the sysadmins...
June 21, 2010 at 2:54 pm
No one has done this before?:hehe:
May 6, 2009 at 8:28 am
Excellent article! I think it's really interesting to learn about our fellow DBA's and how they cracked into the industry.
Can't wait for Part II!
April 9, 2009 at 7:56 am
Ok, thx Phil. I understand that.
That's what I was asking: How to enforce integrity and migrate the keys....Import/Export doesn't have this, but need to go into the...
April 6, 2009 at 8:56 am
I can't tell you how much your reply helps! It must have taken you an awful long time to put together such an insightful answer. I'm not...
April 3, 2009 at 8:17 am
Task CompensatingSql failed is what I see now. Everything is under Control Flow -no data flow components.
I'm getting the rope ready, as I cannot get this to work no...
March 31, 2009 at 2:01 pm
Viewing 15 posts - 16 through 30 (of 44 total)