Viewing 15 posts - 1,771 through 1,785 (of 5,502 total)
Ninja's_RGR'us (3/11/2011)
Actually it doesn't :w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t:
Easy fix: the line break < br > is part of the link. Remove it from the end of the link to see the secret information...
March 11, 2011 at 11:09 am
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
March 11, 2011 at 10:20 am
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...
March 10, 2011 at 4:40 pm
Something like this?
SELECT CONVERT(CHAR(10),Tablename.Logindate,110) + ' ' + CONVERT(CHAR(8),Tablename.Logindate,108)
March 10, 2011 at 4:35 pm
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...
March 10, 2011 at 2:41 pm
Narayana_17 (3/10/2011)
Hi can you tell how to use set locks .Possible explain with an example please.
Thanks
Lakshman
???
I'm talking about a set based sql code solution.
Think of the task that needs to...
March 10, 2011 at 11:22 am
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"...
March 9, 2011 at 4:32 pm
GSquared (3/9/2011)
krishusavalia (3/9/2011)
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...
March 9, 2011 at 11:35 am
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...
March 8, 2011 at 3:57 pm
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...
March 8, 2011 at 3:49 pm
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...
March 8, 2011 at 11:33 am
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...
March 7, 2011 at 4:25 pm
krishusavalia (3/7/2011)
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...
March 7, 2011 at 4:22 pm
After some reformatting I figured the both queries used in the UNION statement are pretty much identical except for the join to BatchKeg and Keg and the ch.FlexTank = 'true'/'false'...
March 7, 2011 at 3:09 pm
Please provide table def and sample data of the source table as described in the first article refernced in my signature. Also, please post your expected result based on your...
March 7, 2011 at 2:41 pm
Viewing 15 posts - 1,771 through 1,785 (of 5,502 total)