Hi,

RAC seems to be a cool tool.

Is it free for universities/research projects?

Thanks,

Maria

Can you tell me how to do that?

I am sorry I am new to this.

Thanks for your help,

-Maria

Hi,

Thank you so much for the query and it is returning the result that I want.

What should I do, if the string to split has dynamic number of ...

Jeff,

It will more than 2 rows, They are dynamic and it will change based on each experiment.

In that case, I have to display them as follows.

INSERT INTO [dbo].[Output_Info] ([Common_Id],[Signal],[Detect],[PValue],[EAID])

...

Hi Jeff,

I tried your tally table and splitting the string as rows in a table output.

But how to make them as columns? or use crosstab to make it as a...

Hi,

Thanks for your reply.

Actually, the EAID is dynamic. It will vary and so I will have to have dynamic column.

How will I write a query in such a situation.

Thanks...

Hi,

I want to display that data in a gridview and pass that table

for further calculations .

-Maria

Hi SSC,

Thanks for your reply.

Is there a url for a site, where I can generate sql for crosstab?

or How to write the query in my case?

I am sorry,...

Hi,

Thanks for helping me.

Yes, there are same number of commas for the given query.

Thanks,

Maria

Hi Micheal,

When I try to call the function like this,

select * from dbo.fn_GetTableByIDList('test,to,split',',')

I am getting the following error:

Conversion failed when converting the nvarchar value 'test' to data type int.

Thanks for...

Hi Steve,

Thanks for your reply.

I could get the comma separated values as rows. How to pivot that into columns?

I am very new to this sqlserver.

Thanks for your help.

-Maria

Hi Jeff,

Thank you for your reply.

I will post this in T_SQL forum too.

I am having a table like below

[CREATE TABLE [dbo].[Output_Info](

[Common_Id] [int] NOT NULL,

[Signal] [real] NOT NULL,

[Detect] [nchar](10) NOT...

Hi Jeff,

I have a table that has the following values.

col1 | col2 | col3 | col4

1 | val1| val2 | val3

2 ...