drew.allen (3/11/2011)

---

I'm not sure about other tools, but I've found that for creating complex XML structures using T-SQL, you're better off using FOR XML EXPLICIT instead of any of the...

If you could provide some ready to use test data (as described in the first link in my signature) I could give it a try. (I'd like to test my...

Easy fix: the line break < br > is part of the link. Remove it from the end of the link to see the secret information...

After a second look at your query the reason might be the accidential cross join due to

ON PortfolioGroup.entity_id = PortfolioGroup.entity_id

that might better be

ON Portfolios.entity_id = PortfolioGroup.entity_id

The error message tells you exaclty what the problem is: you're trying to create an XML structure that exceeds 2GB.

Are you sure you want to create such a large XML...

Something like this?

SELECT CONVERT(CHAR(10),Tablename.Logindate,110) + ' ' + CONVERT(CHAR(8),Tablename.Logindate,108)

Also, the WHERE-clause-check trigger would need to cover WHERE 1=1, too.

I actually like your last approach, Gianluca. Instead of trying to analyze the code, check for the number of affected...

???

I'm talking about a set based sql code solution.

Think of the task that needs to...

Please describe the rules how to assign an XML tag name to a specific value.

The way it seems like it is designed: the data are inserted based on the "position"...

GSquared (3/9/2011)

---

krishusavalia (3/9/2011)

---

Hey G ,

Your solution is awesome. It was interesting and i learn something new.

But in my senario, I have more than 2 million rows and for every row...

Since you're trying to lock a specific row my guess is you're using a c.u.r.s.o.r. or any other kind of loop to process your data.

If that's the case, you should...

All I can recommend is to read Gails great blog series[/url].

But I'm not sure if it's really a parameter sniffing issue (usually it would run fast the first ime and...

@pverma,

if you start a new thread with the very same issue as posted in an earlier thread, you could at least mention it, so people trying to help will know...

Ninja's_RGR'us (3/7/2011)

---

...

Another option I've use with worked well was to do a left join on both tables and then check the true/false useing isnull or a case for a more...

krishusavalia (3/7/2011)

---

Thanks Lutz

My Query is going more that 10 layer down in herarchy. and If i made sample query then its useless.

I can't post the real query. It has company's...