Ditto

Although I use a Auto_Open macro to execute proc and insert data by ordinal columns into one or more sheets formatted according to sql...

Try

DTSSource(1).Name

DTSSource(2).Name

etc

You could try to reattach the database using the .mdf and .ldf files but I cannot remember if this works with unattached databases

They will always be treated as a literal unless used in wilcard searching with LIKE and PATINDEX in which case you need to 'ESCAPE' them, ie

LIKE '%[%]%'

LIKE '%[_]%'

or

LIKE '%\%%' ESCAPE...

PIVOTing is best done at the presentation level, however,

can you post the DDL for the EmployeeHours table

What does "Mon" signify?

Is it Monday's value?

If so where is Tue,Wed etc?

What is the...

How do you most of you decide to use openrowset versus bcp versus DTS

Whichever is easiest, gives the best...

Not sure how you get the values but presuming ColTitle1 contains the column name then you could do something like this

On Error Resume Next

DTSDestination("Col1") = DTSSource(ColTitle1)

If Err.Number <>...

There has to be a better way...

Not that I can think of

Firstly, it/IT is an ignored (noise) word and unless you have removed it from the noise list you will not be able to search for 'IT' unless it is a...

You have ActivityID of 40 & 50 in ActivityProgress that are not in Activities Table

You have ActivityID of 160 in Activities Table that is not referenced in ActivityProgress

What constitutes a...

Also use profiler and look for high cpu and duration values. This will give you what procs and sql is consuming resources.

You could leave the first part in the function and put the second in the join like this

CREATE FUNCTION dbo.fn_Calendar_GetEndDate (@SDATE DATETIME,@DURATION INT)

RETURNS datetime

AS

BEGIN

DECLARE @EDATE DATETIME...

No you cannot use the function in that way.

Why not take the query from the function and join it to the INSERTED table?

What code is in the function?

Thanks for the feedback Tom

I am a bit confused, the regex you say you want to get to, ie

^: ([0-9]{9}): *([0-9]+)

will match any number combination

or are you...