Here's a safe option for you:

DECLARE

@DBName NVARCHAR(25) = 'CRHC',

@BegDate DATE = '9/1/2016',

@EndDate DATE = '9/1/2016',

@sql NVARCHAR(MAX)

SELECT @sql = N'USE ' + QUOTENAME( db.name) + ';

SELECT...

Quick thought, return less columns. Why or when will you ever need all those columns and all those rows?

Also, do not use ISNULL, use WHERE (Column50 = 1 OR Column50...

I've tried Poor Man's T-SQL Formatter[/url] and ApexSQL Refactor which gave me good results to organize messy code, but won't do everything I wanted.

They're good, but you should try...

This might help: http://download.microsoft.com/download/8/A/2/8A2BC8C5-BBA0-4A9C-90BC-AC957D3454D9/SQL_Server_2016_Editions_datasheet.pdf

The improvement on window functions and error handling.

Native compressed backups, which would speed up your maintenance process.

Extended events to mostly replace traces.

New cardinality estimator.

Improved security and...

Eirikur Eiriksson (11/10/2016)

---

homebrew01 (11/10/2016)

---

Doesn't cost any money ?? ...

a_car11 (11/10/2016)

---

I am trying to show where I am having the issue, I need to do a join on the "temptable" table to get the value of ...

exhaust port

Here's an example:

CREATE TABLE StgTable(

Id int,

Seq int,

name varchar(10),

company varchar(10)

);

INSERT INTO StgTable

VALUES

...

Why do you want to create an SSIS package from Powershell?

Air

Here's an example:

CREATE PROCEDURE ProcedureWithOutputParam(

@OutputParam int OUTPUT

)

AS

SET @OutputParam = 5;

GO

CREATE PROCEDURE ProcedureWithInputParam(

@Param int

)

AS

SELECT @Param AS Parameter;

GO

DECLARE @Parameter int = NULL;

EXEC ProcedureWithOutputParam...

You need to have Business Intelligence Development Studio (BIDS) or SQL Server Data Tools installed, depending if it 2008 or 2012+.

These are part of the SQL Server installation, as long...

If it's not using dynamic sql, you can start by using sys.sql_expression_dependencies and sys.sql_dependencies

Wine

BowlOfCereal (11/8/2016)

---

drew.allen (11/7/2016)

---

Since you want the final result as a numeric value, it doesn't make sense to manipulate the string. Try the following:

SELECT m.origval, n.comp_val

FROM #mytab m

CROSS APPLY (

SELECT...