2022-04-11
17,301 reads
2022-04-11
17,301 reads
2022-04-06
47,822 reads
2022-02-28
11,041 reads
Learn how to use IIF, Switch and Choose logical functions in SSRS reports to make your reports more dynamic and more appealing to report users.
2021-10-13
Power BI has a new feature which is the Power BI Small Multiples visual. In this article we cover how to enable this feature and also walk through an example of how to use this in a Power BI report.
2021-03-05
In this article we look at the different ways to connect to various SQL Server services using tools like SSMS, BCP, SQLCMD, PowerShell and more.
2021-02-12
In this article we cover all of the steps required to install, setup and configure SQL Server Reporting Services.
2020-12-31
In this article we walk through how to build a SQL Server Reporting Services report based on database level security settings by user to show different results to each user that runs the report.
2020-11-09
This tip provides a step by step process to create a cross tabulation report in SQL Server Reporting Services.
2020-09-30
An introduction on how to implement condition formatting of cells, such as the font and background colour or font weight, within SSRS using SSRS Expressions.
2022-11-25 (first published: 2020-09-17)
41,381 reads
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
Hi everyone I am writing an SP where there is logic inside the SP...
Comments posted to this topic are about the item Planning for tomorrow, today -...
We have a BI-application that connects to input tables on a SQL Server 2022...
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; goWhat is the result? See possible answers