Viewing 15 posts - 46 through 60 (of 98 total)
Woah, lots of great stuff coming in here. I can hardly keep up. I keep refreshing to make sure what i am about to say has not been said and...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
November 18, 2009 at 5:40 am
Pieter-423357 (11/17/2009)
REPLACE is a costly function and will run for a good while...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
November 17, 2009 at 8:47 am
My mind converted the OR to an AND since if you could use VARCHAR(MAX) then the first constraint about string length would not apply anyway.
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
November 17, 2009 at 3:01 am
Paul White (11/17/2009)
SDM (11/17/2009)
To the people who can program in a .NET language and recognise when to use it appropriately to complement T-SQL:
Fixed that for ya! 😀
SDM (11/17/2009)
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
November 17, 2009 at 2:26 am
Oh, I do the strangest things for fun. The DHTML stuff was mainly code theft so the fun bit was actually seeing the end result in action and now we...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
November 9, 2009 at 3:29 am
Yes. Though I did not specifically mention so I was aiming to intimate that I was avoiding the dynamic where possible.
Now for the fun stuff, the DHTML tooltip of the...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
November 6, 2009 at 6:45 am
Yeah, makes sense.
I have the union one in there anyway because I need to reference by same table name later on.
It's basically for a wee html dashboard of jobs on...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
November 6, 2009 at 5:38 am
First off. Nice article with a lot of things to think about.
As mentioned in the previous couple of posts. A ConvertProcToFunction would, in a lot of cases be even handier....
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
October 29, 2009 at 9:13 am
As a bit of a side bar, the REPLACE method is fine but only if you catch all the possible characters. For example, you missed "&" and a couple of...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
October 16, 2009 at 3:07 am
OK, so the code is about the same but I also inserted the data to a table which was cleared between statistics time toggling:
--===== Do the testing in a nice...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
October 15, 2009 at 9:33 am
Oh, be careful...the code above will leave a trailing comma. The COALESCE (or ISNULL) not only removes null entries, its position in the concatenation formula prevents having a trailing comma.
Oops,...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
October 15, 2009 at 8:56 am
Sigh, when will people learn to read before posting.
You are NOT using coalesce to concatenate.
in the example above, coalesce is used to remove NULL entries.
The below works just the same...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
October 15, 2009 at 7:30 am
Jeff. Once again, greet work on the performance testing.
I did a wee compare last night but do not have the results due to a bit of a power cut.
Once character...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
October 15, 2009 at 3:44 am
Actually you dont have replace the invalid characters if you use the FOR XML Clause, with the TYPE directive. You can then use an xquery to extract the value as...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
October 14, 2009 at 9:20 am
Joel Mansford (10/14/2009)
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
October 14, 2009 at 5:10 am
Viewing 15 posts - 46 through 60 (of 98 total)