Viewing 15 posts - 1,636 through 1,650 (of 2,458 total)
Can you include the DDL for the temp tables?
-- Itzik Ben-Gan 2001
April 7, 2015 at 2:04 pm
djacobos (4/7/2015)
ALTER FUNCTION [dbo].[CommaListIntoTable] (@InStr VARCHAR(MAX))
RETURNS @TempTab TABLE
(id int not null)
AS
BEGIN
;-- Ensure input ends with comma
SET @InStr = REPLACE(@InStr + ',', ',,',...
-- Itzik Ben-Gan 2001
April 7, 2015 at 1:51 pm
MadAdmin (4/7/2015)
Sean Lange (4/7/2015)
MadAdmin (4/7/2015)
It is possible to read the same row twice with read committed, once before a change, then after the change.
All isolation...
-- Itzik Ben-Gan 2001
April 7, 2015 at 1:43 pm
Dwain Camps wrote a great article awhile back: The Performance of the T-SQL Window Functions[/url]
The article is very 2012-centric but discusses how to calculate a median in 2008 as well.
-- Itzik Ben-Gan 2001
April 7, 2015 at 1:14 pm
Here's a better example using multiple nodes on the second apply
DECLARE @x TABLE (id int identity, data xml);
INSERT @x VALUES
('
<xxx blah="xml1">
<yyy>123</yyy>
<yyy>456</yyy>
<yyy>789</yyy>
</xxx>
'),
('
<xxx blah="xml2">
<yyy>999</yyy>
...
-- Itzik Ben-Gan 2001
April 7, 2015 at 12:59 pm
Note this query (created simplified XML data since there was no DDL to work with).
DECLARE @x TABLE (id int identity, data xml);
INSERT @x VALUES('<xxx><yyy>123</yyy><zzz>999</zzz></xxx>');
SELECT
id,
n2.value('xxx[1]/yyy[1]', 'varchar(10)'),
n1.value('.[1]', 'varchar(10)')
FROM @x x
CROSS APPLY...
-- Itzik Ben-Gan 2001
April 7, 2015 at 12:52 pm
Deadlocks will present themselves as errors, not just a long running proc.
Yep. Duh! Good catch Grant.
-- Itzik Ben-Gan 2001
April 7, 2015 at 12:25 pm
Careful with that read uncommitted, it could allow incorrect data to get inserted into #MainLocationsTempFL. That's the same as a NOLOCK table hint which, if you read books online, can...
-- Itzik Ben-Gan 2001
April 7, 2015 at 12:16 pm
dopydb (4/7/2015)
ahh..i forgot to change the over write data source and reports to True - hence my changes where not applying
stupid me !
Haha - I do that all the...
-- Itzik Ben-Gan 2001
April 7, 2015 at 10:04 am
When I have had this kind of problem it often has to do with the indexes or statistics. A few things to check:
Make sure that
* your statistics are up-to-date...
-- Itzik Ben-Gan 2001
April 7, 2015 at 9:56 am
Using the technique outlined in Creating a comma-separated list (SQL Spackle)[/url] By Wayne Sheffield you could do this:
WITH de AS
(
SELECT DISTINCT Email
FROM #emails
)
SELECT
Email,
BranchNumber = STUFF((
SELECT ',' + BranchNumber
FROM #emails...
-- Itzik Ben-Gan 2001
April 7, 2015 at 9:46 am
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
Viewing 15 posts - 1,636 through 1,650 (of 2,458 total)