Viewing 15 posts - 436 through 450 (of 1,353 total)
What do you mean by unpredictable results if you mix calendar hierarchies? Blank? #ERR? I can't think of a reason these would be mixed either, but I...
October 11, 2016 at 9:16 am
It is solved.
Not sure what you mean by "I the problem", but if there's a solution that would be useful to others, please post the solution to this thread so...
October 10, 2016 at 5:51 am
If not you could add your own line item number within the group -->(date, customer, product, orderNumber, lineItem) as your key. Maybe you can even populate a calculated field to...
October 3, 2016 at 1:12 pm
would this not cause errors if the integer range is exceeded
It would, which is why I said if the bigint wasn't really needed. I've seen too many developers "max...
October 3, 2016 at 8:48 am
I forgot to mention that I have GUIDs in the source database that I bring into but store in a separate table so that they are not part of the...
October 3, 2016 at 7:58 am
I want to try and avoid bringing in the unique id from the sales line table (they are bigints and would be useless in the model
I would almost certainly...
October 3, 2016 at 7:46 am
I would also go with the staging table having something like varchar(255) for all
I would use an nvarchar(255) in the landing tables. I may cast it in the...
September 28, 2016 at 2:46 pm
I have several dozen csv files where the data quality is poor, so is difficult to load directly into the SQL Server 2012.
I have trouble imaging this, and certainly to...
September 28, 2016 at 7:55 am
I can query, join filters but how do I get my T-sql skills to a developer\Report writer level.
Solve the actual problems in your company. In a few years, if...
September 28, 2016 at 7:51 am
My approach would normally be to use a Type 6 SCD with both the surrogate and the natural key in the fact table which covers (almost) all schenarios.
It seems to...
September 26, 2016 at 7:30 am
What's the benefit of using integers in that context versus just using dates? For example, is there performance gains? Isn't date datatypes less bytes than int for one good reference?...
September 13, 2016 at 7:37 am
[p]if you don't have any code that you can look back at and realize it could have been done much better, it probably means that you're not learning anything. [/p]
That's...
September 12, 2016 at 2:29 pm
Without a doubt at least part of the solution will be a fact table that has both the order date and dispatch date in the same row. This is...
September 12, 2016 at 1:13 pm
Oh, and Ron: You are right in general, and in my specific case as well because I am indeed not a native English speaker, but in this case the problem...
September 12, 2016 at 9:37 am
That isn't actually what you *said*, though? You said that a (well written) cursor will never, ever beat a WHILE loop, which implies the WHILE is faster?
We all need...
September 12, 2016 at 8:17 am
Viewing 15 posts - 436 through 450 (of 1,353 total)