I am new user on this forum, just starting to learn SQL from scratch.
The setup on which I work is as follows:
SQL Server 2008 installed on Win Server 2008 R2 SP1 running MSPOSINSTANCE database
for Microsoft Dynamics POS 2009 SP2 (few clients with POS installed (database located on server)
I am ok with queering database from POS, export to csv - do changes and import back through POS Import wizard. But this take long time and is limited.
I need help with accessing database on SQL Server, queering it, manipulate data. From this setup what exist there is no way to do anything and what I have found out is I need something like SSRS (link this up with SQL server and database) to be able to run queries(extract information in excel format) ..not sure if using SSRS I can manipulate data in database as well.
Any tips, books recommendations will be much appreciated.
Thanks in advance