Sounds like you need this article: Crosstabs and Pivots by Jeff Moden...

db_owner is a ROLE, not a schema.
https://technet.microsoft.com/en-us/library/ms180977(v=sql.90).aspx

The default SCHEMA is dbo.

Having a "date purchased" column in Stores doesn't make any sense, unless you were recording the date the store was purchased. Normally, if a column doesn't describe the "subject" of...

Maybe watch this video... I watched it several times when trying to get my head around subreports. You can download their sample database so you can work along with the...

here's one solution using LAG. Requires SQL Server 2012 and later.

use tempdb;
go

create table #data(ProductID INT
                , LocationID CHAR(4)
                , EventDate DATE
                , Qty...

Couple things jump out as odd... First:
dt_close_time VARCHAR(23)

Why not use a DATETIME datatype?
Second, there seem to be only two records that meet the criteria (or did...

Use ROUND?
SELECT Amount,ROUND(Amount,0) AS rounded
FROM Green;

DAX Studio maybe?

Did you try COALESCE instead?

DECLARE @LastName VARCHAR(20) = NULL;
SET NOCOUNT ON;
SELECT p.[BusinessEntityID]
,p.[Title]
,p.[FirstName]
,p.[MiddleName]
,p.[LastName]
,p.[Suffix]
,pp.PhoneNumber
FROM [Person].[Person] p INNER JOIN [Person].[PersonPhone]...

Maybe something like this? (Might get shredded for this one, but live & learn!)
/* populate dummy table */
SELECT PatientID, Gender, Birthdate
INTO #Dummy
FROM dbo.Patient p

Nashville, TN has a ridiculous number of Healthcare IT jobs, especially SQL Server and .NET.  If you can do those, you can almost write your own ticket here. Not sure...

I'm sure.

You could do the cleanup in SSIS, and then once clean, insert the cleaned data into your final table. No MS Access required. And schedule the jobs...

The biggest thing is to remove all the VBA data functions that are in the database. Push all the data processing type stuff to SQL Server.

If you're doing it from within SSIS, I'd do what Phil said... if you're reading from Access, then you can do this:
DBEngine(0)(0).Tabledefs("TableName").Columns.Count  will work if you're reading from the...

You could mock this up in Excel, then use PowerBI Desktop or something for the visuals. Sounds like a good use of SSAS tabular. The "Questionnaire/Survey" pattern is covered by...