Viewing 15 posts - 31 through 45 (of 62 total)
Sean,
Thanks for your advise. As of now, I don't have any tables with circular references.
- Rex
June 11, 2013 at 5:08 pm
Thanks, Geoff & Kraig,
I used the following for my hide expression of the text box (which displays the message)...
= NOT (
(
IsNothing (Parameters!FromDate.Value)
AND
NOT (
IsNothing(Parameters!ToDate.Value)
)
)
OR
(
NOT (
IsNothing (Parameters!FromDate.Value)
)
AND
IsNothing(Parameters!ToDate.Value)
)
OR
(
Parameters!FromDate.Value >...
May 31, 2013 at 10:37 am
Thanks for your suggestions. My query is kinda notorious, and that is the reason I am looking to choose/render data in chunks. I guess I don't have many options 🙁
Thanks...
May 30, 2013 at 2:19 pm
I am passing these to a stored procedure call. If I set it at the SSRS parameter, it will either accept NULL or not. What I need is, for both...
May 29, 2013 at 6:08 pm
Thank you all!
- Rex
May 21, 2013 at 1:37 pm
Geoff5,
Thanks a lot for your suggested solution. I appreciate that.
Eugene Elutin,
Your solution looks simpler, but it is not sorting the end result the way I want it. Any suggestions on...
May 21, 2013 at 11:44 am
Thanks, Lynn Pettis. I will refer to the article.
- Rex
April 30, 2013 at 2:44 pm
Lynn Pettis,
Thanks, but the "AdjustedTotal" should be a sum of previous "AdjustedTotal" and current total. Your solution is showing sum of Previous "Total" and current "Total".
I will try to play...
April 30, 2013 at 1:18 pm
I really appreciate you taking time to explain that, Alan. Since the assumption was 1-1, I thought INNER JOIN would work, but never thought of anything further, and how it...
April 19, 2013 at 12:28 pm
Would you mind elaborating, AJB? I didn't quite get it. I used inner join since I thought, if there is no match no update is required.
- Rex
April 19, 2013 at 10:31 am
Your modified query also does not return any rows, so it will still fire the else part.
- Rex
April 18, 2013 at 11:56 am
venkyzrocks,
I agree with Sean Lange. More clarity and some ground to get others started would be nice to have.
Having said that, I have created table variables to simulate your...
April 18, 2013 at 10:14 am
I had encountered something similar a while ago in one of the assignments I had been a part of. I think the DB may have been originally migrated from MS...
April 9, 2013 at 3:21 pm
Here's another version which uses ROW_NUMBER()...
;WITH cte (ID, SeqID, FileDescription, Points)
AS (
SELECT LEFT(FileDescription,4) AS [ID],
ROW_NUMBER()
OVER (
PARTITION BY LEFT (FileDescription, 4)
ORDER BY LEFT (FileDescription, 4)
) AS SeqID,...
April 4, 2013 at 2:06 pm
Viewing 15 posts - 31 through 45 (of 62 total)