Viewing 15 posts - 1,651 through 1,665 (of 2,462 total)
sarath.tata (4/6/2015)
I can't use global temp variables as it differs per request.
He said global temp table (e.g. ##temp). Global temp tables can be referenced inside/outside of a dynamic...
-- Itzik Ben-Gan 2001
April 7, 2015 at 9:36 am
The [5] would suggest that it's an authentication issue (access denied). E.g. The account that you are running SSRS on the remote server does not have rights to that server/DB....
-- Itzik Ben-Gan 2001
April 7, 2015 at 8:44 am
Fabulous article. Very good read. 5 stars.
-- Itzik Ben-Gan 2001
April 7, 2015 at 5:31 am
Eirikur Eiriksson (4/3/2015)
Alan.B (4/3/2015)
Koen Verbeeck (4/3/2015)
Alan.B (4/3/2015)
How do you report...
-- Itzik Ben-Gan 2001
April 3, 2015 at 11:48 am
Domain accounts have worked just fine for me for many years.
-- Itzik Ben-Gan 2001
April 3, 2015 at 11:39 am
Koen Verbeeck (4/3/2015)
Alan.B (4/3/2015)
I actually came into the "Anything that is NOT about SQL!" forum to ask this question but think it's appropriate here....How do you report spam?
At the top...
-- Itzik Ben-Gan 2001
April 3, 2015 at 11:35 am
I actually came into the "Anything that is NOT about SQL!" forum to ask this question but think it's appropriate here....
How do you report spam?
-- Itzik Ben-Gan 2001
April 3, 2015 at 11:12 am
I wonder if I split the procedure into different procedures depending on the user selected option. This way, the different procedures would have their own saved query plan.
This is something...
-- Itzik Ben-Gan 2001
April 3, 2015 at 11:02 am
It's worth noting SQLNAIVE, that Eirikur's solution will perform about 3X faster.
I took your solution and put it into a scalar valued function like so:
CREATE FUNCTION dbo.SVF_LOCATE_PATTERN_IN_STRING
(
@Expression VARCHAR(8000),
@SearchString VARCHAR(10),
@OccuranceNumber...
-- Itzik Ben-Gan 2001
April 3, 2015 at 9:32 am
Do you have some DDL and test data so we can re-create and populate your two temp tables?
-- Itzik Ben-Gan 2001
April 2, 2015 at 2:21 pm
Nice!
-- Itzik Ben-Gan 2001
April 2, 2015 at 9:53 am
Understood. That's all I could think of, hopefully someone else chimes in.
-- Itzik Ben-Gan 2001
April 2, 2015 at 9:24 am
Why is it doing this
It has to do with how SSRS explicitly converts values. If the time is 00:00:00 it is assuming you want to treat the values as a...
-- Itzik Ben-Gan 2001
April 1, 2015 at 9:18 pm
I recently rolled off a project where we needed to extract some information from the report server catalog (e.g. the reportserver db). This function will includes the report path to...
-- Itzik Ben-Gan 2001
April 1, 2015 at 8:32 pm
Since nobody else is providing a solution I'll give it a try. I am simplifying the query against sys.columns because I don't really understand what you are doing. That said,...
-- Itzik Ben-Gan 2001
April 1, 2015 at 8:18 pm
Viewing 15 posts - 1,651 through 1,665 (of 2,462 total)