This is not for having a flashy website. I have a report displayed on large LCD monitor and the report is already filled up with other data. I only have...

Yes.. I am refreshing the report at a particular frequency. But wanted to implement the marquee feeling for a text. Let me try and will update you..

Thanks for the...

I am looking at displaying my data like a marquee text or a stock ticker.

You are right.. That's what made me think in that perspective 🙂

Got It!!!!!!!!!!

Sorry for my inexcusable behavior.. The Row group in the table was deleted.

I recreated the entire structure again and tried to see the difference. That's...

There is no change in the query execution in Management Studio and the development studio. In Management Studio, I have declared the parameters and provided the parameter values. In the...

1. Yeah.. Queries are identical. No processing done before or after that.

2. Yes.. I tried providing the parameters. The query is not providing any rows. I am not sure...

Well.. I ended up using CTE instead of PIVOT and still gave me correct results.. 🙂

Thanks to you as well Grant. 🙂

--

Regards

Sharada

Perfect! Perfect! Perfect! This should work. I will check this on my query and I will update if this displays the result set the way I want it to be.....

You have mentioned that if it is filter criteria, put it in the WHERE condition. However, the expectation is like this:

Against the Call ID, I would need to give...

Ok.. Agreed! I will not join two views.. I will join the underlying tables .. But!! What logic do I use ? Because be it a table/ view the problem...