Have a look at sp_help_jobactivity.

Here...

There's no parser needed. As stated before, you can use the XQuery syntax to extract the data. Did you have a look at the blog I linked in my previous...

Based on the very limited information all I can suggest is to look into XQuery syntax.

A few scenarios with coded solutions can be found at Jacob Sebastians blog.

If you're looking...

It might be an issue of 64 vs. 32 bit (compiled using 32 bit, then transferred to a system with 32 bit).

A quick google search using the original error message...

You might want to to try the CrossTab approach as described in the related link in my signature.

PS: Since it sounds like homework I think it's more helpful to provide...

Please don't cross post.

There's already a discussion at this thread.

Thank you.

And here's the query to search for a substring:

SELECT *

FROM @tbl t1

WHERE col.exist('//*/text()[contains(.,sql:variable("@id"))]') = 1

Depending on the size of the xml data this may take a...

Using PIVOT makes it rather complex to add the total dynamically.

You might want to use the DynamicCrossTab approach instead. For details please see the related link in my signature.

I'm not sure if I understood correctly, but it seems like you're looking for the "exist" method to query the xml data.

Here's a short sample:

DECLARE @tbl TABLE

(

id INT,

col...

er.sivaganesh (1/29/2012)

---

in a single store procedure iam just inserting values for 3 table in that among the 3 table the seond...

If the number of rows is really representative (a few hundred at max) then...

Can you post the actual execution plan?

Based on that row count there's just a limited information where the actual problem is.

Other than that I recommend to try the divide'n'conqueur approach:

Store...

It's more an UNPIVOT issue than a PIVOT.

Here's a code snippet based on your sample data. Please note the way the sample data are provided in a ready to use...

If I wouldn't be involved,...