DECLARE @SYSTEM_USER sysname = 'DOMAIN\Joe.Bloggs';
WITH SystemUser (UserName) AS (
    SELECT REPLACE(@SYSTEM_USER,'\','.')
    )
SELECT
     PARSENAME(UserName,2) AS FirstName
,    PARSENAME(UserName,1) AS LastName
FROM SystemUser;

John

The error message tells you exactly what's wrong.  You need to rewrite the subquery so it returns only one value.

John

Use MIN and MAX dateID, grouped by RecordID and Quantity.  That'll work for your sample data, but it'll give strange results if you ever go back to the same Quantity...

I think those numbers refer to the schema versions, not the compile time and run time.

John

Perhaps it didn't get installed properly.  Can you see SQL Server in the Services applet?

John

Have you tried running SQL Server Configuration Manager to find out the name of the instance, and possibly also the port number on which it listens?

John

Grant the user UPDATE permission on the tables in question, and deny DELETE on the same tables.  You can do that directly or via membership of a role that you...

ALTER DATABASE myDatabase SET COMPATIBILITY_LEVEL = 120;

Don't do this on the production server unless you really know what you're doing.

John

The SELECT is there to assign a value to @SalesTaxDue.  It's necessary because unlike in some other languages, you can't assign a value with an equality expression alone - you...

Put an extra task in your package to run whoami and put the result in a text file or a table.  That will tell you under what security context the...

No, don't shrink your logs after backing up.  They'll only grow again, causing fragmentation and unnecessary use of resources.  Increasing the frequency of log backups may reduce the size that...

The error message explains what the problem is - it isn't finding any files.  I don't know whether that's because there aren't any files that match the pattern, or whether...

You've posted in the SQL Server 2012 forum.  Are you actually using SQL Server 2008 R2 or below?

John