Thanks. Let's see - where would the button be to attach a file?

Got it. "Edit Attachments" Unusual button name...

I haven't been here in a long, long time. [ The pages look radically different now and I am not certain of all the capabilities ]

I hope...

That's it, Michael!  Did not see that number in my reference book. 

I don't see a SQL Style with dashes.  You could try the following:

SELECT GETDATE(), CONVERT( varchar(10), GETDATE(), 112),

             SUBSTRING( CONVERT( varchar(10), GETDATE(), 112), 1, 4) + '-' +...

Representing an Organizational Structure

Please do not cross-link.  Your question will get answered. 

Cross Link

Not sure, but it sounds like you may need two things: 

1) LastUpdate field with a datetime or timestamp designation to retrieve the last record. 

B) A Commit Transaction wrapped...

Hmmm...

My script returns:

sort                

--------------------

1

1cc2

1dd

1x4

10

11

380-41-3a

1110-345-720a3

The Robert Davis script returns:

sort                

--------------------

1x4

1cc2

1110-345-720a3

1dd

380-41-3a

1

10

11

I think the latter is not as good...

Way better!  Or, is that way more better?   

Thanks John!

I was VERY errant in not noting who wrote this to give proper credit!  I got this off a posting on this site.  If you wrote it, please respond so...

I have found sp_who2 to generate better results, but it does not take parameters well...

Not sure, but is this what you want? 

DECLARE @Person TABLE( PK integer, Addr varchar(10), [name] varchar(3))

INSERT INTO @Person

SELECT 1, 'NewYork', 'abc'

UNION

SELECT 2, 'CA', 'DEF'

SELECT...

Thanks Jeff.  We've seen it with just one index!  That is why I found it odd?  (and to further complicate this, it was an "archived" table - data from the...

Thank you all.  Oddly enough, we can see a difference immediately when we drop an Index in Development.  That would leave me to believe that the statistics are being updated. ...

Yeah - that was my first attempt.  I should have noted that as well.  Sorry.