Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Need help in running sql cmd in Excel sheet

Author  Topic  Ssk2 Starting Member 1 Post Posted - 2014-02-11 : 17:50:41 I need help to build a query to do the following in Excel sheet. I have master records for 10 rows (in sheet #1 ) Master 9001 9002 9003 9004 9005 9006 9007 9008 9009 9010 The I have another set of column that has subset of the above for example Existing Table (in sheet #2) 9002 9005 9008 Now I want run a query (in sheet #2) where Sheet # 2 data is checked with master data in sheet # 1 and automatically add the delta entries to sheet #2.So below is delta that I want to automatically append these 7 delta numbers to the above 3 records in sheet # 2. 9001 9003 9004 9006 9007 9009 9010 How can I accomplish this ? Please help. Thanks in advance, Sharad