Viewing 15 posts - 8,926 through 8,940 (of 9,725 total)
Jeff said:
Ax? Bring it... can be used to make porkchops
Porkchooooopppsss and applesaaaaauuuuce.
Sorry. Had to be said. @=)
March 12, 2008 at 8:30 am
Hmm. I work with one of the authors of that book. I wonder if he has his copy in the office.
Thanks, Lynn. I'll check into that.
March 12, 2008 at 6:52 am
Fortunately, some of my source data is already in SQL Server. Unfortunately, I have to scrub it, merge it with mainframe data and try and pull the unique records...
March 12, 2008 at 5:11 am
You know, someone should mention (for the lurkers), that Jeff actually paid attention to the Corporate Culture before "letting loose". He didn't just do it without having some foresight...
March 12, 2008 at 4:14 am
Jack,
Sort transform? Not sure what you mean by that. I don't see a Sort transform task.
As far as precedence goes, I have my Source (where it requests for...
March 11, 2008 at 7:46 am
TheSQLGuru said:
Brandie, you are totally off the mark. Do whatever you can to make the most money so you can live a better life and do/enjoy the things...
March 7, 2008 at 9:30 am
Roy,
Have you ever thought about talking to your boss about this? Ask him why you've stopped getting recognition?
It could be he has higher expectations of you since that moment...
March 7, 2008 at 8:35 am
BTW, the OP mentioned he applied for this job because he has to pay the mortgage. I notice, however, he didn't mention at all whether or not he's actually...
March 7, 2008 at 7:51 am
Lynn Pettis said:
I just wish the computer would do want I want, not what I tell it to do. It would be sooo much easier.
Amen to that!
I...
March 7, 2008 at 7:31 am
Mark said:
Dear Ms. Gila Monster,
NO, I am not being honest about my lack of knowledge of SQL Server! Think about it!! If my resume is junior level, nobody will even...
March 7, 2008 at 7:17 am
FYI, I know I need to reverse the BeginDate in the above code with the DateAdd. But it was when I got to the AND part of the WHERE...
February 29, 2008 at 12:15 pm
Okay, but we're still running under the assumption that @StartDate and @EndDate are constants set by the coder/end user. What if they're dynamic?
I have a situation where I actually...
February 29, 2008 at 12:13 pm
That's what I'm wondering, Ruben. I asked that in an earlier post and haven't seen a response yet.
I can't think of a good way to optimize that one. ...
February 29, 2008 at 11:11 am
If you want to go with Jeremy's suggestion, you can also throw an index on the Temp table to speed your searching. Though, it might not be worth it.
Regardless,...
February 29, 2008 at 9:00 am
Matt,
You actually have a separate DB to do the scrubbing?
Hmmm. I didn't think about that idea. Originally I was going to use staging tables in the DW, but...
February 29, 2008 at 4:53 am
Viewing 15 posts - 8,926 through 8,940 (of 9,725 total)