Viewing 15 posts - 1 through 15 (of 17 total)
SSCrazy, you are correct. Without the correction CHARINDEX was finding and returning two code values for for "Literacy"--"IT" and "Literacy".
Also, I discovered FOR XMLPATH doesn't like strings containing an...
April 23, 2015 at 3:45 pm
Thanks for the response, CELKO.
ID is a primary key in "Table1". It has (I know, I know) a one-to-one relationship with the ID in a "Persons" table. Therefore,...
April 23, 2015 at 2:14 pm
Thanks for responding to my post. I'll check out your suggestion, appreciate your time.
April 22, 2015 at 5:17 pm
Thanks for responding, appreciate it.
April 22, 2015 at 5:16 pm
Well, I'm not so smart when it comes to adapting this snippet into a join with the parent table, Orders.
As soon as I join to Orders on ORDER_NUMBER, I start...
October 30, 2014 at 1:47 pm
Posted last reply before refreshing/seeing/reading your response.
I am running tests on my personal, non-networked laptop first. Staying away from servers. Trying to understand what I am exploring, learning...
October 30, 2014 at 11:12 am
Got it. I think. Indicating as answered.
Found out how to REPLACE the ',' within the STUFF with carriage return here: http://stackoverflow.com/questions/18635697/carriage-return-in-sql-server-2012.
October 30, 2014 at 10:32 am
Total noob with all of the replies, apologies.
Final obstacle, perhaps: I am trying to figure out how to strip/replace the extra (CHAR(10) + CHAR(13)) which precedes each list of...
October 30, 2014 at 8:55 am
I'm getting closer, I think I may have it. I've wrestled this down to this result with query results to text:
ORDER_NUMBER DESCRIPTION
--------------------- ------------------------------
451093.00 ...
October 30, 2014 at 8:10 am
Hi,
I tried running the CTE found in the link you provided. I see how this applies, but I haven't been successful toying around with substituting a carriage return for...
October 29, 2014 at 8:07 pm
Thanks for the link to article, Luis. I will give it a read and try it out.
October 29, 2014 at 3:38 pm
Dataset1 is indeed the name of the dataset.
Exact expression: =RunningValue(CountDistinct(Fields!SOPNUMBE.Value),SUM,"DataSet1")
June 18, 2013 at 3:14 pm
Thanks for your response!
I pasted the following expression into the cell above expression for order number,
=RunningValue(CountDistinct(Fields!SalesOrder.Value),SUM,"DataSet1")
then edited, replacing "SalesOrder" with "SOPNUMBE".
I am also using BIDS 2008.
June 18, 2013 at 11:02 am
I received an error when building the report. However, I am not certain whether or not I executed your suggestion the way you intended. Please see the attached...
June 18, 2013 at 8:55 am
Thank you so much! I'll give this a shot and let you know how it goes.
June 14, 2013 at 10:29 pm
Viewing 15 posts - 1 through 15 (of 17 total)