SQL Saturday NYC
I excited to say that PASS SQL Saturday NYC is back on the schedule and will be May 30, 2015...
2014-11-25
1,007 reads
I excited to say that PASS SQL Saturday NYC is back on the schedule and will be May 30, 2015...
2014-11-25
1,007 reads
On November 18, 2014 I had presented to the New Jersey SQL Server User Group (NJSSUG) on SSIS Performance Tuning. ...
2014-11-21
401 reads
This is the first in a series of dating tips, so if you need you’ve come to the right place.
...
2014-02-01
255 reads
With the introduction of the SQL 2012 SSIS Catalog there has been the question of what permissions are available and...
2013-07-20
906 reads
SSIS Lookup tasks are all too easy to abuse as they are easy to setup and not really think about...
2013-05-27
310 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