Viewing 15 posts - 1,921 through 1,935 (of 5,685 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,...
January 20, 2012 at 4:53 pm
ChrisM@home (1/20/2012)
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...
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...
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....
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...
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...
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...
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...
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...
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...
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...
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.
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...
January 19, 2012 at 3:34 pm
Scott D. Jacobson (1/18/2012)
January 19, 2012 at 3:30 pm
Viewing 15 posts - 1,921 through 1,935 (of 5,685 total)