Viewing 15 posts - 7,051 through 7,065 (of 9,715 total)
Steve Jones - SSC Editor (10/27/2010)
October 27, 2010 at 11:13 am
Steve Jones - SSC Editor (10/27/2010)
Whew, for a second I thought I was going to learn something on The Thread.
OMG, someone grab the paramedics. Steve's going into shock because he...
October 27, 2010 at 11:11 am
Read my edit. Your punctuation use (. instead of ?) at the end made it sound like a statement, not a question. I thought you were telling us there were...
October 27, 2010 at 9:06 am
Ivan,
Your post is almost incomprehensible to me. Could you edit out the abbreviations and put real words in their place so I can understand what you're trying to say?
October 27, 2010 at 8:27 am
parthi-1705 (10/27/2010)
Any other 3rd party tool can solve this.
Really? I haven't seen one that doesn't use traces or triggers. Please, tell us what those tools are. I'd like to test...
October 27, 2010 at 8:24 am
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
Viewing 15 posts - 7,051 through 7,065 (of 9,715 total)