To summarize Tom's statement: "It depends!" 😀 (Tom, correct me, if I'm wrong)

You run multiple queries against the same (namespaced) xml source.

Therefore, you'd need to declare the names pace for each and every query against that xml source. Right now it's just...

based on your description your orignal approach isn't that far off...

SELECT [event] FROM [yourTable] WHERE [date] = @currentdate

The "tricky" part is how you store the event dates in the [date]...

Run the code.

Read the error meassge.

Try to figure out what it means (e.g. column name not defined in the referenced table?)

Try to resolve the issue.

If you can't figure...

a) the end tag < / Ridge > has no start tag

Hard to tell without knowing anything about your table structure...

Please provide more details. See the first link in my signature on how to do it to get a coded and...

errmm... :unsure:

Did you notice what I mentioned as b) two posts before, restated in my previous post?

What happens if you'd run the following statements separately nad in the given order on database SedaliaHLB_RenCS (those are the sprocs called within the job steps) ?

Execute HLBInventoryCheckAllAccepted

Execute HLBInventoryCheckUnaccepted

EXEC HLBInventoryCheck

I still don't understand.

What's the difference between @lastdate and convert(datetime, datename(month,@lastdate) + " " + datename(day,@lastdate) + " " + datename(year,@lastdate) + " 00:00") ?

If all you're trying to do...

Use a subquery (or CTE) to select the TOP 3 order VoteCount and join that back to your original table on Detailname in an update statement.

As a side note: ready...

see item b in my previous post.

Side note: It usually helps if the error code is included in the post, not just mentioned...

I don't understand your requirement.

Please post table def, sample data and expected result in a ready to use format as described in the first link in my signature.

I'm pretty sure you won't be able to run it using SS2000...

SQL Server requires single quotes, not double quotes.

The issue is within the last part of your statement: you'd need...

There are severa lissues with that new file:

a) the end tag < / Ridge > has no start tag

b) There is a new node level (Mains) introduced that needs to...

It sure will.

Take the code snippet for the child table.

Replace 'Childs/Child' with 'Father' in CROSS APPLY T.c.nodes('Childs/Child') U(v)

Assign a different temp table to hold the output data, if needed for...