Viewing 15 posts - 691 through 705 (of 1,183 total)
It's taken the right part of the field minus 47 characters (the width of the text you want removed)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 9, 2007 at 5:49 pm
I'm about 98% sure this is correct, someone will correct me if I'm wrong here. 😀
Provided you can do this during a maintenance window, to limit activity, you can ....
1....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 9, 2007 at 4:33 pm
You can just use the update part below, but the rest is there to show you that it works.
DECLARE @sampleTable TABLE (pictureURL VARCHAR(100))
INSERT @sampleTable
SELECT '~/products/art-frame-direct/accessories/baskets/10484803.jpg'
UNION ALL
SELECT '~/products/art-frame-direct/accessories/baskets/10484873.jpg'
UNION ALL
SELECT '~/products/art-frame-direct/accessories/baskets/88884873.jpg'
UNION ALL
SELECT...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 9, 2007 at 4:25 pm
Well, that's a pretty wide open question. In the example you provided, it could be re-written as ...
Create Procedure dbo.usp_Procedure1
@CallID int = Null
AS
SELECT CallID, Call Desc
FROM dbo.CallLog
WHERE CallID Between COALESCE(@CallID,...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 7, 2007 at 10:21 am
I can no longer contain myself. I must say that I do enjoy seeing the determination of each side in proving their correctness.
Now if you would, pardon me whilst...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 6, 2007 at 11:07 pm
if it's just the parenthisis, space and hypen that your wanting to remove, then ....
SELECT
REPLACE(
REPLACE(
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 6, 2007 at 1:21 pm
OR 1,073,741,823 for NVARCHAR + 2 Bytes for the length.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 6, 2007 at 12:16 pm
That would be 2,147,483,646 characters + 2 bytes for the length.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 6, 2007 at 12:01 pm
2 Gig in '05
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 6, 2007 at 11:46 am
Matt Miller (12/6/2007)
.....And - welcome to the SQL2005 family (at last). I'm curious to see if your view of it changes at all.....
Yes Jeff, come to the dark side!...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 6, 2007 at 8:22 am
LOL, the search box in the upper right hand corner. Even though it say's Google, it's customized for this site. :hehe:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 6, 2007 at 7:06 am
Jeff Moden (12/5/2007)
....... I finally got 2k5 and will have to load it before comparing the methods to the RANK methods for running counts performance wise.
Well it's about time !...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 6, 2007 at 5:37 am
Read up on IDENTITY Columns. you'll find your answer there.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 4, 2007 at 8:52 am
karthikeyan (12/3/2007)
Where exactly cross join is applied in real time ?That is under which circumstance we need to apply cross join ?
I've had to use it most recently when we...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 4, 2007 at 1:53 am
At first glance I was going to say use a numbers or tally table. Do a search on this site and you'll find a couple of good articles on it.
But...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 3, 2007 at 7:43 am
Viewing 15 posts - 691 through 705 (of 1,183 total)