You don't...

Would you please post some sample data from EventLog so we have something to test against?

Also, please post your expected output.

It seems like this function is a little oversized for...

Percentage of what?

Please show us what you've done so far in the same ready to use format as you found on the post I referred to.

If your columns are dynamic then PIVOT won't help you since it it's based on displaying predefined columns.

You might want to look into DynamicCrossTabs (see the link in my signature).

It depends.

Usually, if you just run it in Management Studio or within an view, it will only be displayed.

If you want to use it afterwards you need to store it...

Maybe you could add a simple monitoring table (three columns: procedure, status, changetime).

When you start proc1, change the status to 1, at the end of proc1 change it back to...

If you query a table directly, it should always display a datetime column in the following format: 2009-01-13 00:00:00.000.

Could you please provide some samples where you see that behaviour?

One reason...

It depends...

Will the file always have the same name and being located in the same...

What data type did you use to store the xml data? If the column is of xml data type, an index will be a HUGE help!

Straight from BOL:

An XML...

Where is your large xml file stored?

Now that we've clarified the version you're using, you could store the file in a table with an ID column and an xml data...

Please have a look at this post .

Similar problem.

Jeff Moden (1/6/2010)

---

ToddJames (1/6/2010)

---

What am I doing wrong? Grr.

select *,mycolumn=

CASE

WHEN mycolumn= 'PSI' THEN mbrproductcode

WHEN mycolumn= 'PPO' THEN 10001912

WHEN mycolumn= 'PP1' THEN 10001910

WHEN...

Nothing really changed except you removed the reference to your column.

Please reread my previous reply.

If it's working or not: give it a try in SSMS. But the answer will be:...

It depends on the error message you receive.

I'd expect something like

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting...

Sounds like test or homework...

I can't think of a valid business rule to refuse good performing code...

Sorry, but I can't help here!