Viewing 15 posts - 1 through 15 (of 50 total)
Thanks Phil.
Appreciate your help!
May 20, 2021 at 1:33 pm
Thanks Phil. I'm going to update my packages to use the environment variables.
Still curious, what might caused this change since everything worked fine before.
Jay
May 19, 2021 at 10:02 pm
Thanks Thom. The users in my case are using their own credentials to run the report. I'll read more about Row-Level security.
Thanks!
June 26, 2019 at 12:22 pm
Thanks for reply. My dataset is basically a stored procedure that passing a Project ID as an input parameter. I'm going to read the article in your replay and may...
June 26, 2019 at 12:20 pm
June 9, 2018 at 9:05 am
June 9, 2018 at 6:30 am
June 8, 2018 at 12:47 pm
Is DB_One being restored to...
June 8, 2018 at 12:39 pm
Checked production database this morning, and found total of 242 records. Only the first 141 rows showed the same last 4-digit value. After that, no more "same-value" issues.
Also talked...
October 5, 2017 at 7:07 am
DECLARE @n int =...
October 4, 2017 at 3:18 pm
October 4, 2017 at 12:16 pm
September 28, 2017 at 10:11 am
getting one step closer to the solution:
Select Count(*) as InitiatedProd, c.Wk_number
From #tbProducts p
Inner Join (Select CalendarDate, WD_Num, datediff(WEEK, '12/31/2017', CalendarDate) as Wk_number From #tbCalendar)
c on c.CalendarDate =...
September 25, 2017 at 9:55 am
September 25, 2017 at 9:30 am
February 21, 2017 at 9:58 am
Viewing 15 posts - 1 through 15 (of 50 total)