I have an idea on this. seems to work in my 3 three test cases. 1st I create a view X which selects the constraint fields and group them along...

I will add an index for all the searched fields with a fill factor of 90%. Do you think this is a good fill factor as the table could get...

I have tried the DISTINCT select but to no avail. I thought that maybe because the duplicate rows dont have anything else common outside of the fields in the constraint...

YEAH!!!!!! it worked. Thank you Robbac. I spent of and on about 1 week on that issue. Again thank you.

I did not do that part. I will let you know what happens when I do this. I am waiting for the NetAdmin for his confirmation.

Thank you all for your...

I have tried adding a proxy account SQLProxy1 (nt domain account) and have changed the sqlServerAgent settings so it starts with SQLProxy1 and restarted the db. I have also added...

If I do the user and password like so:

 EXEC master.dbo.xp_cmdshell 'dtsrun /S JUPITER /N Import_MW /U web_user /P *** '

where *** is the password this does not seem to work for...

Sorry for soo many questions. but I was re-reading what you said:

"If the application inserts more than one row at a time (for example if you transfer the data...

I was just reading up on scope_identity...it says that it returns the last identity value inserted.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_6n8p.asp

if thats true then how will I join the tblTransCommon to tblTransAct? Am...

Interesting...I am going to try this. I will let you know how it works out. I am assuming scope_identity is getting the Identity values of TransCommon.

Thanx

Razvan,

This sounds like a cleaner solution then what I was thinking of. But how would I create the same identity key in both tables? I am just doing a reguler...

So if you do the following:

insert into t1 (a,b,c,d)

select a,b,c,d from t2

where (t1.a <> t2.a) AND (t1.b <> t2.b) AND (t1.c <> t2.c) and (t1.d <> t2.d) AND...

if you are using vb or asp..then use a executecommand on the stored procedure. This will return a recordset

Hope that helps.

Another reason to use stored procedures is that it is more secure. There is no sql statements going back and forth from app to db. I use stored procedure for...

This is a question about constraints in keeping with the topic...

I am also in the same situation. I am designing a commission system where we monthly import 2 to 3...