Database

Thank you very much for your input. I was thinking scripting, but I wanted to get some real-world information. I really appreciate it.

I would write a user-defined function that returns the domain and then group by it.

With the table designed as it is, you are going to have terrible problems in getting the thing to work the way you want. At the very least the TotalDays column should be in a separate table, but this is not the only problem. There is not enough space in a forum like this to properly advise you, so I can only suggest thet you do some studying on DataBase Design, before proceeding further. Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

how about select Name as Address, Address as Name from table Just create a view on it and start working .. :) :) Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

Not to my knowledge; it's one of the caveats of using "merge" replication. Regards, Hulicat

thanks a lot

Well any transaction is role backed by the database not by the Front end application because data within transaction does not full fill the criteria , Thats why is role backed. It will not Commit the transaction unless and until it fulfills the criteria set whether you send this from front end or from back end Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

I have done it using cursor.... now its working...:-)

Try printing your sql (replace Execute(@Sql) with print @SQL), then paste it into query analyser and try running it from there to get more information on the error. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

What you have done to display the nformation is correct, but what you need to do id translate the supplier and category names back to their ID values to insert into the product table. YOU have to do the lookup and supply the correct values for the insert. Personally I would be doing the insert in a stored procedure and would look up any FK values in the stored proc. Hopefully this makes sense Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

I have Sql Server 2008 Express with Advanced Services[^] installed on this system and it does have BCP. I've never used SSIS so I don't know.

Why? :wtf:

Then use MS_Access. :-D If not, what database do you intend to use?

Hi, If you got the SQL Server manager, you can "Import" the mdb-file. Create a blank sql-database, right-click within the object explorer and select "Tasks->Import"... Regards Sebastian It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.

thank's for the help yes, i work in design mode. but, where i can find this ...option... set allow auto generate sql script true ?

Best way to see which is performing fast is to profile the application. I will go with the first method with the modifications what PIEBALDconsult suggested. Second method would be good in performance but it is hard to troubleshoot when you get error in one of the inserts. neodeaths wrote: also if lets say way 2 somewhere in the middle of the insert command there is an error would the code before it still be added? Quote Selected Text It will be added. If you want to ensure all the data gets added, run the queries in a transaction. Navaneeth How to use google | Ask smart questions