Viewing 15 posts - 751 through 765 (of 4,085 total)
Please don't post duplicate posts on the same topic. You already have a thread on this topic.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 28, 2018 at 11:43 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 27, 2018 at 8:11 am
,APP.DATA.value('(BaseItemID/@id)[1]'...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 26, 2018 at 2:15 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 26, 2018 at 12:10 pm
There are three issues with your query.
1) Your XML uses a namespace, and you have not adjusted your query to account for that. The easiest way to do...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 26, 2018 at 9:40 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 24, 2018 at 8:19 am
You have been pointed to an article that tells you the correct way to post data multiple times. (it's the first link in my signature and also Lynn's signature.) You...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 24, 2018 at 7:57 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 20, 2018 at 2:30 pm
Most people are hesitant to open Excel files posted by random strangers on a public site. The first link in my signature covers the proper way to post data. Please...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 20, 2018 at 11:21 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 19, 2018 at 2:51 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 19, 2018 at 1:48 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 14, 2018 at 8:05 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 13, 2018 at 3:02 pm
It's not a simple pivot. It's a combination of a pivot and an unpivot. And, because the number of rows isn't constant, it will need to be dynamic.
I...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 13, 2018 at 11:03 am
Have you tried using TRY_CAST( ColXML AS XML) to determine which value(s) cannot be converted to XML, and then seeing if there are any obvious characters in those values that could...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 13, 2018 at 10:46 am
Viewing 15 posts - 751 through 765 (of 4,085 total)