SQLBill,

Unless you want a specific resample done, is it necessary to run sp_Updatestats if the database option of Auto Update statistics is...

SELECT [Name], dbo.udf_test([Name])

FROM (SELECT [Name] FROM [Table1] GROUP BY [Name]) a

ORDER BY [Name] ASC

David,

Why did you do an Alias here?  You didn't have a reference...

You may need a group by clause

Select T1.Date as [Current], MAX(T2.Date) as [Previous], DATEDIFF(dd, MAX(T2.Date), T1.Date ) as [Delta]

FROM Table T1

LEFT JOIN Table T2 on T2.Date < T1.Date

group by...

Since you didn't post the syntax you used, how would we know! 

Check out the join syntax with BOL.  Typically, a simple join syntax...

May be try something like this.

In as stored procedure, set pass in @ItemIDs = '101,103,105'

declare @Itemids varchar(1000)

declare @SQL varchar(8000)

set @SQL = 'Update tablename  Set State = 10...

I would use a join probably.

... from PURC_ORDER_LINE POL Inner Join OtherTable OT ON  OT.SomeField = POL.SomeField.

Then use the values from OT to populate the POL update.

Nope sorry.  In our databases the ShipNo is a seperate and indexed field.  Makes it pretty quick to locate what one needs.

Couldn't it be a simple Like statement??

select ommemo from tblordermemo where OmMemo like '%W034%'

Thanks PW.  I new there was a way and I just kept fiddling with views etc with no success.  I do appreciate your answer!!   I have read over and over...

Thanks all.  Apparently MS has some problems with the 64bit version.  We reverted back to the 32 bit version and everything seems to be working fine..

Perhaps you should consider the table first that has all of the records, Orders.  Then do Left Outer joins to it with the reasoning being that if we have an...

Pretty nifty Jeff.  Thanks for the coaching.  I use functions a lot because I hate to remember and then type all the syntax!!

Thank you David.  Trying to stay away from cursors.  Old habits die hard!!

You might try using a function like this:

CREATE FUNCTION fn_GetDays(@InSecs As int)

RETURNS varchar(36) AS 

BEGIN

  declare

  @GetDays varChar(200)

-- Get the Days, Hours, Minutes, Seconds returned with input in Seconds

-- Use:   Select...

Suggestion:  Put IdentityKey in detail table (D). Put LastCallID field in Master (M).   Have Detail OnInsert Trigger update M.LastCallID  with D.IdentityKey.  If you are always looking for the last call from all...