Viewing 15 posts - 4,966 through 4,980 (of 5,678 total)
sqlrocks79 (11/11/2010)
Additional messages in the SQL Server error log and system event log may provide more detail.
Have you checked these?
It sounds like something's interfering with file access permissions. ...
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
November 11, 2010 at 4:54 pm
It is correct, but Money is a field of four decimal places. It's working as expected.
Wrap the result with a CONVERT( DECIMAL (19,2), <function here>) to go to two...
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
November 11, 2010 at 4:49 pm
Manjeshwar,
I've used a form of the serial update here which should cure your pain on this specific instance. If you want the 'full rules' to keep you safe from...
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
November 11, 2010 at 4:46 pm
I think I'm confusing myself.
Here's my function checks so we all understand what the heck I'm talking about as I ramble on a bit here:
DECLARE @testDate DATETIME
SET @testDate = GETDATE()
--PRINT...
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
November 11, 2010 at 2:36 pm
After this where clause in the cte...
WHERE
-- First, we only get...
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
November 11, 2010 at 2:10 pm
WayneS (11/11/2010)
select DATENAME(weekday, 0); -- = Monday
select DATENAME(weekday, -1); -- = Sunday
select DateAdd(day, -7, 0); -- = 18991225
So, take the number of days between 18991225 (Date=-7) and the date...
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
November 11, 2010 at 12:35 pm
Using this article as a reference:
http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/
(Note, I searched here in the search box with the following: rows to delimited string)
Please note how I adjusted your data setup. This makes...
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
November 11, 2010 at 12:24 pm
GilaMonster (11/11/2010)
http://twitter.com/#!/GFritchey/status/2742141222658049
Websense hates me. Have to check that from home.
BWAHAHAHAHAHAHAHA. Dear gods, did I just generate a meme?
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
November 11, 2010 at 12:10 pm
Thanks Gus, you just helped me understand a little bit more of it too. 🙂
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
November 11, 2010 at 12:07 pm
GilaMonster (11/11/2010)
Dunno if you noticed, I've been getting kudos on Twitter for your sig. 😀
ROFL. No, I hadn't. I tend to avoid Twitter, Facebook, et al. like they...
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
November 11, 2010 at 11:23 am
ejbatu1 (11/11/2010)
How would I add the codes in this query. ...
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
November 11, 2010 at 11:20 am
kkishore1010 (11/11/2010)
I mean both server A and B are in Cluster Node.Thanks,
kumar
Yeeps. I missed that. I blame a lack of coffee. Elliot and Steve are correct (as...
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
November 11, 2010 at 11:16 am
CELKO (11/11/2010)
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
November 11, 2010 at 10:47 am
CirquedeSQLeil (11/11/2010)
GSquared (11/11/2010)
GilaMonster (11/11/2010)
jcrawf02 (11/11/2010)
Craig Farrell (11/10/2010)
Must be the week...http://www.sqlservercentral.com/Forums/Topic1019000-392-1.aspx
Nice sig 😉 To be perfect, should start with "Yea" instead of "'lo", and have an extra thy in "Thy...
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
November 11, 2010 at 10:05 am
This error is the key component:
"A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name...
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
November 11, 2010 at 9:50 am
Viewing 15 posts - 4,966 through 4,980 (of 5,678 total)