Some tools available are Redgate's SQL Prompt, ApexSQL Refactor and Poor Man's T-SQL Formatter.

I use the 2 latest because they're free, but I know that SQL Prompt has more capabilities....

This will allow to handle multiple occurrences. It uses a pattern splitter that is explained in here: http://www.sqlservercentral.com/articles/String+Manipulation/94365/

And string concatenation explained in here: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

SELECT *,

LTRIM((SELECT CASE...

a

/a,?/

determiner

1.

used when referring to someone or something for the first time in a text or conversation.

"a man came out of the room"

2.

used to indicate membership of a class of...

Greg Edwards-268690 (5/19/2016)

---

Brandie Tarvin (5/19/2016)

---

GilaMonster (5/19/2016)

---

Oooh. Am very tempted to grab both the R and the Data bundles.

The free book yesterday (Machine...

Similar to what Lowell already posted, but leaving values as variables.

DECLARE @A AS INT = 1;

DECLARE @b-2 AS INT = 1;

DECLARE @Parameter1 AS INT;

DECLARE @Parameter2 AS INT;

DECLARE @Parameter3 AS INT;

DECLARE...

Ray K (5/18/2016)

---

Luis Cazares (5/17/2016)

---

This is sad, because this Saturday is my wife's birthday and SQL Saturday #521 in Atlanta. She wouldn't enjoy if I leave her the whole day...

Try to format your code. You'll thank yourself later.

ALTER VIEW dbo.ViewName

AS

SELECT t001.ScenarioID

,t001.accountnum

,t001.ACCOUNTNAME

,t001.dimension

,t001.GroupID

...

Maple

This is sad, because this Saturday is my wife's birthday and SQL Saturday #521 in Atlanta. She wouldn't enjoy if I leave her the whole day by herself.

Steve Jones - SSC Editor (5/17/2016)

---

What are...

Van Damme

SQLKnowItAll (5/17/2016)

---

1. I...

Thank you, I'm checking if we can actually configure Kerberos adequately to fix this issue.

For using config files, we would be using package deployment or file system instead of the...

Are we all aware that SQL Server includes the STDEV and VAR functions?

Other than the nulls being ignored, it should be easier to use.

Brandie Tarvin (5/16/2016)

---

Luis, do you use config files for this package?

Is this package an older one that is just now being upgraded to SQL 2012 or is it a new...