Showing User-related Content in a Report
In cases where you want the data or content in a report to be different for each user,
there are a...
2010-03-11
536 reads
SQL Server BI Blog
How to Script Report Deployment, Move Reports or Change Properties
On the MSDN forums I see a lot of questions about how to use program code or command
line script to...
2010-03-11
496 reads
Oracle .NET Data Provider not Supported but Necessary for Cube Design
I've decided that from now on, consulting project estimates will be padded for an
additional week to get Oracle connectivity working...
2010-03-11
446 reads
Format Date as Week of Month
You can define a calculated field for the datset outside of the query using a Visual
Basic.NET expression. In the Data...
2010-03-11
665 reads
Report Parameter Date Range
A forum poster wanted to use a StartDate parameter to limit the range of dates available
in a second parameter to...
2010-03-11
541 reads
Alternate Row Colors in an SSRS 2000 or 2005 Matrix
To create a "greenbar" report in a table with alternating row colors, you can simply
use the RowNumber function to determine...
2010-03-11
1,684 reads
Navigating to a Report in a Pop-up Window
When using the Jump to Report action int he web browser, the target report is displayed
in the same browser window...
2010-03-11
428 reads
Creating a Business Scorecard
Report Recipes
This is the second in a series of three articles highlighting the Report Solution
Patterns and Recipes from Chapter 7...
2010-03-11
911 reads
Column Chart with Goal Threshold Line
Chart reports are an effective way to visualize data to show trends and comparisons
in a way that can help the...
2010-03-11
2,012 reads
Parameterized Top Values Report
Top ranked lists are a common type of report. In many cases business users may want
to see only a specific...
2010-03-11
655 reads
Blogs
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Retro Data 2025 – Slidedeck
You can find the slides of my session on the €100 DWH in Azure...
The Book of Redgate: We Value Teams
By Steve Jones
This value is something that I still hear today: our best work is done...
Forums
Is there a way for SP to know who called it?
Hi everyone I am writing an SP where there is logic inside the SP...
Planning for tomorrow, today - database migrations
Comments posted to this topic are about the item Planning for tomorrow, today -...
Bottlenecks on SQL Server performance
We have a BI-application that connects to input tables on a SQL Server 2022...
Question of the Day
The Tightly Linked View
I try to run this code on SQL Server 2022. All the objects exist in the database.
CREATE OR ALTER VIEW OrderShipping
AS
SELECT cl.CityNameID,
cl.CityName,
o.OrderID,
o.Customer,
o.OrderDate,
o.CustomerID,
o.cityId
FROM dbo.CityList AS cl
INNER JOIN dbo.[Order] AS o ON o.cityId = cl.CityNameID
GO
CREATE OR ALTER FUNCTION GetShipCityForOrder
(
@OrderID INT
)
RETURNS VARCHAR(50)
WITH SCHEMABINDING
AS
BEGIN
DECLARE @city VARCHAR(50);
SELECT @city = os.CityName
FROM dbo.OrderShipping AS os
WHERE os.OrderID = @OrderID;
RETURN @city;
END;
go
What is the result? See possible answers