A suggestion, use a Script Component in the Data Flow instead of the Derived Column.

😎

Check out sys.dm_exec_connections and sys.dm_exec_sessions

😎

SELECT COUNT(*) AS SESSION_COUNT

FROM sys.dm_exec_connections

SELECT COUNT(*) AS SESSION_COUNT

FROM sys.dm_exec_sessions SS WHERE SS.host_name IS NOT NULL

Thank you Geoff for this fine and informative articles.

😎

Quick question, what is the driver for improvements if this works?

😎

Phil Parkin (5/9/2014)

---

Eirikur Eiriksson (5/9/2014)

---

Hadrian (5/9/2014)

---

Hi,

I have a folder which receive the CDR and CMR files sended by Cisco.

There is no datetime for them,but I wish to move on another...

Hadrian (5/9/2014)

---

Hi,

I have a folder which receive the CDR and CMR files sended by Cisco.

There is no datetime for them,but I wish to move on another folders separated CDR from...

sqlguy-736318 (5/8/2014)

---

Thanks Eirikur, that's the basic N:N implementation I had in mind. My question was, is N:N the correct relationship for the scenario I'm describing, and under what scenario would...

This is the simplest way

😎

[User]-|---0<[UserRole]>0---|-[Role]

Thomas Abraham (5/8/2014)

---

If you look at a QWERTY keyboard, you'll see this is a splendid example of the well known "off by one" error....

Favourites are 21-24-21 and 24-24, basically monitor count > 1 will do though.

😎

To get you started

😎

Sample data

USE tempdb;

GO

IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'TBL_STOREDPROC_001' AND TABLE_SCHEMA = N'dbo')

DROP TABLE dbo.TBL_STOREDPROC_001;

IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES...

danielfountain (5/8/2014)

---

Hi all,

I am using a cursor (i know - but this is actually something that is a procedural loop).

So effectively i have a table of names of stored procedures....

Thanks for the question, made me go have a look when I couldn't see the correct answer listed, hoping it might have changed:-D

😎

azmiman (5/8/2014)

---

Eirikur Eiriksson (5/8/2014)

---

First, few questions:

1. Will you ever have to list more than one type in the same result set?

2. Will you be adding new types?

3....

First, few questions:

1. Will you ever have to list more than one type in the same result set?

2. Will you be adding new types?

3. Is there a...