can you put expected output in an excel and send that over. So that I would have a better understanding of your requirement.

Can you provide me a screenshot of the sample output?

Hello,

Since I don't have your DDL and sample data. I generated some data and tried this.

Try something like this. (Check attached file)

What error you are getting ??

Hi

I'm able to insert the data into multiple tables using dynamic sql.

Please find the attachement.

Index1 is my main table feeding data into index2,index3 and index4.

i hope it...

Are you using

alter column statement to change it to not null

does the eno column has any null value ??

Hey sandeep try this :

alter table index1

alter column eno int not null

go

alter table index1

add constraint xafd_314 primary key (eno)

You can't add a primary key constraint by altering a column....

I need to select all columns so you suggest me to write a select statement with all columns instead of select * ??

and the reason i created non-clustered on...

Can Any please respond. I still didn't get any answers.

Thanks,

SAM.

I had enclosed them in the word doc.

Actual Exec plans...

@Kraig

I had enclosed a word doc with execution plans. Let me know if you need any more info ??

SAM.

Hi,

Thanks for the information.

I am making use of a where clause for a date feild between two days. I placed a non-clustered index on that date field column...

Even this worked ...

(select max(id),employeeid,max(salary) from sc2

group by employeeid)

Thanks for your reply.

Please perform this action.

Open SQL SERVER, OPEN some database, right click on some table . You will see open table option if you click on...