Viewing 15 posts - 1,921 through 1,935 (of 5,678 total)
I don't believe you'll be able to do this without Explicit because you're changing the attribute tags instead of internal values. I'm not an expert on XML via T-SQL,...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 20, 2012 at 4:53 pm
ChrisM@home (1/20/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 20, 2012 at 4:46 pm
meichner (1/20/2012)
Primary Key GroupCode
Description VarChar(50)
Users
Primary Key UserID
Foreign Key GroupCode
UserName VarChar(50)
Menu Items
Primary Key MenuID
Foreign Key GroupCode
MenuName VarChar(50)
I want to be able to display every possible combination of UserName and MenuName for...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 20, 2012 at 4:44 pm
I'd personally use your many to many table to hold the scores, as well as use it as your linker table.
You're storing scores according to a composite key of CategoryID...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 20, 2012 at 4:39 pm
TheRealDJ (1/20/2012)
Perfect, thanks so much for the quick response!
My pleasure, thanks for setting up sample data and structure and showing your work so we could help you quickly and efficiently....
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 20, 2012 at 2:38 pm
ChrisM@home (1/20/2012)
Evil Kraig F (1/20/2012)
ChrisM@home (1/20/2012)
- don't treat a problem as islands-n-gaps if it isn't, because whatever method you use to resolve it, it's going to cost you.
Chris,
The only problem...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 20, 2012 at 2:36 pm
Coupla things. You needed to stop grouping by the customer ID in the Group BY and you needed to have the REPLACE/STUFF component work off FirstName/LastName combination instead of...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 20, 2012 at 2:26 pm
ChrisM@home (1/20/2012)
- don't treat a problem as islands-n-gaps if it isn't, because whatever method you use to resolve it, it's going to cost you.
Chris,
The only problem with this statement is...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 20, 2012 at 2:18 pm
shahgols (1/19/2012)
I was told by someone that they have two servers that are exactly the same in every regard, and two databases on those servers that are also exactly...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 19, 2012 at 5:10 pm
Brandie Tarvin (1/18/2012)
Of course, every time I get a moment to work on this issue, another bigger fire...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 19, 2012 at 4:59 pm
Jack Corbett (1/19/2012)
Brandie Tarvin (1/19/2012)
Is that a chicken hawk?Are you worried because you are a chicken?:-P
"I say, I say boy" - Foghorn Leghorn
ChickenHawk: *sigh* WHAM!WHAM!WHAM!WHAM!WHAM!
I always loved when...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 19, 2012 at 4:52 pm
eseosaoregie (1/19/2012)
thanks, this is what i wanted. Apologies for my poor explanations at the beginning
No worries, it happens. I wasn't explaining myself well either. Happy to help, good...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 19, 2012 at 4:47 pm
Can you pull the estimated .sqlplan for the process? You'll find instructions if you need it in the second link on the left in my signature.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 19, 2012 at 4:40 pm
SQLRNNR (1/19/2012)
Evil Kraig F (1/19/2012)
If you can restore the data independently of each other, different databases for...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 19, 2012 at 3:34 pm
Scott D. Jacobson (1/18/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 19, 2012 at 3:30 pm
Viewing 15 posts - 1,921 through 1,935 (of 5,678 total)