Viewing 15 posts - 21,241 through 21,255 (of 26,484 total)
TheSQLGuru (5/1/2009)
Flo, are you getting your reads from SET STATISTICS IO ON? IIRC UDFs don't report IO correctly in this manner. Try getting them with Profiler.
Depending on how...
May 1, 2009 at 9:45 am
Paul White (5/1/2009)
I'm thinking that that TVF might be adapted to accept a string of characters to keep as a parameter.
Returning a set of characters to strip would allow Jeff's...
May 1, 2009 at 9:38 am
Ed (5/1/2009)
I prefer using:
DECLARE
@FromDate DATETIME,
@ThruDate DATETIME
SET @FromDate = CONVERT(VARCHAR, GETDATE(), 101) --mm/dd/yyyy 00:00:00.000
SET @ThruDate = DATEADD(DAY, 1, @FromDate)
SET @ThruDate = DATEADD(MS,...
May 1, 2009 at 9:34 am
Don't know if it is worth anything, but here is an In-Line TVF that will return 256 ASCII characters:
alter function dbo.ufnChar256()
returns table
as return(
with Numbers16 (
N
) as...
May 1, 2009 at 9:13 am
WayneS (5/1/2009)
I was (quickly) moving my mouse to go to the link to move to the next page on this thread, and a little popup window came up to...
May 1, 2009 at 8:08 am
Also consider that the routine already is complex. If you pass an INT you get an INT in return; if you pass a DECIMAL you get a DECIMAL in...
April 30, 2009 at 7:48 pm
Florian Reischl (4/30/2009)
Hi LynnNo. It's just a dictionary but the greatest I know (already 200,000 request within the last two hours).
Why? Is my English SO bad? :doze:
Heck no! I...
April 30, 2009 at 7:40 pm
Florian Reischl (4/30/2009)
I'm quiet sure that English is not her/his first language (due to the "Ja" I think he is German) but this is not the problem. I would...
April 30, 2009 at 5:29 pm
Having reviewed the article, I highly agree with the comment to print the article and give it to your boss.
April 30, 2009 at 4:36 pm
GilaMonster (4/30/2009)
RBarryYoung (4/30/2009)
Glad Gail got to him first, she always handles these very professionally. I would have had him two feet off the ground, grasping at his own throat.
That's...
April 30, 2009 at 3:29 pm
Here is an updated test suite.
create table #Order (
OrderId int,
DeliveryDate datetime,
Price money,
UnitId int,
...
April 30, 2009 at 2:07 pm
HOWEVER!
What other status codes are possible, and is it possible that one order may have multiple statuses? I'm sure you only want to delete orders where all the items...
April 30, 2009 at 1:59 pm
Florian Reischl (4/30/2009)
Apologize twice...1st) I didn't see Lynn's answer
2nd) I forgot the "WHERE Status = 'Completed'" in my statement. Just corrected.
Greets
Flo
Flo,
No apologies needed. Your solution is the one I...
April 30, 2009 at 1:55 pm
Viewing 15 posts - 21,241 through 21,255 (of 26,484 total)