Viewing 15 posts - 40,351 through 40,365 (of 59,072 total)
Jeff Moden (1/2/2010)
I've been "talking" with one of the proprieters of a web site that claims...
I got an update on that today. It turns out they have a...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 3, 2010 at 5:45 pm
David Portas (1/3/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
January 3, 2010 at 5:36 pm
lmu92 (1/1/2010)
Jeff Moden (1/1/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
January 2, 2010 at 11:15 pm
venktsrinivas.gv (1/1/2010)
Pls refer any books with good authour
Already did that... see Books Online. As a side bar, step one on finding the answer to any interview question for DBA's...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 2, 2010 at 11:12 pm
Steve Jones - Editor (1/2/2010)
We have an F# review coming out this week of a book. Looks interesting.
Jeff,
C'mon, make it a resolution. Be good for you to stretch into SSIS,...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 2, 2010 at 10:15 pm
This is more what I'd like to see...
BULK INSERT into staging
validate w/error processing/logging
BULK INSERT into staging
validate w/error processing/logging
BULK INSERT into staging
validate w/error processing/logging
IF no validation failures, merge with final table...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 1, 2010 at 3:02 pm
Thanks for the feedback, Naren... especially about the validation part. I'd hate to see someone get into trouble because of something like rounding.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 1, 2010 at 2:57 pm
chris-736523 (12/31/2009)
...however, it is quite difficult to find a balance between having enough detail and something that a business user can read, understand, and approve.
I resolved that issue...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 1, 2010 at 12:43 pm
Agreed... and thanks for the feedback.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 1, 2010 at 11:58 am
One more thing... rounding can be a real PITA depending on the original datatype... even the CASE method fails if the input is FLOAT because 4.555 comes out to be...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 1, 2010 at 11:42 am
Heh... I'm still concerned because this is for a bank and I apologize for even suggesting the use of STR(). Magoo... I owe you an apology because I forgot...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 1, 2010 at 11:26 am
narensantanam (1/1/2010)
Thanks for your observation on the truncation bit. I believe it should not be a problem as an account with currency as USD should never have a value...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 1, 2010 at 11:03 am
mister.magoo (1/1/2010)
The problem with all of this of course is that you are leaving yourself in the hands of SQL...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 1, 2010 at 10:56 am
Heh... Ok... since everyone is trying to be "clear", let's clear up a couple of other things about CTE's. CTE's work just like views do... if you call a...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 1, 2010 at 10:47 am
You bet. Thanks for the feedback.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 1, 2010 at 1:27 am
Viewing 15 posts - 40,351 through 40,365 (of 59,072 total)