IF OBJECT_ID('tempdb.dbo.#row_counts') IS NOT NULL

DROP TABLE #row_counts

CREATE TABLE #row_counts (

db_name nvarchar(128) NOT NULL,

table_name nvarchar(128) NOT NULL,

...

Maybe this:

case

when pwdLastSet0 is null then 'Never'

when pwdLastSet0 = '0' then 'Must change at next logon'

ELSE convert(varchar(10), cast (DATEADD(mi,(cast(pwdLastSet0 as bigint) / 600000000) - 157258080

+ DATEDIFF(Minute,GetUTCDate(),GetDate()),0) as varchar(32)), 101)...

Change Tracking won't do what you've described. You would have to use CDC. Please note that CDC is only available on Enterprise Edition.

Sqlraider (4/21/2014)

---

ScottPletcher (4/18/2014)

---

Try this:

SELECT

emp.eid, emp.agentid,

info.emailid,

mail.EmailAddr, mail.LName, mail.FName

...

Try this:

SELECT

emp.eid, emp.agentid,

info.emailid,

mail.EmailAddr, mail.LName, mail.FName

FROM employees...

sql_variant would be a good data type for this.

You don't want to modify the target table structure, as that will have lots of overhead.

Does the target table have a unique key column(s)? If not, can you add...

It won't?? That string doesn't look like it starts with a letter to me ......

DECLARE @parameter int

SET @parameter = 2 --NULL=ALL; spec. value = that value

SELECT

col1ID,

CASE WHEN COUNT(DISTINCT Col2ID) = 1 AND

...

I think this query will give you what you need in separate rows. If so, let us know, and we can pivot it to a single row.

DECLARE @control_date datetime

SET...

I suggest:

1) be sure to pad the month and day values so that the final format is a full yyyymmdd.

2) apply column names to make the code easier to understand...

WHERE

column_name LIKE '[a-z]%'

Lynn Pettis (4/17/2014)

---

ScottPletcher (4/17/2014)

---

Lynn Pettis (4/17/2014)

---

ScottPletcher (4/17/2014)

---

You need to do further research before you change the existing index to a filtered index, because that index will no longer satisfy queries...

SpeedySQL (4/17/2014)

---

If you're considering upgrading to SQL 2012, be aware that the licensing model is changing to per core. Another factor you may want to look at apart from...

Lynn Pettis (4/17/2014)

---

ScottPletcher (4/17/2014)

---

You need to do further research before you change the existing index to a filtered index, because that index will no longer satisfy queries originally using it...