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
   

- Advertisement -