Is Data Visualization still just a buzzword?
If asked this question two years ago, my answer would have been a resounding “Yes.” At that time, the focus...
2016-01-05
523 reads
If asked this question two years ago, my answer would have been a resounding “Yes.” At that time, the focus...
2016-01-05
523 reads
SQL Saturday NYC is going full steam ahead and we have finalized our 2 Precons for Friday May 29th. Before...
2015-02-21
775 reads
SQL Saturday NYC is going full steam ahead and we have finalized our 2 Precons for Friday May 29th. Before...
2015-02-21
251 reads
SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2...
2015-02-20
247 reads
SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2...
2015-01-09
464 reads
There are several really good blogs that already exists that explain the differences between Table Variable, Common Table Expressions (CTE)...
2015-01-05
1,158 reads
There are several really good blogs that already exists that explain the differences between Table Variable, Common Table Expressions (CTE)...
2015-01-05
303 reads
Just over 2 weeks now since SQL Saturday NYC went live and planning is in full force. An update on...
2014-12-10
317 reads
If you are going to use functions first you should understand how functions work as they are often over used...
2014-12-05
613 reads
It has been one week now since SQL Saturday NYC was announced and the planning committee and myself are very...
2014-12-03
364 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