Is your server Windows 2008? Perhaps that limits the available feature set for SQL Server 2016? (Although I'd have thought you wouldn't get past the first couple of...

You can't do it like that, for two reasons. First, you can't use a variable to represent the name of the stored procedure. If you don't know at...

Go to the topic in Books Online for each of the views and functions you're using. There'll be a Permissions section, which will tell you what permissions you need...

Is it being created by another job or by a store procedure? Query the command column of msdb.dbo.sysjobsteps, and the definition column on sys.sql_modules in every database to see...

Jamie

You need to choose a different instance name for the new installation, even if you are installing different features.

John

sp_update_alert

John

Perhaps we can all agree on the following?

* There are storage formats and presentation formats

* The user/programmer cannot change the storage format, but he can change the presentation format

* The...

Well, that was just an example. You could have, for example, a start date and an interval as parameters to your report, and then calculate the other dates from...

Given that this is a data warehouse application, all the data is sourced from existing databases, so in theory it should be correct. That said I did work on an...

LTRIM only removes spaces. Use REPLACE to replace each "-" with a blank (""). Be careful if you have any non-leading "-"s that you want to keep, though.

John

Here's one way of doing it:

DECLARE @CurrentStartDate date = '20160718';

DECLARE @CurrentEndDate date = '20160724';

DECLARE @PreviousStartDate date = '20150718';

DECLARE @PreviousEndDate date = '20150724';

SELECT

(SELECT COUNT(WorkOrder)

FROM TableA

WHERE RequireByDate BETWEEN @CurrentStartDate AND @CurrentEndDate) As...

Yes, although there is a two-byte overhead for the variability, so storing "Test" would cost you 6 bytes. But if, for example, you were storing just state codes "AL",...

Also, choosing the appropriate data type (and scale) helps prevent absurd data from getting into your database - you know, dates that aren't proper dates, phone numbers with text in...

Another option, if you do regular random test restores of your databases, is to run DBCC CHECKDB on the restored version. Yes, you'll still need the same amount of...

Ralph

Use an error output in your data flow.

John