Viewing 15 posts - 1 through 15 (of 86 total)
this is a simple requirement, you yourself can write the query for this..anyway, Mr.PietLinden has tried to help you with a sample query..
August 6, 2018 at 4:57 am
August 3, 2018 at 10:29 am
Hi PC Reddy,
here is the query you asked for
Question 1(Need to czategorize the column as positive and negative and sum it as below.)
August 3, 2018 at 9:04 am
Thanks a lot for the reply with valued informations..
I saw the post you suggested.. looks there is a bunch of information where I can...
July 26, 2018 at 8:41 am
Initially I created the Staging table in a file group ([MyPartitionValueCurrentfg]) where the data which I want to move...
November 24, 2016 at 9:19 am
Though this is an Old thread, my answer might help someone.(I believe you might have found the solution sometime later you posted this thread).
to be precise to...
November 23, 2016 at 3:34 am
the problem was on converting the value into float as micheal and gail said, the code given by gail works for me.
Thanks gail and everyone for your quick...
November 8, 2016 at 7:55 am
whatever you tried (that is what suggested by phil as well) is the shortest way to achieve this requirement.
November 8, 2016 at 12:40 am
Yes, your answer is approximately correct, I already tried this idea as well, what happened you know, it is getting successfully executed with raw value I mean hardcoded value.....
March 16, 2016 at 2:32 pm
thanks for the information. But it doesn't help me to fix the issue, because I already tried those ideas which were not working..
But I like your intension...
March 16, 2016 at 2:19 pm
yes, the point you have explained in the first paragraph is correct. that was my approach. Now I have modified the "Execute Package Task" to call the package from...
December 7, 2015 at 10:25 am
there are two way to get a fix
Try using the Shared Datasource instead of embedded Datasource and deploy the datasource in the server where the reports has been deployed
July 28, 2015 at 3:12 pm
I found the reason, though there are several reasons for this error from MDX query through SSRS report, what I found is, the functionality of STRTOMEMBER / STRTOSET is getting...
July 28, 2015 at 3:06 pm
I believe I am looking into this post very late. but it is very very useful for me.. thanks to you..
and Thanks to SQLSERVERCETRAL, because nowhere I got...
April 30, 2015 at 4:00 am
Finally the confusion has got endup and based on the advice from you guys (bit from each of you) have achieved the query to run faster and completed in...
January 22, 2015 at 4:15 am