Viewing 15 posts - 3,316 through 3,330 (of 5,109 total)
I assume it's running from some kind of Agent task? Could you set up a parameter instead, say CurrentDayNum. In the job you can set the value of the parameter...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 7:07 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 6:01 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 5:53 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 5:35 am
When SSRS passes a set a values, it doesn't use an array. Arrays don't exist in SQL Server. Values for Multiple Values Parameters are passed as a delimited string. So,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 5:33 am
Unfortunately there seems to be language barrier here, but I don't understand what your question is.
You firstly seem to be saying you have a SQL Agent job that...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 5:26 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 4:38 am
When you say you want to change the check, what do you mean exactly? Will the value of the @DayNum need to be a different value to evaluate to TRUE,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 4:18 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 2:13 am
Is it just for a specific subscription, or all of them? We have it set up on Exchange so that all emails sent our SSRS service account have specific text...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 2:04 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 2:02 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 1:48 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 9, 2017 at 12:22 pm
What would your NULL value represent? If you are supplying a list of items, what would you expect a list of no items to return?
I ask as, for...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 9, 2017 at 9:53 am
Create a variable with the date value and pass that in your statement. For example: Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.DECLARE @CurrDate varchar(8) = REPLACE(CONVERT(varchar(10), GETDATE(), 104),'.','');
...
... DISK = '
Larnu.uk
August 9, 2017 at 9:32 am
Viewing 15 posts - 3,316 through 3,330 (of 5,109 total)