Forum Discussion
Best Practice. Using sql stored procedure vs importing data from sql server?
Hello, My organization just started utilizing the PowerBI and there are some developments going on. The vendor who is helping us is writing a lot of SQL queries and stored procedures, on the othe...
Indeed! First time I see this. Anonymous Could you please explain what @Offset is and why is it needed?
Sometime that won't work with particular queries, though. In that case it is best to create a linked server, and query through the linked server using OPENROWSET technique. (It is normal for a SQL serer to have created a linked server to itself.) This delightful new query, presumes you have created a linked server and it works cleanly. (Please remeber the community strips characters from the SQL sometime, so work it out if so)
😶