there might be some glitches. please test thoroughly.

CREATE PROCEDURE splitColsAsSP

AS

BEGIN

SET NOCOUNT ON;

DECLARE @col1 nvarchar(50),

@col2 nvarchar(50),

@col3 nvarchar(500),

@tcol nvarchar(50),

@tcolname nvarchar(50),

@sqlstr nvarchar(500),

@tsqlstr nvarchar(250),

@which int,

@lpos int,

@rpos int,

@firstrow int

declare yourCursor CURSOR...

you definetely need a stored proc.

Maria,

If your table has a lot of records , you should write a stored proc and use a cursor. if not here is your function.

this is how you...

I know this is SS forum but here is one way of doing it on the client.

if (!IsPostBack)

{

...

Personally, I would return all columns as one comma separated string

(select col1+','+ col2 + ',' + col3 from yourtable)

and parse it in the client.

Returning a dataset from...

How are you going to use the result set?

are there same number of commas in col3 for every row and how is your output going to be used?

Well done Jeff. Thanks.

I loved the Matt's solution too and learned how to use patindex. But I dont agree about your reasoning. patindex itself is a function and I can not imagine they...

very nice

here is a user function then

create FUNCTION RTRIMNONNUMERICS

(

@inStr nvarchar(200)

)

RETURNS nvarchar(200)

AS

BEGIN

DECLARE @len int;

DECLARE @pos int;

DECLARE @asc int;

set @pos = 1;

set @len = len(@inStr);

WHILE (@pos <= @len)

BEGIN

set @asc = ascii(substring(@inStr,@pos,1));

IF (@asc <...

if it is always (K).

you can simply

select left(col1,charindex('k',col1))

open the file with excel. make any change and save. Excel will add quotes as necessary. At least all rows will be consistent.

this may help you.

http://technet.microsoft.com/en-us/library/ms182741.aspx

I am not sure I understand correctly but I think having a subquery, to retrieve those records with the criteria first then apply your group by to find the duplicates,...