144 reputation
7
bio website
location
age
visits member for 2 years, 5 months
seen Jul 7 at 17:08

I like to code.


Apr
21
awarded  Popular Question
Nov
15
awarded  Popular Question
Jul
18
awarded  Popular Question
Sep
28
accepted Who changed/modified stored procedure in SSMS 2005 or 2008?
Sep
27
comment Who changed/modified stored procedure in SSMS 2005 or 2008?
Thanks Martin, I am not very versed in this arena, I had read something of that sort but wasn't sure if it was true.
Sep
27
comment Who changed/modified stored procedure in SSMS 2005 or 2008?
Yes this is very similar to that question, I didn't see that one, my problem unfortunately continues as you can see in my original question I have already tried the most highly voted answer of that question.
Sep
27
comment Who changed/modified stored procedure in SSMS 2005 or 2008?
Definitely a plus one for solving the problem in the future many thanks Max.
Sep
27
revised Who changed/modified stored procedure in SSMS 2005 or 2008?
deleted 1 characters in body
Sep
27
asked Who changed/modified stored procedure in SSMS 2005 or 2008?
May
25
comment SSAS -> New cube contains two fact tables. How do I relate these so I can use measures from both at the same time?
Thanks Gonsalu.
May
25
accepted SSAS -> New cube contains two fact tables. How do I relate these so I can use measures from both at the same time?
May
23
asked SSAS -> New cube contains two fact tables. How do I relate these so I can use measures from both at the same time?
May
1
awarded  Editor
May
1
revised SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?
Adding data example
May
1
awarded  Supporter
May
1
awarded  Scholar
May
1
accepted SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?
May
1
comment SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?
I will let you know how this turns out thanks for all the information.
May
1
comment SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?
I uploaded an image of a data example, just to make sure you understood what a record of data looked like for this dimension. After seeing this, do you still think that each level requires a surrogate key? (Note* in my picture of dimension LineOfBusiness = LineOfBusinessId.....same for Division and Worker)
May
1
suggested suggested edit on SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?