Viewing 15 posts - 61 through 75 (of 93 total)
All of the guys in our data department are "switch hitters." Two of the guys are stronger in Oracle, and one (the manager) is stronger in MSSQL, but they...
March 14, 2012 at 6:41 am
nscott 48570 (2/21/2012)If bmovedout is null, it is unknown (and therefore not true)?
The key point to help you understand what's going on is to know what NULL actually represents. ...
February 23, 2012 at 9:59 am
There's also an opportunity for the "do it once, do it right" approach that non-IT people have no regard for. As I was reading all the posts, I kept...
February 16, 2012 at 10:06 am
So are you saying that you can, either manually or with a desktop app like CuteFTP, connect to the AS400 in question and download the file to your PC, but...
February 8, 2012 at 6:27 am
Not wanting to add just a "me too!" response, but I agree with those who said that the system wouldn't be used correctly by the companies who need it most....
January 30, 2012 at 9:57 am
Anyone else notice that the interviewer's hair and goatee change from pane to pane? Is the artist anti hair or is Derek's responses causing physiological changes? 😀
January 3, 2012 at 12:08 pm
Also, if it's a commercial application (that's been running for years) then the developers of the app are probably enforcing the uniqueness and search/retrieval commands in code. I've seen...
December 21, 2011 at 6:39 am
First of all, you should read some of the many posts where people ask for DDL and sample data. We don't understand your structure and what you're expecting to...
December 13, 2011 at 6:33 am
You'll have to dig a bit then. Sign up on BOB and start reading the BODI documentation.
December 12, 2011 at 9:56 am
Was this a one-time import through DI? If not, why not use the data quality transform in DI to do the manipulation you need as it's being moved into...
December 9, 2011 at 6:15 am
"No other information about the table (DDL) is provided." Why? Don't you have access to the table to determine the structure (as Sami hinted at)? Is this...
November 18, 2011 at 7:39 am
If it's going to be generic "stuff" that's not necessarily related to the other objects in there, does it really matter what you call it? Call it Spanky or...
October 28, 2011 at 10:15 am
ProjectDirections should also be a separate table. Something like this (that'll drive JC crazy...):
CREATE TABLE #ProjectDirections (
ProjectID INT IDENTITY (1,1)
,...
October 28, 2011 at 10:09 am
Still kinda vague what you're asking for. You mean that you want counts for EACH column in the table (and not "one column")? In your example, why do...
October 26, 2011 at 6:06 am
Not sure what you mean by "masking", but at one place I worked we had an "anonymity" app (VB/CLR, if I remember correctly) into which we passed a table name...
October 13, 2011 at 7:45 am
Viewing 15 posts - 61 through 75 (of 93 total)