Viewing 14 posts - 1 through 14 (of 14 total)
November 20, 2017 at 3:22 am
October 20, 2017 at 8:29 am
October 20, 2017 at 7:08 am
sorry I forgot to mention 1 thing
sometimes it happens that the people column has a NULL value and in that case I need to grab the previous non null...
October 20, 2017 at 6:03 am
I figured it out 😀 I just leave the code here for future generations
SELECT B1.*
FROM
(
SELECT *,ROW_NUMBER() over(partition by B1.ID order by B1.RowID...
October 19, 2017 at 2:55 am
Ok
I have changed the names and stuff for security purposes.
This is how I've tried to use the page and the SSRS reportDECLARE @varsub...
September 26, 2017 at 1:23 am
Thanks that worked I still have to do some testing but it looks good so far
December 9, 2016 at 1:34 am
Thom A (12/8/2016)
What you're looking for is BEGIN TRY:
BEGIN TRYEXEC thisspdoesnotexist_sp;
END TRY
BEGIN CATCH
RAISERROR('Enter your error message here',1,0);
END CATCH
That only points out...
December 8, 2016 at 2:46 am
Thanks all
I've decided at the end to go with the Try and catch option and it ended out quite alright 🙂
November 25, 2016 at 8:51 am
Phil Parkin (11/23/2016)
davidvarga086 (11/23/2016)
And I might set up...
November 23, 2016 at 7:15 am
Luis Cazares (11/23/2016)
What if someone creates a stored procedure that elevates their privileges? Are you protected from that?
The thing is Only 5 people from my team have access to this...
November 23, 2016 at 7:11 am
Well I would like to know which one failed and why it failed. And maybe put that info in a table I guess.
And I might set up a mail notifications...
November 23, 2016 at 7:05 am
I'll try to explain.
when you want to get a value from a textbox1 into textbox2 you type in something like reportitems!textbox1.value into the textbox2 expression. which will result in grabbing...
May 31, 2016 at 7:18 am
Viewing 14 posts - 1 through 14 (of 14 total)