Your requirement sounds like you'd like to change some values based on a time "trigger".

This is not what a trigger is designed for.

A trigger on a table is activated after...

Nothing to be sorry for!!

When looking at the OP's last login time I'd expect he's following my advice, 'cause I...

From my personal point of view and with respect to the original question: no.

Even with an identity column a mixed insert or an update...

Well, you're right, the ORDER BY Clause will lead to wrong results 🙁

Nevertheless, I'd "blame" it on the data...

At this point I'd like to ask you to do some research.

Here are two possible sources:

http://www.sqlservercentral.com/articles/SS2K5+-+XML/3022/

and

BOL, section "FOR XML clause".

To play around with the various options of FOR XML is...

jcrawf02 (9/14/2009)

---

Lutz, gotta tell you, you're a genius! Your direction given in http://www.sqlservercentral.com/Forums/Topic785337-1291-1.aspx has answered all questions, no more need for forums.

To quote:

The answer is simple as well:

SELECT *...

For what type of front end?

Where do you want to convert the date format - SSRS or Database?

If the latter I strongly recommend against it. Date formatting should be done at the front end side...

In Management Studio, right click on the Server in the Object...

Does your console app allow for parallel processing?

What is the hardware configuration of your Server? (e.g. How many CPU's and how many of them usable for SQL Server?)

Do you import...

Duplicate post.

Please continue here .

Hi phanatico,

posting way over 400 lines of VB code in an SQL forum probably won't find many volunteers to look at it...

You should try to narrow the issue down to...

You're very welcome. 🙂

If you'd like to (or have to) look deeper into XQuery I'd like to redirect you to one of my...

Change your select clause to

SELECT c.value('Name[1]', 'varchar(50)'),

c.value('EmpNtId[1]', 'varchar(30)'),

c.value('CreateBy[1]', 'varchar(30)'),

...

It fails, but it's successful at the same...