Viewing 7 posts - 91 through 98 (of 98 total)
Do you want table 1 to end up exactly matching the contents of table 2?
If so you want to update the existing row then do an insert selecting matching rCde,...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
February 14, 2009 at 5:02 pm
Yeah, they are from totally different parts of a query. DISTINCT is part of the select clause and IN part of the where clause.
Some performance points though could be...
If you...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
February 14, 2009 at 3:56 pm
After much thinking I pondered the possibility it was a corruption in the encryption keys. The symmetric keys for reporting services had become corrupt after a power outage some time...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
February 11, 2009 at 1:13 pm
It was working for a long while.
SSIS back end functionality is present in workgroup. What is not present is the custom package management tools. Maint tasks and manual imports are...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
February 10, 2009 at 10:25 am
Do you have a table structure sample? Is there a unique ID on the main table? Is this sql 2k or higher?
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
February 8, 2009 at 3:00 pm
It's Friday I can't be bothered with real work so i thought I'd give this a few minutes. the ROW_NUMBER stuff is one of the most useful things I have...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
February 6, 2009 at 6:58 am
I am having the same issue. I used to have a working maintenance plan but it started failing ages ago. I have been a tad lax in looking at it...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
December 9, 2008 at 8:34 am
Viewing 7 posts - 91 through 98 (of 98 total)