Hello Guys,
I am looking for an alternative to MS Access queries. The reason I need this is that I am moving everything from MS Access into SQL server. Before I had MS Access DB and C# based form that inserts stuff in the table. Then - out of the same database (using Create table queries and regular queries) I build the report, link it into excel and draw pivot - usual business stuff. (In excel query from the MS Access DB is used as a data source)
Now - I need to move everything from MS Access to SQL server. I have rewrote the form and everything is fine except the create table query and regular query part, which I can't find a way to implement. Does anyone know if SQL server has anything similar to MS Access quries, that could be directly linked into Excel? I thought that stored procedures could be handy there but finding a good example on the net seems to be a pain in a but...
Thanks in advance!
P.S.: any advice, suggestion appreciated!