beakdan,
Thanks so much for taking the time post this awesome article.
It's EXACTLY what I needed! 🙂

I'm actually trying to create the xml file to be used...

Excellent Article! Thanks for posting this. We always find a way to query what we need.

This will allow ( for me at least ) to be a bit...

Awesome! Just what I needed 🙂

Couldn't be more straight forward that this...

Thanks for posting this !

Thanks Sean... I did check it out.... I typically stay away from dynamic sql when I can.

Thanks 🙂 ... I agree. That's the fun part... 🙂

Thanks Sean... I appreciate the heads up on that.

Embarrassed to say I did not consider that 🙁

I always use this when I need to compare dates...

select convert(char,getdate(),112)

RESULT = 20140328

hth,

..bob

This should get you there...

Create

ProcdynaSort -- exec dynaSort 1, 'DESC'

@SortID int,

@SortDirection char(4)

as

If @SortID = 1 and @SortDirection = 'ASC'

Begin

--Put your query and correct sort here

End

If ...

Your posted expected correct results are not correct.

This is the max Date for each...

MachineMaxDate

MachineA 2013-04-02

MachineB 2010-05-05

This will get you there....

Create table #t1 ( id int identity primary key,

dString char(20)

...

Is something like this an option?

Create table #t1 ( Col1 int )

Insert into #t1 ( Col1 )

Select SomeColumn from FirstTable

Insert into #t1 ( Col1 )

Select SomeColumn from NextTable

select * from...

After reading SSCrazy's post..... I agree with him.

A tracking table will be your best bet.

Please create your table in a dev db

and try this trigger out... Should get you what you need.

hth,

..bob

CREATE TRIGGER LocationAddUpdate

ON Location

AFTER UPDATE

AS

BEGIN

SET...

Thanks Everyone....

Dropping and ReCreating myself as a user, in the db having the problem...

seems to have fixed it.

I'd like to understand more about what exactly went south with...

Thanks B.

The user would be myself. I created the Job.

The job fires a stored proc that has other SP's..

one of the SPs does the purgepop.

If I execute the SP...

Great Article.

I am also interested in John Mitchel's question...

"Are elements and attributes functionally equivalent? "

tia,

Bob