i adapted and created some sample data.

Declare @MyDay datetime = '2015-01-01'

;With MYFirstNames(FName) AS

(

Select 'Leonardo' UNION ALL

Select 'Brad' UNION ALL

Select 'Arnold' UNION ALL

Select 'Mark' UNION ALL

Select 'Matt' UNION ALL

Select 'Bruce'...

if StartShift and EndShift are DateTime data types, you can just use Datediff to get the period of time.

SELECT DateDiff(minute,StartShift,EndShift) from yourtable.

if it's a TIME data type, you have to...

i think the OP might be copy/pasting from the Powershell ISE and getting whitespace tot he right of the values, but that's a product of the results panel, and not...

i've done this with excel automation, which you can do in a script task,

this is a rough example i modified, but I did not explicitly test against your file.

basically, i'm...

you have to create the table explicitly, and then insert into the table; you cannot take advantage of the INTO #temp without jumping through extra hoops using openquery / openrowset

CREATE...

what specific error do you get? also look in the SQL error log for a detailed error instead of an "ended in...

i have a couple of model DDL triggers that execute as specific users; i think that's the way...

i think you'll need EXECUTE AS OWNER in the trigger; otherwise it's the end users context, i think, who might not have access to msdb, and thus the ability to...

in cases like this, i suggest not working around the error, but addressing the error head on: huge query that exceeds 4K or whatever.

instead of having the report pass a...

i'd go with doing it physically.

if you really want to automated it,

you might do it via xp_cmdShell and the MOV...

i use this snippet a lot; but it is centric to a single database, but i bet it gets you 90% there.

it assumes I KNOW the destination for the...

for me, mentally,

CROSS APPLY = INNER JOIN

and

OUTER APPLY = LEFT OUTER JOIN

so if anything is going to consume the results of the previous JOIN/CROSS (ie using the...

this is syntactically correct,, and gives you your start and end indicators, as a set base doperation.

is this more like what you are after?

SELECT cdsDescription,st.[1stPos],en.[2ndPos]

FROM tbCompdistances

CROSS APPLY(SELECT CHARINDEX(' ',cdsDescription) AS...

something like this is what i slapped together; does this look right?

UPDATE MyTarget

SET

MyTarget.[IsCurrent] ...

here's the article i have bookmarked from Paul Randal, as mentioned above.

http://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-consistency-checking-options-for-a-vldb/