So I created a stored procedure to insert/update some other tables. After creating the stored procedure and compiling it, I am getting error that I do not have access. However, I am able to update/insert to those tables with just the query before making the SP. Is there anything special that needs to be done to allow the SP to update those tables?
The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.