-- if this returns a few thousands of rows or more;

SELECT RTRIM(referencia) referencia FROM arttamcor GROUP BY referencia

-- then consider setting it up as a temp table:

SELECT RTRIM(referencia) referencia

INTO...

This has already been answered but it's interesting that the logical requirement exactly matches an existing function which isn't used in any of the solutions offered. What you're looking for...

yuvipoy (10/22/2012)

---

ChrisM as i have said i am having some business logic's...

Brandie Tarvin (10/22/2012)

---

ChrisM@home (10/22/2012)

---

L' Eomot Inversé (10/22/2012)

---

Stefan Krzywicki (10/22/2012)

---

Brandie Tarvin (10/22/2012)

---

[font="Comic Sans MS"]The PI! It needs more slices![/font]

You know what I hate about pie charts?

You can never tell what...

yuvipoy (10/22/2012)

---

NO This is not a report one i need to join some tables...

What date does 1157068800...

L' Eomot Inversé (10/22/2012)

---

Stefan Krzywicki (10/22/2012)

---

Brandie Tarvin (10/22/2012)

---

[font="Comic Sans MS"]The PI! It needs more slices![/font]

You know what I hate about pie charts?

You can never tell what filling they're using....

Stefan Krzywicki (10/22/2012)

---

Brandie Tarvin (10/22/2012)

---

[font="Comic Sans MS"]The PI! It needs more slices![/font]

You know what I hate about pie charts?

You can never tell what filling they're using. And it's awfully...

yuvipoy (10/22/2012)

---

The string splitting would ideally be in the stored procedure, so you would have parameters @str and @pos for the stored procedure.

Where do @str and @pos come from?

What will...

-- sample data setup

DECLARE @question table

(

questionid int identity(1,1),

questionbank uniqueidentifier,

indexnumber int,

question varchar(20),

crdate datetime

)

insert into @question

select 'B7152F93-45CE-4485-9672-7E0E5F62F775',1,'q1',GETDATE() union all

select 'B7152F93-45CE-4485-9672-7E0E5F62F775',2,'q2',GETDATE() union all

select 'B7152F93-45CE-4485-9672-7E0E5F62F775',3,'q3',GETDATE() union...

yuvipoy (10/22/2012)

---

create procedure @str varchar(1000),@param int

as

begin

.

.

i am having values in splitter table so there is no need of @pos here we can directly take the value from...

yuvipoy (10/22/2012)

---

We know all of this already. What can you tell us about

1. The process which generates these two strings - where do they come from?

2. How the data is...

We know all of this already. What can you tell us about

1. The process which generates these two strings - where...

yuvipoy (10/22/2012)

---

@pos may increase or decrease if it increase i need to create my testtable accordingly ,here it is 6 splits so i am having 6 columns later i may...

yuvipoy (10/18/2012)

---

hey it has worked thanks

now the thing is i need to insert this data into a table

my table is

create testtable (Rid int identity(1,1),col1 int,col2 int,col3 int,col4 int,col5 int,col6 int)

i...