Database

Pleased to help. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

If you want to advertise, try paying for it - and if your product was that good you would be found straight away by anyone googling. And its a rubbish web site, full of spelling and grammatical errors anyway. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

How about: INSERT INTO EMPLOYEE SELECT @empId, @loginId, @title, branchNo, @Fname, @idNo, @physicaladdress, @province, @city, @telephone, @cellNo, @Email, @employeetype, @salary FROM BRANCH WHERE someCriteria In case thats a bit confusing, you can pull the branchNo from another table while still using all your variable for the other columns to be inserted.

It is a book; try Amazon.com or whoever you like.

You may have better luck just using a parameterized command rather than a stored procedure.

Thanks i never thought there would be an index there, i just inherited the System. thanks :) Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

Open the form in design view, double click on the button. That should put you in a code window in the buttonX_Click event (where buttonX is the name of your button). Now add a call to your code (or place your code here if its not in a sub/function. Buy a book on Access programming if you intend to do any more - this is something that is one of the first steps in Access programming. Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis

Why not use SSIS?

No problem. I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

Hi, I am using Windows XP version 2002, service pack 3. Thanks Ramm

Hi vica dianto, This Query also takng much time.. but much faster than what i posted. I want to insert these result in an access table also. Is the insertion creating the touble or the query itself? Hi abcurl, "Status = 'PASS'".. Status can be fail or pass, but if two similar Cases having different status I want the lastest status, ie Case having Laresgt ID. One more thing i want the result to be inserted in an access table also Thanks alot for the replies Jishith

Interesting. I'll keep your marketing remark in mind next time I'm faced with such decisions. Cheers. Luc Pattyn [Forum Guidelines] [My Articles] The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

The mans a masochist, Access AND Crystal Reports, what a nightmare. Never underestimate the power of human stupidity RAH

Use Max(stringvalue) for your aggregate function (you are after all aggregating 1 value), you can see an example here[^] Never underestimate the power of human stupidity RAH

I knew 3 and milliseconds came into, just couldn't remember where. I knew about datetime2 in 2008, but didn't realise so much time had been spent deciding on a name :-D Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

Welcome Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

Your problem is that SQL Server does not allow an in clause to be a variable: TRANSFER_ID IN (@TRANSFER_IDS) for example will not work. What you need to do is split the variable into a table variable and join to that. Google has loads of examples Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP