Viewing 15 posts - 676 through 690 (of 3,666 total)
I have a fact table with the same granularity. I have an Invoice Header dimension. In my design, I would add that in this dimension.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 11, 2015 at 2:58 pm
ericpap (6/11/2015)
Alvin Ramard (6/11/2015)
Eric M Russell (6/11/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 11, 2015 at 9:43 am
Eric M Russell (6/11/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 11, 2015 at 9:22 am
Shadab Shah (6/11/2015)
Alvin Ramard (6/10/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 11, 2015 at 8:48 am
kferrara (6/10/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 3:37 pm
I have no idea what you're looking for. Can you reword your request?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 3:30 pm
Only things I can think of right now is make sure each derived column name is correctly spelled and always has the same case. Address_1 and address_1 may be considered...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 2:57 pm
W4Designs (6/10/2015)
It...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 2:34 pm
ericpap (6/10/2015)
In the session on the user that stopped the service, i found...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 2:23 pm
W4Designs (6/10/2015)
CRAP!!! We're are right there and I don't see the problem either. I've matched every paren and they all match up unless this mess has made me go blind.
...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 2:19 pm
W4Designs (6/10/2015)
Alvin Ramard (6/10/2015)FINDSTRING and CHARINDEX don't work the same way. 😉
Try:
Address_1:
SUBSTRING(Street,1,50 - FINDSTRING(REVERSE(SUBSTRING(Street,1,50)), " ",1))
Address_2:
SUBSTRING(Street,LEN(address_1) + 1,50 - FINDSTRING(REVERSE(SUBSTRING(Street,LEN(address_1) + 1, " ",50)),1))
Address_3:
SUBSTRING(Street,LEN(address_1) + LEN(address_2) + 1,50...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 2:09 pm
W4Designs (6/10/2015)
Address_1:
SUBSTRING(Street,1,50 - FINDSTRING(" ",REVERSE(SUBSTRING(Street,1,50)),1))
Address_2:
SUBSTRING(Street,LEN(address_1) + 1,50 - FINDSTRING(" ",REVERSE(SUBSTRING(Street,LEN(address_1) + 1,50)),1))
Address_3:
SUBSTRING(Street,LEN(address_1) + LEN(address_2) +...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 1:50 pm
W4Designs (6/10/2015)
Alvin Ramard (6/10/2015)
Are you doing this in 3 separate derived column transforms?
Yes.
Ok. Then make sure that you drag the new column name (Address_1 & Address_2) from the column...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 1:28 pm
jpserra3 (6/10/2015)
have you ever migrated data from MS Access to SQL Server 2008 r2?
I haven't.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 1:18 pm
W4Designs (6/10/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 1:17 pm
Viewing 15 posts - 676 through 690 (of 3,666 total)