Viewing 15 posts - 1,891 through 1,905 (of 5,502 total)
christophe.bernard 47659 (2/18/2011)
thanks for your time and your knowledge ..that's work ..yes 🙂 🙂 !
I'm a beginner with t sql and i'm not sure to understand your code...
February 18, 2011 at 3:55 am
Please don't start a new thread if you have additional information to a question already posted.
Original post including a first reply can be here
February 17, 2011 at 2:37 pm
please read and follow the advice given in the first link refernced in my signature and provide ready to use test data together with your expected output and what you've...
February 17, 2011 at 1:25 pm
GSquared (2/17/2011)
...Yes, at camelsexchange.com. :w00t:
Must be a pain for the camel. (They still use bricks for it, right?) :pinch::crying:
February 17, 2011 at 1:20 pm
I'd use either a LEFT OUTER JOIN or a NOT EXISTS subqry.
February 17, 2011 at 12:01 pm
Brandie Tarvin (2/17/2011)
What is the effect of building a non-clustered index over a clustered index?
The table already uses CoverageKey and Effective (both ASC) as it's clustered index. Include only works...
February 17, 2011 at 11:30 am
I'd rather go with
SELECT
x.i.value('(@parentStructId)[1]','int') AS ParentStructID,
x.i.value('(@family)[1]','int') AS Family,
x.i.value('(@subFamily)[1]','int') AS SubFamily
FROM @xmlFile.nodes('/FamilyAndSubFamily/myStruct') as x(i);
It performs better than the x.i.query('.').value approach. (see execution plan and statistics on a larger data volume)
February 17, 2011 at 11:07 am
LutzM (2/16/2011)
Examples:
Product 2 is available until 2-8-2011. How do you know it's not available after that?
Product 5 is not available starting from 2-9-2011....
February 16, 2011 at 2:59 pm
How do you come to this conclusion?
Examples:
Product 2 is available until 2-8-2011. How do you know it's not available after that?
Product 5 is not available starting from 2-9-2011. How...
February 16, 2011 at 1:33 pm
Without any more details (like table def, sample data, expected result and the like) it's hard to tell.
My guess would be there are more than one rows with nome ='Albertino...
February 16, 2011 at 1:23 pm
Pouliot Philippe (2/16/2011)
Or i must will go with Exam 70-432(Sql Server 2008)
What do you think about that...
February 16, 2011 at 1:18 pm
Rich Yarger (2/15/2011)
February 16, 2011 at 12:17 pm
GilaMonster (2/15/2011)
LutzM (2/15/2011)
GilaMonster (2/15/2011)
In your example index 1 is redundant (the columns match exactly a left-based subset of another index), index 2 is not.
Wouldn't index 1 be used if a...
February 16, 2011 at 11:44 am
Rich Yarger (2/15/2011)
DECLARE @XML xml;
SET @XML ='
<Root>
<Customer ID="1" FirstName="John" LastName="Doe" Street="123, Fake Street" City="Anytown" State="NY" Zip="11280" HomePhone="555-123-4567"
...
</Transactions>
</Checking>
</Accounts>
</Customer>
</Root>'
SELECT
...
February 15, 2011 at 5:29 pm
Rich Yarger (2/15/2011)
...And that is why I am a newbie!
Thanks again Lutz!
😉
You're welcome. 🙂
(I just got a little confused since you used it correctly before... I didn't wanted to come...
February 15, 2011 at 5:17 pm
Viewing 15 posts - 1,891 through 1,905 (of 5,502 total)