Viewing 15 posts - 1 through 15 (of 1,311 total)
Completely agree with the consistency argument. I've seen inconsistency within even the same stored procedure written by a single person. I also like the single letter table. I've rarely run...
April 28, 2020 at 11:50 am
No doubt. But the EOMONTH function could have been introduced with the presented one as an alternative.
February 27, 2020 at 5:00 pm
You would be in the best position to make the justification by learning what are the new features and then seeing if you can make a business case for why...
February 27, 2020 at 1:30 pm
There is an EOMONTH function to get you the end of the month.
February 27, 2020 at 1:23 pm
I have a good idea of what I don't know by reading SSC. There are things I know well, things I know well enough, things I should know better, and...
January 21, 2020 at 1:46 pm
Call your Time_Dimension Date_Dimension instead. Kimball called this time in his first edition book, but revised it to Date by the second edition. Eventually you may have a need for...
January 10, 2020 at 3:15 pm
As the question says that you live in Colorado, "Mountain Standard Time" is the best possible answer. It's right all the time, as opposed to "US Mountain Standard Time", which...
December 27, 2019 at 6:28 pm
This actually isn't quite right unless you are living in Arizona. But I think you live in Colorado. In that case, the proper time zone is "Mountain Standard Time". What...
December 24, 2019 at 1:27 pm
Agreed. Thanks for clarifying. My use of the terminology was imprecise. I'll correct the answer later.
November 26, 2019 at 2:40 pm
Just to elaborate, if you set up the other packages to run within a master package, you can then pass the variables that way. If you're using SQL Server 2012...
November 26, 2019 at 1:51 pm
I would suggest that you bring all the records added or modified since the last run and then load the changes/additions from there. I would also suggest you avoid a...
October 30, 2019 at 1:38 pm
There's not a lot of information here. But my first thought is to set up a cross reference fact table at the granularity of customer location and store location with...
September 17, 2019 at 1:10 pm
There are no sour grapes at all. You all really need to learn that you should attack ideas and not people. However, in the interest of clarification: Gail, you hypothesized “You...
September 12, 2019 at 12:52 am
she then concludes that these results should all but put the nail in the coffin on integers vs naturals keys. This is NOT a valid conclusion to...
September 11, 2019 at 6:08 pm
Viewing 15 posts - 1 through 15 (of 1,311 total)