Viewing 15 posts - 16 through 30 (of 35 total)
One of the rules of RDBMS is that we don't do display formatting in the database layer of a tiered architecture. It goes out to a presentation...
May 21, 2018 at 11:45 am
I can understand the fullName equivalent because indexing and/or searching on that is likely better than putting a concat(a,' ',b) on the left side of the search string... I'm wondering...
May 15, 2018 at 10:09 am
They are all formatted differently... I have always just done the formatting at runtime because of the overhead of storing all of those permutations of data I thought would be huge. ...
May 10, 2018 at 11:55 am
Oh... I already reverse engineered it and unpivoted it back to a vertical for my data model. There are many more rows, but the import and rendering in PowerBI works...
February 2, 2018 at 12:12 pm
It is a fact table...
Before I came across this, I had never seen a table as wide as this before so I just wanted to consult with the...
February 2, 2018 at 11:27 am
February 1, 2018 at 3:25 pm
Thanks all for your input... unfortunately, I didn't build these tables. They were built as data warehouse tables because they didn't want users writing SQL, so to make life easier,...
January 16, 2018 at 12:43 pm
Another alternative that was presented to me would be to run the query as originally gathered with all the numeric values and then run an update sql addendum to convert...
May 12, 2016 at 4:55 pm
Right now the data looks like...
ContactIDDoNotPhoneDoNotFaxDoNotEMailDoNotPostalMailDoNotBulkEMailDoNotBulkPostalMailAccountRoleCodeTerritoryCodeIsPrivate
ABC0000003510
DEF0000001210
AQW0000003220410
FEW000000110
ERW000000410
It should look like this... (I'm guessing it was done this way for internationalization/language transcoding now that I think about it)
ContactIDDoNotPhoneDoNotFaxDoNotEMailDoNotPostalMailDoNotBulkEMailDoNotBulkPostalMailAccountRoleCodeTerritoryCodeIsPrivate
ABCNoNoNoSkipSkipSkipBahamasPrimaryNo
DEFNoNoNoSkipSkipSkipMiamiPrimaryNo
AQWNoNoNoSkipSkipSkipAlbertaPrimaryNo
FEWNoNoNoSkipSkipSkipKendallPrimaryNo
ERWNoNoNoSkipSkipSkipTampaPrimaryNo
May 11, 2016 at 11:59 am
Thanks... I knew there had to be an easier way. I will check to see if the 8K is installed on that server or not. Maybe I'll get...
March 30, 2016 at 10:38 am
Each character maps to another specific character ... position in the string is not important.
1 always converts to A
2 always converts to B
3 always converts to C
etc...
March 30, 2016 at 9:21 am
My DBAs frown on dynamic SQL... so I think I will go with the splitter function. Which there was way to say treat this as a CSV rather than...
August 19, 2015 at 11:24 am
Sean Lange (5/16/2014)
May 16, 2014 at 8:51 am
Mind Blown... :w00t:
I obviously jumped to unnecessarily complicated trying to solve my problem without trying the most simplest of solutions first.
May 16, 2014 at 8:43 am
http://www.sqlservercentral.com/Forums/Topic1571755-3077-1.aspx
(it was a seat to keyboard interface error over here) :blink:
May 16, 2014 at 8:33 am
Viewing 15 posts - 16 through 30 (of 35 total)