vinu:

I tried using select 1 and it still gives me error.but i haven't try distinct yet.if i use distinct what fields do i use from the table? I mean what...

Hi:

I have created all the tables DDL and select data statement. whats next?

thanks.

the table that i have provided is the actual table. is that needs to be in new temp table so that i dont mess with the actual table? also, what...

The select statements you have made is right. Now what next with it. Do i need to create a sample table to put this into?

thanks

I don't understand how to do this in a insert into format. please give explain step by step

thanks

Thanks for the reply. I will try this. Which part of the code needs to be replaced for this the code you provided.

Sorry,

Don't understand what is DDL means and what data you need to see, the table that used in the select statement.

thanks

Hi Vinu:

I checked entity_id,and user_id are retruning multiple records in a table. So, what field do I need in my statement as a distinct.Are these entity_id

,user_id ones? or something else.

Thanks.

Hi:

[Execute SQL Task] Error: Executing the query "/* removes Matters from timekeepers frequently use..." failed with the following error: "Subquery returned more than 1 value. This is not permitted when...

Hi everyone:

[Execute SQL Task] Error: Executing the query "/* removes Matters from timekeepers frequently use..." failed with the following error: "Subquery returned more than 1 value. This is not permitted...