Thanks for replying sir

But i want to have 2 different columns i.e., Name & SubjectWiseMarks.

But for column Name i want distinct .

Thanks for replying

i wrote like this but it is still getting null

MIN(case when Unit = '% wt.' then ISNULL(Figure,0) when ISNULL(Figure,0)=NULL then Mwt/vol end) as wt

Thanks for replying,

I had another doubt

After Running the below Select Statement what you given for example my records are like below,

SELECT Name,

...

Thanks for replying Koen Verbeeck.

Am not the admin.

if the user is not the admin then how to resolve this issue?

is there any other way?

Thank you sir for replying,

Actually it is great solution (INSERT INTO SELECT STATEMENT).

it is working fine.

Hi Sir,

Thanks for replying.

It is working if i write the query

INSERT INTO MYTABLE(NAME,ID) VALUES('AAA',1),('AAA',2),('AAAA',3)

so for this i write a stored procedure,

ALTER PROCEDURE MYPROCEDURE

(

@String NVARCHAR(MAX)

)

...

Thanks Pan & Vinu Its working... & once again thanks for replying...

Thanks for replying BriPan..

Declare @SampleIDs Varchar(100)

Set @SampleIDs=(Select SampleIDs From Sample1 where AutoID=1)

Select Item from dbo.DelimitedSplit('1,3,4',',') UNION Select Item from dbo.DelimitedSplit(@SampleIDs,',')

So the output for this is like,

Item

-----

1

2

3

4

then how to convert it...

CREATE TABLE tblKit

(

KitId INT,

TargetId INT,

QId INT

)

This is my actual table structure & i have some records

(SELECT DISTINCT TargetId FROM tblKit) If I run this...

Thanks for replying Cadavre.

Sorry for writing my post in caps.

Actually i don't know the meaning that if i post a query in caps it is like shouting.

From now onwards while...

Thanks for all replying to my post

NOW IAM CLEARLY EXPLAING MY TASK,

SELECT DISTINCT ID FROM TABLE1

When i execute the above statement

The Output comes like this,

ID

----

100

200

300

400

500

so now i want to insert...

Thanks for replying Boss for my question....

Its working fine thanks a lot.