Viewing 15 posts - 1,501 through 1,515 (of 5,590 total)
Brandie Tarvin (4/18/2011)
WayneS (4/17/2011)
Had a $%^& bug bite my hand while grabbing hay for the horses... now it's all swollen and I'm off to see the doctor.
(The "bright spot"...
April 18, 2011 at 1:42 pm
It might. But as Gail mentioned, it is more likely that the problem is poorly written code, and possibly a poorly designed database.
April 17, 2011 at 5:42 pm
Would you post:
1. how are you creating the temp table.
2. the actual dynamic sql you are using to reference it
April 17, 2011 at 5:30 pm
@#$%^
Had a $%^& bug bite my hand while grabbing hay for the horses... now it's all swollen and I'm off to see the doctor.
(The "bright spot" in this is...
April 17, 2011 at 9:12 am
Yes...
Seriously, specialize, but become better all around.
April 16, 2011 at 8:50 pm
Peter, now I'm confused. How does this question contradict this database being independent of the instance that it's running on? That is exactly the idea behind a contained database.
April 16, 2011 at 11:41 am
Five seems to me to be a lot... but it probably means that they are down to you and someone else, and are having troubles deciding on which one to...
April 16, 2011 at 11:34 am
You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...
April 15, 2011 at 7:39 am
change it as shown in bold to:
insert into #tmp2
(urn2, str2)
SELECT t1.urn,
CAST(
(
SELECT '' + [str]
FROM #tmp t2
WHERE t2.urn = t1.urn
ORDER BY t2.id
FOR XML PATH(''),TYPE
).value('.','varchar(max)')
AS VARCHAR(MAX))
FROM #tmp t1
GROUP BY t1.urn
ORDER BY t1.urn
select...
April 14, 2011 at 2:04 pm
Cliff Jones (4/14/2011)
mohammed moinudheen (4/14/2011)
This is a tough one really 🙂I agree, it is hard question and a very good one. Thanks.
I think what makes this hard is that...
April 14, 2011 at 12:29 pm
Another nice little tidbit of information about temporary tables in Denali: in all prior versions of SQL Server, through 2008R2, all temporary tables are created with positive object_id values. In...
April 14, 2011 at 8:16 am
Koen Verbeeck (4/14/2011)
Nice question, thanks.The hint (select 2) makes the last answer "None of the above" a bit superfluous 😀
I think that hint is applied automatically to all questions with...
April 14, 2011 at 8:11 am
Jack Corbett (4/13/2011)
LutzM (4/13/2011)
April 13, 2011 at 3:19 pm
CirquedeSQLeil (4/13/2011)
Jack Corbett (4/13/2011)
Craig Farrell (4/13/2011)
April 13, 2011 at 1:31 pm
Roy Ernest (4/13/2011)
ALZDBA (4/13/2011)
Roy Ernest (4/12/2011)
You all are making me looking foolish because I am laughing when going through a SQL Forum. I am getting some strange looks. 😀
ditto :w00t:
btw...
April 13, 2011 at 8:16 am
Viewing 15 posts - 1,501 through 1,515 (of 5,590 total)