What I think you were asked is what formula you are using to compute age, not what version of SQL Server.

Still confused, how do you know that the value you want is in the column named ALIAS_ID? I can see how you find the column you want to query...

achtro (1/23/2013)

---

CREATE TABLE [dbo].[ALIAS_TYP](

[USER_ID] [varchar](50) NOT NULL,

[EFFECTIVE_DATE] [datetime] NOT NULL,

[END_DATE] [datetime] NOT NULL,

[LOCATION_ID] [int] NOT NULL,

[TM_ID] [int] NOT NULL,

[ALIAS_ID] [int] NOT NULL,

[TM_GUID] [varchar](50) NULL,

CONSTRAINT [PK_ALIAS_TYP] PRIMARY KEY CLUSTERED

(

[ALIAS_ID]...

Scott Anderson-466019 (1/23/2013)

---

Ok, not a convincing enough argument? How about the Internet. The biggest usage of software by humans and the major outages have been caused by what or whom?...

Nope, still confused. Perhaps if you took the time to read the first article I reference below regarding asking for help and provided us with DDL (CREATE TABLE statement(s))...

You may want to read this: http://msdn.microsoft.com/en-us/library/76fb3eca-6b08-4610-8d79-64019dd56c44.

You use the listener as part of the connection string from what I just read. Can't help beyond this as I don't have...

emile.milne (1/23/2013)

---

Thanks, thats not ideal. I think most people will use the replica for SSRS. Big flaw in the design then.

If I want to tweak the index for reports they...

MyDoggieJessie (1/23/2013)

---

I am confused and perhaps just missing the obvious. You just want to return the column name for the column that's the PK in any given table? DECLARE...

Can't help much from here but I can tell that I used Event Notification at a previous employer when I setup database mirroring on SQL Server 2008. The event...

ChrisM@Work (1/22/2013)

---

Welsh Corgi (1/22/2013)

---

The following works :

SELECT

CASE WHEN LEFT(Customer.StartDate, 2) = '98' THEN substring(convert(varchar(20),Customer.StartDate), 3, 2)

...

Welsh Corgi (1/22/2013)

---

The following works :

SELECT

CASE WHEN LEFT(Customer.StartDate, 2) = '98' THEN substring(convert(varchar(20),Customer.StartDate), 3, 2)

...

I also believe that it depends on ones environment. At a previous employer, the principal database servers reside on blade servers attached to a high performance SAN. The...

Although posted in a forum dedicated to SQL Server 7 and SQL Server 2000, you stated you are using SQL Server 2008. The following is another alternative solution:

DECLARE @Issues...

Lynn Pettis (1/21/2013)

---

Welsh Corgi (1/21/2013)

---

I had to use a CONVERT with the SUBSTRING Function as opposed to the CAST.

This works.

SELECT

CASE WHEN CAST(LEFT(Customer.STARTDATE, 2 AS VARCHAR(2)))

...

Welsh Corgi (1/21/2013)

---

I had to use a CONVERT with the SUBSTRING Function as opposed to the CAST.

This works.

SELECT

CASE WHEN CAST(LEFT(Customer.STARTDATE, 2 AS VARCHAR(2)))

...