Viewing 15 posts - 1,051 through 1,065 (of 1,183 total)
This works and it's easier on the eyes (and head)
SELECT
e.employeeID
,StartDate
,VacDays = SUM(CASE WHEN OffDayType = 'V' AND YEAR(DateEarned) = 2007 THEN DaysEarned...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 1, 2007 at 5:37 pm
This hasn't been tested, but should give you what you need.
SELECT
sp.pubcode
,sp.name
,a2.addressline1
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 1, 2007 at 5:11 pm
I'm not the DBA, but I would have been consulted/notified if there were any. This particular server is "mine" and no one touches it but me. The linked server is...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 1, 2007 at 4:52 pm
Man you're good.
The procedure does a select from a linked server into a temp table. I then do another select, joining on the that table.
I think I'm seeing it now....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 1, 2007 at 4:24 pm
INSERT #agingData EXEC dbo.populateAging
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 1, 2007 at 3:22 pm
Sergiy,
That did not make a difference?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 1, 2007 at 7:27 am
Thanks for the info! I REALLY do appreciate it.
Just a note though, ABSOLUTELY nothing has changed with this proc. or table in (at least) three months and it runs weekly,...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 31, 2007 at 9:04 pm
Oh, and do you have any idea what would cause this to "suddenly" start happening?
Could this be one of those intermittent bugs that MS hasn't seen/resolved?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 31, 2007 at 8:23 pm
I was wondering when Sergiy would chime in.....
Thanks, I'll try it tomorrow.
But still one question. Why would moving the insert into the proc work.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 31, 2007 at 8:19 pm
Hi all,
The new article won't be published until early March. But until then you can go here http://www.sqlservercentral.com/columnists/jselburg/2824.asp
Just remember to vote when the article comes out in the newsletter *grin*
Thanks
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 31, 2007 at 6:04 pm
I could/can try that. This is a server used mainly for report subscriptions that run in the early AM, and only limited use during the day.
So you're saying that a...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 31, 2007 at 5:04 pm
I'm still not convinced the plan had anything to do with it.
In my humble understanding, the fact that I could run the procedure by itself fine tells me that...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 31, 2007 at 4:31 pm
OK, this is just too $%@$& weird!!!
Originally I was calling...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 31, 2007 at 3:16 pm
No noticable differences in the plans.
Here's an interesting note. I can run the procedure with "Results to File" then import the data into my table just fine. This is a...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 31, 2007 at 2:36 pm
Nope.
How would that make a difference? I can run the proc alone, then with insert, then alone and the "alone" executions always work fine. Doesn't recompile just for the proc...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 31, 2007 at 11:08 am
Viewing 15 posts - 1,051 through 1,065 (of 1,183 total)