Viewing 15 posts - 7,306 through 7,320 (of 59,072 total)
Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys: -1 for unknown,...
April 9, 2020 at 1:11 pm
Thanks. I think they are the same when including spaces. They come from the government as a .dat file and they won't change so I'm stuck with these. I've...
April 9, 2020 at 1:09 pm
SELECT t.userid
,t.rid
,Total = SUM(TRY_CAST(t.value AS INT))
FROM temp t
GROUP BY t.userid
...
April 9, 2020 at 4:18 am
Does it store these states anywhere though?
State is not really a part of the error itself, but extra information that is added when RAISERROR is called that...
April 9, 2020 at 4:15 am
If I chose to save the employee number as a varchar, I could store '' (empty), which I would prefer.
DON'T do it is the correct answer. All columns...
April 9, 2020 at 4:07 am
Well, the big company meeting announcing what changes will be made was held this morning. I will still have a job, but everyone making over 60k is...
April 9, 2020 at 4:02 am
It's interesting. A friend was over last night. He has 400+ reports under him. Had to let 10% go at the beginning of the year. Easy to do. Got...
April 9, 2020 at 4:00 am
>> Employee numbers are not numbers!
Heh... I'll go ahead and disagree with you again, Joe. There's no reason why "identifiers" cannot be numbers.
April 9, 2020 at 3:54 am
Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys: -1 for unknown, -2 for...
April 9, 2020 at 3:50 am
Sorry for my blanket statement about NULLs - EndDate and Payment are good examples of when not to use them.
I am afraid I disagree with you about codes. Sooner...
April 9, 2020 at 3:44 am
Ok... I got cricket's on that question... Here's what I'm talking about...
In the article, it first shows Step 1 as a T-SQL query to get the data "into" the Power...
April 9, 2020 at 1:20 am
Well, the big company meeting announcing what changes will be made was held this morning. I will still have a job, but everyone making over 60k is getting an...
April 8, 2020 at 6:30 pm
Wow. My joke really hit with a thud. I'm surprised no one pulled out the Pork Chop Launcher on me. @=)
Nah... I was too busy laughing with you to...
April 8, 2020 at 6:27 pm
Sensitive data should absolutely not be in use in dev & test servers that means the data needs to me masked in dev?
Yes!
General Data Protection Regulation, California Citizens...
April 8, 2020 at 6:22 pm
No need to pile on for the following but, because of things like this, security breeches in the world just don't surprise me anymore.
How do these people get their...
April 8, 2020 at 5:21 pm
Viewing 15 posts - 7,306 through 7,320 (of 59,072 total)