i want to concat row with comma separator and before that need to add one statement which is common ..

Yes i need concatenation here i user group_concat function but ,

select group_concat('your perfomance is good in',trait_name order by trait_name separator ',')

but its showing your perfomance is good in numerical,'your perfomance...

Ok i will read the articles if any doubt then again will ask you... please support me for that.

Mostly i need to create index on primary key but.... primary key is irself a clustered index.. is there any index which work fast on primary key.

I have no idea about indexing actually...

can you please tell how it can implement on database.

step i followed to search :-

1. I opened the table design.

2. right click on primary...

Actually i need all columns from view and storeprocedure.

one of my friend recommended me to use index... i am not using index in database. is it really feasible solution to...

Can you please tell me what query execution plan does actually to help us in performance tuning? How it could i use?

Yah it means i need to take college code in college_cutoffmaster table right???

but i m confused here see below query,

insert into College_Maharashtra_BEngcutoffmaster1([CutoffId],cutoff,collegeid,degreeid,streamid,entranceid,gender,UniversityType,Capround,collegecode)

select a.[CutoffId],[Cutoff],[CollegeId],[DegreeId],[StreamId],[EntranceId],[Gender],[UniversityType],[Capround],b.collegecode from College_CutoffMaster a, College_CutoffCodeTransition b

where a.cutoffid=b.cutoffid

here by...

I designed table of college_cutoffmaster as a master table there is different collegecode for each stream means each cutoffid will contain different college code.

I executed it.. all values are coming unique in table but i want a collegecode from cutoffcode transition that is coming null 🙁

Yes there will be a only one cutoff if in codetransition table

I did a changes u suggested as below,

alter trigger trg_After_Cutoffmaster_Insert on

College_CutoffMaster

FOR INSERT

AS

declare @CutoffId numeric(18,0);

declare @Cutoff numeric(18,0);

declare @CollegeId...

Please help me i get trapped over here in trigger again,

It's giving duplicate records

tables i have as below

First one

CREATE TABLE [dbo].[College_CutoffMaster](

[CutoffId] [numeric](18, 0) IDENTITY(1,1) NOT NULL,

[Cutoff] [numeric](18, 0) NULL,

[CollegeId] [numeric](18,...

Yah It's working Now for specific id 🙂

Thank you

Please see the table [dbo].[Employee_Test]

Emp_IDEmp_nameEmp_SalId

1Anees1000.001

2Rick1200.004

3John1100.002

4Stephen1300.001

5Maria1400.001

6pallavi1400.003

in that one column is exist named "Id"

so want to insert a record for specific id which i mentiond in trigger for inser query see,

insert...

I implemented trigger on one table,

CREATE TABLE [dbo].[Employee_Test](

[Emp_ID] [int] IDENTITY(1,1) NOT NULL,

[Emp_name] [varchar](100) NULL,

[Emp_Sal] [decimal](10, 2) NULL,

[Id] [numeric](18, 0) NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[Employee_Test_Audit](

[Emp_ID] [int] NULL,

[Emp_name] [varchar](100) NULL,

[Emp_Sal] [decimal](10, 2)...