There are a couple of different ways to handle this. You can use an Execute As statement to impersonate a user or you can sign a procedure with a...

SalesPersonID and ContactID are 2 different fields in the SalesOrderHeader table. The SalesPersonID is not 278 when the ContactID = 'Carla L. Eldridge'. That's why you are getting...

Select ltrim(rtrim(substring(CONVERT(CHAR(19), getdate(), 0),12,10)))

are the group tables all the same structure? If not, then are you stubbing out the fields that don't exist between tables? do all the group tables start with...

You are correct in saying that it has to do with the file groups. When the fourth FileGroup is created it is assigning the files at the same time....

if you set the results to a variable, then you can try this

declare @tper varchar(max), @pos int

set @tper = ''

select @pos = position, @tper = @tper + nom +...

why wouldn't you just comment this code out or remove it altogether?

I setup a SharePoint web site that I share out to the rest of the company. As I find useful scripts, I post them out to the site. ...

It's interesting. I'm getting the same type of results. When I put the results into a temp table, then the query return immediately.

select item as item1 into #temp1...

can you provide table layouts, sample data and expected results?

Just found out by stopping and starting DTC on developer's machine, freed the lock. But I should still be able to delete the lock through SSMS, no?

Need more info than this. What are the 2 middle columns? What is the logic needed to calc the dates? etc...

You were looking for 441, but your example showed 444,411 which won't match anyway. I added these two to the original and 2 of the 3 showed up, which...

SQL's trying to do an implicit conversion of the varchar field and failing. '441,443' cannot be converted because of the comma. This will work, but it could cause...

Have you tried rounding?

select round(DATEDIFF(DAY, 'May 23 1992', 'May 23 2009')/365.2422,2)

select round(DATEDIFF(DAY, 'May 23 1992', 'May 25 2009')/365.2422,2)

select round(DATEDIFF(DAY, 'May 23 1992', 'Nov 23 2009')/365.2422,2)