Viewing 15 posts - 7,066 through 7,080 (of 9,725 total)
Maina-456685, Could you provide sample data so Chris and I can verify solutions before we post them?
October 27, 2010 at 7:44 am
I'm fairly certain you don't need the GROUP BY and HAVING on the Contract insert. Test it to verify, but everything after the c.CellphoneNo IS NULL should be able to...
October 27, 2010 at 7:42 am
Stefan Krzywicki (10/27/2010)
Interesting, I'll have to look into what the formatting numbers at the end do to the dates. Thanks
Look up Convert, the Transact-SQL reference, in Books Online. Halfway down...
October 27, 2010 at 7:28 am
Grant Fritchey (10/27/2010)
To the Threadizens/Threadites/Threadoids/Threadopians:
Wow, Grant. What a way to make the Threadophiles feel unwanted...
@=)
October 27, 2010 at 6:40 am
WayneS (10/26/2010)
October 27, 2010 at 5:42 am
I prefer Convert() over Cast() because I can do string tricks with my GETDATE() and still take it back to a valid datetime value. I'm not sure if you can...
October 27, 2010 at 5:34 am
I just noticed another problem. At no time in this scenario, Maina-456685, are you actually checking dbo.Contract for duplicates. You only ever check your staging table, dbo.TempCustomer for duplicates.
So what...
October 27, 2010 at 5:24 am
Ah. I did not catch that fact. Chris, you are correct. So even if the ContractAuditID problem is corrected, the code will still fail.
October 27, 2010 at 5:21 am
A few minor nitpicks that might not matter in your current environment but could cause problems for you later. (FYI: Grain of salt moment. These just happen to be two...
October 27, 2010 at 4:37 am
Maina-456685 (10/27/2010)
....
Condition 3: If an entry is not duplicated in TempCustomer, but already exists in Contact,...
October 27, 2010 at 4:26 am
Dread,
Glad your problem is resolved and thank you for posting your solution.
If you ever do remember the forum name or the forum thread, please make sure to link it...
October 26, 2010 at 11:25 am
Michael Valentine Jones (10/26/2010)
Make sure you follow that code the way I posted it
Yeah, my edit must have crossed your posting.
October 26, 2010 at 10:17 am
Michael,
EDIT again: I take back everything I just said. I forgot to re-login. Crap. What was MS thinking when they did this?
I just tested impersonate. You're working off an invalid...
October 26, 2010 at 9:59 am
I'll double-check the impersonate, but when I logged in as the SecurityAdmin account, I was unable to grant actual SysAdmin to my own account.
October 26, 2010 at 9:56 am
Viewing 15 posts - 7,066 through 7,080 (of 9,725 total)