Viewing 15 posts - 691 through 705 (of 5,678 total)
Alan above walked you through XML in general, but... um... hm. A few comments (not on Alan's work, that was pretty thorough).
for text its nvarchar
No. For text it's...
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
May 8, 2013 at 6:28 pm
Carlos, so you're looking for how we usually approach creating many to many tables?
The relationship is (role)1..N to 0..1(groups)
This would usually imply that you have a 1 to...
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
May 8, 2013 at 6:19 pm
TecNQ (5/8/2013)
Thanks again.The last code needed a GROUP BY to work, but it works!
The first one didn't. It came back saying "Incorrect syntax near DISTINCT".
I assume that's the COUNT(DISTINCT...)?
Cheers
Yeah, sorry,...
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
May 8, 2013 at 6:07 pm
TecNQ (5/8/2013)
But as you may have already seen, it's reporting the same COUNT()...
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
May 8, 2013 at 5:45 pm
TecNQ (5/8/2013)
Thanks Craig. I found that link too (yes I can use Google), but I didn't understand it. Your reply made more sense actually. Thanks
No worries, usually it's a case...
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
May 8, 2013 at 5:27 pm
kevinv (5/8/2013)
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
May 8, 2013 at 5:19 pm
In case you're simply having google-fu failure, here's the link explaining the code:
http://msdn.microsoft.com/en-us/library/ms186734.aspx
MSDN article on ROW_NUMBER().
OVER is a keyword to tell it you're about to tell it your intentions, that's...
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
May 8, 2013 at 5:07 pm
EDIT: This is a textwall, I know, sorry for that but I got on a roll. Peter, a response to you starts about 1/3 of the way down. /EDIT
L'...
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
May 8, 2013 at 4:40 pm
alan_lynch (5/2/2013)
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
May 2, 2013 at 6:26 pm
CREATE PROCEDURE TestProc
WITH ENCRYPTION
AS
...
GO
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
May 2, 2013 at 6:23 pm
Final check, what does it say when you rt-click -> Script Stored Procedure as -> Create To -> New Query Editor window?
My guess is they most likely encrypted the procedures....
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
May 2, 2013 at 6:11 pm
There are a couple of ways that can be grayed out, but to get rid of a series of Q&A... are you the sa on the box or DBO 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
May 2, 2013 at 5:56 pm
L' Eomot Inversé (5/2/2013)
Evil Kraig F (5/2/2013)
SQLRNNR (5/2/2013)
This is sooo trueLOL, I know. I've actually printed it out and hung it on my cube wall.
Take care not to forget...
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
May 2, 2013 at 3:41 pm
SQLRNNR (5/2/2013)
This is sooo true
LOL, I know. I've actually printed it out and hung it on my cube wall.
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
May 2, 2013 at 3:17 pm
Last thing first. 🙂
L' Eomot Inversé (5/1/2013)
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
May 1, 2013 at 1:56 pm
Viewing 15 posts - 691 through 705 (of 5,678 total)