Viewing 15 posts - 166 through 180 (of 1,353 total)
CREATE TABLE dbo.synonym (synonym VARCHAR(50) NULL, word...
August 15, 2018 at 7:29 am
August 15, 2018 at 7:27 am
I don't know about SSIS
SSIS is very picky. Just about, if not everything, has to be stated explicitly. I'm certain I had to do the CASE statement...
August 14, 2018 at 1:57 pm
If you want to work with your dbo.synonym (instead of nested REPLACEs) you should create a inline table value function, which uses a self referencing CTE.
This...
August 14, 2018 at 7:24 am
August 13, 2018 at 11:19 am
Why did you use a sysname data type in your example? I've used this approach before, but the variables where char or varchar with not too long a length, e.g. @TableName...
August 13, 2018 at 6:22 am
However, in banking processes, I'm a conservative who grips thedepartment's computer manual with whited knuckles. The consequences of errorare so dire, and the complexity is...
August 11, 2018 at 10:11 am
There must be some valid need that overrides the public knowledge rights.
That's quite a wrinkle. Who decides that? I can't imagine what valid need an individual might...
August 9, 2018 at 11:18 am
I've had to deal with this before:
CASE Withdrawal WHEN TRUE THEN 1 ELSE 0 END AS Column_Name
August 7, 2018 at 7:35 am
Oh, I'm not practicing law or offering legal advice.
Didn't think you were. I was talking about DBAs reading the law and then deciding what was appropriate. Reading "Legalese"...
August 6, 2018 at 7:20 am
Having had to read legal stuff from time to time, it's fine to read it. I read SCOTUS decisions, but not as part of my job. There are terms that...
August 5, 2018 at 5:41 pm
August 2, 2018 at 7:27 am
Great point, and yes I will be converting the datetime to an Int and storing a YYYYMMDD integer representation of the date
A smallint is normally sufficient.
August 1, 2018 at 11:21 am
the data warehouse won't grow much
This part doesn't sound correct. I'm a big fan of views in a DW environment. But as the fact table will add a...
July 31, 2018 at 8:52 am
Viewing 15 posts - 166 through 180 (of 1,353 total)