ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,631 through 9,645 (of 10,143 total)

RE: Problem with the text data column, variable

Sure.
This statement:
SELECT number
FROM Numbers
WHERE ... SUBSTRING(@String, number, 1) = @Delimiter
means "select rows from the Numbers (tally) table only where Numbers.number is equal to the character position of a...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 2, 2008 at 3:51 am

#865896
RE: Problem with the text data column, variable

harsha.bhagat1 (9/1/2008)
Thanks a million..
It works..
Thank you so much..
🙂
You're welcome Harsha. Don't ya just love a happy customer? 😀
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 2, 2008 at 2:10 am

#865867
RE: Problem with the text data column, variable

Here's another slightly different version which is easier to test and accounts for leading and trailing commas:
[font="Courier New"]CREATE PROCEDURE proc_Function_Explode_New2
(@Delimiter CHAR(1),
@String TEXT)
AS
DECLARE @StringLength INT
SET @StringLength = DATALENGTH(@String)
CREATE TABLE...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 1, 2008 at 10:15 am

#865714
RE: Problem with the text data column, variable

Its not the solution..
There is the problem what i found after working on it more today.
I am not able to split my text field. Today I found that the substring...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 1, 2008 at 9:40 am

#865705
RE: Handling The Text Data Type

harsha.bhagat1 (9/1/2008)
That is my question only:)
Thats me ..
Harsha Bhagat
Harsha Bhagat, if the proposed solution posted in your original thread fails to work for you, then why not post there, explaining...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 1, 2008 at 9:21 am

#865698
RE: Handling The Text Data Type

harsha.bhagat1 (9/1/2008)
So now if I want the substring to work the way i want do you have an idea to solve this.. as this thing is eating my head now...
I...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 1, 2008 at 8:53 am

#865691
RE: Handling The Text Data Type

Robert
SELECT CHARINDEX(@Delimiter, @String, @number)
will fail i.e. return 0, if @number exceeds 8000 characters.
Cheers
ChrisM
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 1, 2008 at 8:31 am

#865680
RE: Handling The Text Data Type

harsha.bhagat1 (9/1/2008)
Hi,
The article is excellent and working on it I also gone into the problems facing text datatype .
But when you say use the substring , for me its is...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 1, 2008 at 8:16 am

#865677
RE: Problem with the text data column, variable

Of course you can use a tally table with text values.
This is ugly because you can't use CHARINDEX() with text values and it assumes that the max length of a...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 1, 2008 at 5:56 am

#865648
RE: Transposing the data in the table

GOD (8/29/2008)
this is a better option... this works well for 3 columns... was developed by my friend.... good one...
Jus fill the values in the pivottable table and run de...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 29, 2008 at 9:32 am

#865103
RE: Query for selecting multiple details values in single row

nairsanthu1977 (8/27/2008)
Dear All,
I have a master table called REQUEST. Each request may have been assigned to multiple employees. So I have another detail table where in there will...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 28, 2008 at 1:09 am

#864160
RE: multiple row values into diff columns

Duplicate post, see http://www.sqlservercentral.com/Forums/Topic559341-338-1.aspx
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 28, 2008 at 12:59 am

#864155
RE: multiple row values in multiple columns

Duplicate post, see http://www.sqlservercentral.com/Forums/Topic559341-338-1.aspx
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 28, 2008 at 12:57 am

#864154
RE: pivoting

Duplicate post, see http://www.sqlservercentral.com/Forums/Topic559341-338-1.aspx
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 28, 2008 at 12:56 am

#864152
RE: pivoting

Duplicate post, see http://www.sqlservercentral.com/Forums/Topic559341-338-1.aspx
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

August 28, 2008 at 12:54 am

#864149

Viewing 15 posts - 9,631 through 9,645 (of 10,143 total)