Viewing 15 posts - 15,766 through 15,780 (of 26,486 total)
What is interesting is that approximately a third of the respondents have gotten the question wrong.
April 26, 2010 at 3:13 pm
By the way, if the row_number is a part of the query, you really don't need a function. Just use this:
replicate(char(64 + (((@alphacount - 1) % 26) + 1)),(((@alphacount...
April 26, 2010 at 3:06 pm
I'm still following this thread, but I have yet to figure out what it is you are trying to accomplish. Care to explain and show us what should be...
April 26, 2010 at 2:54 pm
lmu92 (4/26/2010)
Lynn Pettis (4/26/2010)
... Another reason for ensuring consistancy when coding.I guess as long as we're not forced by db collations we're getting lax "by nature"...
At least I do. :blush:
Takes...
April 26, 2010 at 2:41 pm
Pork Chop Launcher! (in respect of Cardinal Moden!)
April 26, 2010 at 2:31 pm
lmu92 (4/26/2010)
BobA 66314 (4/26/2010)
I use OPENXML because it is faster, and the task occurs while online user waits. Any idea why it ignores this...
April 26, 2010 at 2:22 pm
Something like this maybe?
CREATE FUNCTION [dbo].[AlphaCounter] (
@alphacount int
)
RETURNS table
AS
RETURN select replicate(char(64 + (((@alphacount - 1) % 26) + 1)),(((@alphacount - 1)/ 26)...
April 26, 2010 at 2:08 pm
bteraberry (4/26/2010)
He said he wanted arewrite with out subquery or CTE
but yes, without that stipulation the CTE would be plenty easy.
Why would we want to do that if...
April 26, 2010 at 2:01 pm
homebrew01 (4/26/2010)
There are probably no backups, so it may not matter how the t-log is shrunk.
Probably right. I know I shouldn't be, but I am somewhat concerned about the...
April 26, 2010 at 1:52 pm
homebrew01 (4/26/2010)
Lynn Pettis (4/26/2010)
Also, I hope you duly noted that I RECOMMENDED AGAINST changing the recovery model to SIMPLE and back to FULL.
So ... you would advise against creating a...
April 26, 2010 at 1:24 pm
Richard M. (4/26/2010)
homebrew01 (4/26/2010)
Lynn Pettis (4/26/2010)
Also, I hope you duly noted that I RECOMMENDED AGAINST changing the recovery model to SIMPLE and back to FULL.
So ... you would advise against...
April 26, 2010 at 1:24 pm
dbowlin (4/26/2010)
Check this out:Hopefully it will help.
Another approach you can use is just put the email task as the next step with a failure precedence constraint.
Just to make it easier...
April 26, 2010 at 12:59 pm
Lynn Pettis (4/26/2010)
striker-baba (4/26/2010)
That was apt solution for my problem..
I changer the recovery mode to simple and back to full and it worked gud..
one of my friend suggested...
April 26, 2010 at 12:50 pm
striker-baba (4/26/2010)
That was apt solution for my problem..
I changer the recovery mode to simple and back to full and it worked gud..
one of my friend suggested me to...
April 26, 2010 at 12:48 pm
Looks just as easy with a CTE:
with GroupData as (
SELECT
Key1,
MAX(VAL1) as MAX1,
SUM(VAL2) as SUM2
FROM
@TableVar...
April 26, 2010 at 12:26 pm
Viewing 15 posts - 15,766 through 15,780 (of 26,486 total)