Report Builder 3.0 - See Values of Params Passed to Stored Proc?
From the Report Builder 3.0 (the builder itself), is there a way to see the VALUES of the params with which the stored proc is being invoked?
I want to verify that my dataset is working properly.
See also questions close to this topic
SQL server join query performance with different where conditions
I've two tables
Student(Id,DatasetId and other columns)
StudentAddress(Id, StudentId, DatasetId, Country and other columns).
StudentAddress has 2 foreign keys StudentID referring to Student - Id ** and DatasetId** referring to Student - DatasetId. Both tables are having 50 million records with one to one relationship with different DatasetId values.
--This query took 01:20 minutes Select * from Student S LEFT JOIN StudentAddress SA on S.Id = SA.StudentId WHERE S.DatasetId = SA.DatasetId AND S.DatasetId = 123 --This query took 01:18 minutes Select * from Student S LEFT JOIN StudentAddress SA on S.Id = SA.StudentId WHERE S.DatasetId = 123 AND SA.DatasetId = 123 --This query took 01:19 minutes Select * from Student S LEFT JOIN StudentAddress SA on S.Id = SA.StudentId WHERE S.DatasetId = SA.DatasetId AND S.DatasetId = 123 AND SA.DatasetId = 123
1)Will there be any difference in the performance between above 3 queries? When i executed these queries in my database, all queries resulted in same performance. I'm not expert to interpret actual query execution plan. Hence, reaching the experts to know which query will result in better performance.
2)Will there be any difference in the performance if I change the order of conditions in WHERE clause of the first query?
3)Also, my understanding is that data in both tables will be filtered on DatasetId and then LEFT JOIN will be applied on filtered data. Is my understanding correct?
MYSQL Add to existing value using two columns
I would like to add a value to every row in a table. Using a fixed value would give me the following query
UPDATE your_table SET displayorder = displayorder + C
What would be the right way to run a similar query such that
UPDATE your_table SET displayorder = displayorder + X(C)
Whereby C is a constant and X is the value of another column of the same row ? How do I get X which is the value of another column and how do I multiply it by C then add to an existing value ?
Updating a value in a particular column and maintaining it throughout the database
i have a requirement to substitute a value with some another value and maintain that through out the tables present in the oracle database .
For example: i have a column called city in table tab_a. In city column i can have numerous values of cities and many of the will be repeating.
So if i change value
"a-> b"in city column of table
tab_a, wherever a comes in the city column it should be changed to b.
Now suppose i have another table by the name of
"tab_c"which has city column. so if city of column of tab_c table consist of value
"a"it should also be changed to
Can somebody help me to implement this .
How to pass a sql stored procedure a string with DatetIme.Today() in it
I have a stored procedure that uses kendo params to filter the results. I would like to use this same procedure to run a report in SSRS. The parameter is shown below:
@pFilter = N'DueDate~gte~datetime2017-12-26T11-23-21~DueDate~lte~datetime2018-01-25T11-23-21~',
Here is what i need to be able ot pass it by bulding the param string but with a current dat calculation in it so the stored procedure can be called via Report Builder report.
@pFilter = N'DueDate~gte~datetime' DATEADD(day, 90, MAX(GETDATE())) + '~DueDate~lte~datetime2018-01-25T11-23-21~',
Is this possible and if so, can anyone point me in a direction to understand how to acomplish this?
-Thanks in advance-
Using two tables on same report with one stored procedure in Report Builder 3.0
I am trying to use two different tables but within one report, using the same stored procedure. So, we have a stored procedure that can handle returning items due for (Past Due, and Due in 90 days). Now, I currently set up one data set for each table. They have the same fields and everything because it is the same stored procedure. I thought that i could have one parameter exposed, so the user enters the customer id, and it then hard codes each data set with the filter value. Meaning one returns all "Items Due" and the other returns "Items Due in 90 days". The problem is that for the second dataset it states the parameter "customerID" is not entered. How can i have one param be shared for two data sets in on report that use the same proc?
Report Builder 3.0 - First & Last day of the following week date expression
Please could some one help me in obtaining the Date expressions of the below; First Day of the Following week (Monday) Last Day of the Following week (Sunday)