Viewing 15 posts - 7,216 through 7,230 (of 18,926 total)
Do as you wish... but there's nothing more I can offer than fix the missing join.
February 1, 2011 at 9:36 am
HowardW (2/1/2011)
Are the below two objects tables or views?:
[tbl_233421d595dc4719b2429d27bf5a0399_\PreparingFactTable\CommissioniPerformance\FactTab][tbl_527741baf48446da94b7e767ed004314_\PreparingFactTable\CommissioniPerformance\FactTab]
Can you post the DDL for these if they're views?
Can't be a table. It has to be a synonym or a...
February 1, 2011 at 9:19 am
We need the basic view definitions as well.
You have 4 very serious warnings about missing join predicates that I'd take care of 1st... that may even fix it for you.
That...
February 1, 2011 at 9:18 am
Doug Lane (2/1/2011)
February 1, 2011 at 8:29 am
What do you mean by different data? Different order in the results (almost certain with parralelism). Or different data altogether?? whereas an except in both directions would...
February 1, 2011 at 8:15 am
everything is possible if you are using read uncommitted or nolock.
Also, no insult intended, it's possible you are running this on prod server and that the data changes between runs.
You...
February 1, 2011 at 8:11 am
Stefan Krzywicki (2/1/2011)
Brandie Tarvin (2/1/2011)
CELKO (1/31/2011)
Actually, INSERT and UPDATE are single table operations, while MERGE requires a source and target.
I haven't moved up to SQL 2k8 yet, so haven't...
February 1, 2011 at 7:49 am
Then I think you have to do either or...
You can add a subcription on the report and have it sent to you. But the report has to deployed before...
February 1, 2011 at 6:31 am
There'sa way to script that and I guess it could be scheduled.
Why do you need to do it like that?
February 1, 2011 at 6:16 am
Another [drastic] option might be to ask for another consultant form the vendor's firm stating that you don't see eye to eye (try finding a good way to put this......
January 31, 2011 at 12:10 pm
theBorch (1/31/2011)
Yeah, at first we tried to be very accommodating, but would prefer an honest "I don't know" over a reasonless "just give me access"
The hard...
January 31, 2011 at 11:47 am
theBorch (1/31/2011)
@SSCommittedThanks for the reply Steve, that is the line of thinking I was on too, dbo access with a temp account and a time frame.
dbo is even better than...
January 31, 2011 at 11:42 am
I would still hear his side of the story.
It's possible that sa rights are required to install the packages (yes I know bad practice). In THAT case, have someone...
January 31, 2011 at 11:35 am
Viewing 15 posts - 7,216 through 7,230 (of 18,926 total)