Excellent script, slight modification to include schema name, just in case anybody else needs that info

-- create table to hold function names
CREATE TABLE [#TempFunctions]

Contradiction here: 3 people:

https://mvp.microsoft.com/en-us/PublicProfile/4014238?fullName=Steve%20%20Jones

I have worked with all versions since that time, primarily as a production DBA at all sizes of companies. During my career I became interested in writing...

Nice solution.

One less line of code: 🙂

SELECT

CASE WHEN [x].[n] % 15 = 0 THEN 'FizzBuzz'

...

The clue(s) are in the error message(s) - the connection string is invalid.

Concatenate the generated strings and copy/paste into a browser or reverse engineer the URL from the desired report.

From...

transparent

Untested but should work:

if ( $null -ne $server.Databases[$DBName] ) { $exists = $true } else { $exists = $false }

You could try a combo of this function:

http://sqlblog.com/blogs/paul_white/archive/2011/12/23/forcing-a-parallel-query-execution-plan.aspx

Or using powershell

https://technet.microsoft.com/en-us/library/jj713711.aspx

https://msdn.microsoft.com/en-us/library/ff929186(v=sql.110).aspx

http://bidn.com/Blogs/userid/11/Use-SQL-Server-Agent-to-Process-Cube

Dobbs77 (12/23/2015)

---

@tencenturies. I initially had a query similar to the one you have posted. ID is an identity column, so Group By ID doesn't work quite right.

This Code below...

My bad - will not work on an identity column!

Like this...

SELECT

VoipCallDetailsAlert.ID

, VoipCallDetailsAlert.Name

FROM

...

Removed

Sean Lange (12/23/2015)

---

Alvin Ramard (12/23/2015)

---

Slick, but definitely not what the OP was asking for. The OP clearly said he wanted to select the values...

Very slick solution Sean, kudos!

Sean Lange (12/23/2015)

---

Assuming you are trying to only return those rows with numbers only and not return rows with any other characters you do this pretty easily.

if OBJECT_ID('tempdb..#ZipCodes') is not...

There are several ways to achieve the desired results.

Here is a sample function that will help you get started:

CREATE Function [fnRemoveNonNumericCharacters](@strText VARCHAR(1000))

RETURNS VARCHAR(1000)

AS

BEGIN

WHILE PATINDEX('%[^0-9]%', @strText) >...