Sean Lange (6/27/2013)

---

See if something like this will get you started. Please notice how I posted ddl and sample data in a consumable format.

if OBJECT_ID('tempdb..#Something') is not null

drop table #Something

create...

Any internal email will not have the @provider.com.

This is a learning experience on this one. Self taught and learning as I go.

I'd like result to be the email address only and it is the last entry in...

Hopefully this helps understand what I am asking.

SELECT [t].[TicketID] as "Ticket"

,

.[TicketHistoryID]

...

whenriksen (6/18/2013)

---

Assuming your indexes are appropriate for your query;

Create a view to pre-filter your data on the remote server. Ideally, create a single view that has all of the...

Thank you--- Error is gone, but Runtime is long.

Any ideas on reducing runtime?

Got it. Thanks guys for your help.

ok, so I used this query-

DECLARE@strColumns VARCHAR(MAX)

DECLARE@strSQL VARCHAR(MAX)

IF OBJECT_ID('tempdb..#tmp_table') IS NOT NULL

DROP TABLE #tmp_table

CREATE TABLE #tmp_table

(

CallDateTimeDATETIME,

HistIDINT

)

INSERT #tmp_table( CallDateTime, HistID )

Select'11/1/2012 9:02:30.000',2270647UNION ALL

Select'11/1/2012 8:59:59.000',2270648UNION ALL

Select'11/1/2012 9:01:33.000',2270650UNION ALL

Select'11/1/2012 9:03:40.000',2270652UNION ALL

Select'11/1/2012 9:02:50.000',2270653UNION ALL

Select'11/1/2012...

Day runs 0800-2000 and I think it would run better if the results came out like this:

Date 08:00-08-30|08:30-0900...