Viewing 15 posts - 1,891 through 1,905 (of 4,080 total)
Jeff:
The code I posted was tested before I posted it. It works for the data shown. SQL has no problem doing an implicit conversion from...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 4, 2010 at 7:11 am
Thanks, Jason.
The reports of my death were greatly exaggerrated.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 3, 2010 at 8:32 pm
Thanks to you as well, Emperor Paulpatine.
I'm not surprised that the ITVFs are faster than the scalar functions, but I am surprised by the percentage difference for functions that don't...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 3, 2010 at 8:23 pm
Congratulations, Jack!!
... and belated congratulations Saint Lynn!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 3, 2010 at 7:04 pm
Thanks, Dave. Exactly the kind of information I was looking 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
February 3, 2010 at 6:45 pm
Curiousity question. Have you seen any documentation about the performance of scalar functions which do NOT do data access compared to inline table valued functions which produce...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 2, 2010 at 11:13 pm
I hope Willem gets the job. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 2, 2010 at 11:07 pm
You might also be able to solve your problem using a Common Table Expression (cte) something like this
;with cte as
(
select purchid, vctmovementmonth, dataareaid, -- and any other columns...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 2, 2010 at 11:01 pm
Paul,
I assume you are talking about data access within scalar functions, not inline table-valued functions. Data access through ITVF's can be ruthlessly efficient (best I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 2, 2010 at 10:51 pm
Do you even need the temporary table?
You can CAST the text column as VARCHAR(MAX) and do the REPLACE in one UPDATE statement
create table sample (data...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 2, 2010 at 10:39 pm
Paul White (1/26/2010)
BrainDonor (1/26/2010)
http://www.sqlservercentral.com/Forums/FindPost853470.aspx
The same message three times in a row - he's determined someone will write...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 26, 2010 at 11:07 am
jcrawf02 (1/25/2010)
The Dixie Flatline (1/25/2010)
Hello...Hello...
Is this thing on?
Norm! 😀
Thanks, Jon. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 25, 2010 at 4:38 pm
A new way to confuse Steve? BRILLIANT!!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 25, 2010 at 4:37 pm
Hello...
Hello...
Is this thing on?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 25, 2010 at 3:22 pm
Work. I'm over 250 posts behind in just reading The Thread.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 19, 2010 at 10:40 am
Viewing 15 posts - 1,891 through 1,905 (of 4,080 total)