Report Recipe Book Released
Our SQL Server Reporting Services Recipe book was released in April. This is
a cookbook style book for experienced SSRS designers...
2010-03-21
539 reads
Our SQL Server Reporting Services Recipe book was released in April. This is
a cookbook style book for experienced SSRS designers...
2010-03-21
539 reads
Creating one report to meet multiple business requirements can save a lot of work
down the road. A common scenario is...
2010-03-16
807 reads
I want to return the field value for a specific row to a textbox below a table in
my report. To...
2010-03-16
425 reads
A user has been added to a SSRS role for the report folder or report but is still
prompted to login....
2010-03-16
1,906 reads
There are certain key words in a T-SQL query than cannot be parameterized, including
the TOP statement. Consider the followong attempt...
2010-03-16
789 reads
<<placeholder>>
…for product review
Weblog by Paul Turley and SQL Server BI Blog.
2010-03-12
411 reads
Let's say that you have a column
named some_id in an outer-joined table that will return a value if a record...
2010-03-11
415 reads
Report designers often revert to overly complex report designs and often use subreports
unnecessarily. Building a report on a single dataset...
2010-03-11
578 reads
Reporting Services supports recursive hierarchies and Analysis Services supports parent-child
dimensions…
…and these two powerful features ought to just work together seamlessly,...
2010-03-11
7,522 reads
This question comes up quite often. A report requires a user to be authenticated using
their own network user name and...
2010-03-11
406 reads
Do you know if your SQL Server is really running at its best? To...
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...
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