Viewing 15 posts - 1,321 through 1,335 (of 4,080 total)
Is anyone else having trouble posting this morning?
Steve, I have an answer for the OP in this thread and it won't post my reply.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 1, 2010 at 7:53 am
Chris I looked at your code, but I'm afraid I can't visualize the results you want from the description you gave. (It's late and my mental telepathy is breaking...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 30, 2010 at 10:13 pm
Don't be confused by a limit on how much of the data you can DISPLAY at one time. That may be a setting in SSMS.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 30, 2010 at 10:06 pm
Add a PRINT @@rowcount immediately after the SET statement. Bet a nickel that it is greater than 0.
If so, think about *why* and let...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 30, 2010 at 10:00 pm
He's right, it's much cleaner if you can use NULLs instead of spaces to denote absence of value.
Thank you, Mr. Celko. Or may I call you "Ming"...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 30, 2010 at 1:21 pm
GilaMonster (9/29/2010)
Grant Fritchey (9/29/2010)
GilaMonster (9/29/2010)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 29, 2010 at 7:28 pm
Dates in XML are just character strings. Everything in XML is just a character string.
replace(@XML,'23-Aug-2010','24-Aug-2010')
replace(@XML,'2010-08-23','2010-08-24')
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 29, 2010 at 2:24 pm
A simple way is to simply CAST () your xml as VARCHAR(MAX) and then use the REPLACE() function to make the substitutions you want.
declare @xml xml = 'your example above'
select...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 29, 2010 at 2:04 pm
You're very welcome. I would be interested in hearing the production volumes you are running through this and how it performs.
Best of luck...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 29, 2010 at 1:56 pm
Jack Corbett (9/29/2010)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 29, 2010 at 9:58 am
Alvin Ramard (9/29/2010)
"So I feel there needs to be a thread for...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 29, 2010 at 8:48 am
It's remarkable how many people don't get the concept that the manager's contribution to the team effort is support. The best managers I've ever had shared the view...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 29, 2010 at 7:11 am
Sorry not to be of more help. Good luck to you, Robert.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 28, 2010 at 1:36 pm
CirquedeSQLeil (9/27/2010)
Anybody here really good with permissions?http://www.sqlservercentral.com/Forums/Topic994116-359-1.aspx
Not me, Jason. Heck, I don't even like the taste of persimmons.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 27, 2010 at 10:25 pm
Robert, I am saying this seriously and not sarcastically. I question some of your assumptions about SQL if you think that high CPU cycles are a good...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 27, 2010 at 12:48 pm
Viewing 15 posts - 1,321 through 1,335 (of 4,080 total)