Viewing 15 posts - 14,881 through 14,895 (of 26,486 total)
Then what are you using the DelimtedString function for if you don't want to split the original input string?
January 16, 2011 at 3:46 pm
Not exactly sure what you mean by a single string, but the following code works for me and returns what I would expect based on what you provided. It...
January 16, 2011 at 3:26 pm
GilaMonster (1/16/2011)
Lynn Pettis (1/16/2011)
GilaMonster (1/16/2011)
...
Gail, just read this thread. Interesting how the OP couldn't deduce what you were saying from your original answer. I guess the real problem...
January 16, 2011 at 3:13 pm
Really could use more context regarding what you are trying to accomplish. Can you provide the code for your stored procedure and UDF?
Please remember, we can't see from here...
January 16, 2011 at 2:46 pm
GilaMonster (1/16/2011)
...
Gail, just read this thread. Interesting how the OP couldn't deduce what you were saying from your original answer. I guess the real problem we have isn't...
January 16, 2011 at 2:42 pm
Here is your problem:
CREATE TABLE #mytesttable
(
Rennerid INT,
Jaarid varchar, -- <== define the size for the column, ie varchar(30)
Achternaam varchar, -- <== define the size for the...
January 16, 2011 at 2:32 pm
Here are two other alternatives:
SELECT
column_list
FROM
MyTable
WHERE
ID = @CaseID
UNION ALL
SELECT
column_list
FROM
MyTable
WHERE
...
January 16, 2011 at 2:23 pm
Alvin Ramard (1/14/2011)
If so many of you dislike a certain poster so much then why do you have to keep on talking about him?
Frustration and the need to express it...
January 14, 2011 at 8:26 am
Having worked as a SQL Server DBA/Developer for over 12 years and finding myself on the Dark Side now, I have learned one important thing: Learning Oracle as a developer...
January 8, 2011 at 7:43 pm
jcrawf02 (1/4/2011)
Lynn Pettis (1/4/2011)
Craig Farrell (1/3/2011)
Lynn Pettis (1/3/2011)
I've toyed with the idea a few times in my mind. I even have a Chief of Staff already selected.
Chief of Staff:...
January 4, 2011 at 7:34 am
Craig Farrell (1/3/2011)
Lynn Pettis (1/3/2011)
I've toyed with the idea a few times in my mind. I even have a Chief of Staff already selected.
Chief of Staff: Howard Stern in...
January 4, 2011 at 12:09 am
Jeff Moden (1/3/2011)
Craig Farrell (1/3/2011)
Jack Corbett (1/3/2011)
Happy New Year and Birthday to you as well. I just wish I...
January 3, 2011 at 6:20 pm
Jeff Moden (12/31/2010)
Langston Montgomery (12/29/2010)
December 31, 2010 at 8:59 am
GSquared (12/30/2010)
I just noticed I hit 10k "points" on SSC today. Good way to end the year, as it were.
Congratulations, Gus!
December 30, 2010 at 10:00 am
First thing I'd do is check the data at row #73571.
I am assuming you are importing data from a text file of some sort, so you should open it in...
December 29, 2010 at 10:25 pm
Viewing 15 posts - 14,881 through 14,895 (of 26,486 total)