Hi

Lowell solution is right solution, so this way you are hard coding the column names any where in the query. This is so dynamic.

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com

Hi

Unless you dont have any way to go thenonly use Dynamic SQL, otherwise follow Greg's suggestion. This will improve the query performance.

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com

Hi

Its not a good design to have Currency symbol as part of Amount Field. Always separate these into two different columns.

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

Hi

Your plan looks good but you need to Check out the below links for smooth migration:

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1194265,00.html

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1257496_mem1,00.html

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

Do you want to replace 1 record in Table A with Multiple records from Table B? or want to do group by operations on Table B rows which has mapping...

"In the same query, if product A is chosen, product B is not allowed. But product A and C can be included in the same query. The code...

This is not possible with CASE, but if you define functions to insert or update then you can call these in CASE expressions.

The most simple thing is using MERGE....

Simple solution 🙂

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

Do you want to join all the tables and insert? If YES then what is the joining key column.

If NO then you can simple use UNION ALL.

Thanks

Vijaya Kadiyala

Great solution...using PIVOT.. i think, we can use this as the best example interms of using Pivot.

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

Do you have any delimeter to differentiate these??

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

How are you inserting? All the child records at one shot or Alternative like parent record first then corresponding child records??

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

Hi

You want to create a dummy in Child table for every row that you insert into Parent table? what is the use of this?? do you want to avoid Outer-joins??

Thanks...

Hi

Dont touch the existing tables. Create new tables with Int (PK Column) and copy over the data from old tables new ones and do the due diligence to make sure...

Hi

I am curious to know what kind of table is this?? 28 columns to make it unique? 😀

Do you have all the columns in database in single table 😉

Certainly there...