Viewing 15 posts - 11,521 through 11,535 (of 14,953 total)
GilaMonster (1/15/2009)
Jack Corbett (1/15/2009)
The APPLY operator is designed for use against table valued functionsOr (I believe) correlated subqueries in the FROM clause
Yep.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 11:38 am
You need to use the IMEX command in the connection string. MSDN has all the details.
I had the same problem a while back and posted the detailed solution on...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 11:38 am
It's not really a question of quantity of databases. It's a question of traffic and load vs server capability.
There's a huge difference between one database being hit by 10-thousand...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 11:35 am
I don't really have a home. I have a place where I live, currently an apartment, but I can't really say I'm tied to it in any way, emotionally.
I...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 8:42 am
Without a cursor or While loop or whatever, you could get that in one pass with something like this:
create function Cols
(@Table_in nvarchar(128))
returns nvarchar(max)
as
begin
declare @Cols nvarchar(max)
select @Cols = coalesce(@cols + '+isnull(['...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 8:32 am
Michael Earl (1/15/2009)
DavidB (1/15/2009)
Steve - Should we change the title of this topic to "Are the posters becoming more violent"? 😀
So far, I haven't seen anything violent. Everyone seems...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 7:57 am
Loner (1/15/2009)
10:15 - messing around on SQL Server Central
10:21 - help desk ticket #35104
11:30 - lunch
12:50 - building view dbo.JoesNewReport
13:07 - emergency help desk ticket #542138
13:17 - building view dbo.JoesNewReport
14:57...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 7:53 am
If you actually have to do row-by-row, use a cursor for it. It's what they're built for, and they're good at it. While loops for row-by-row aren't as...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 7:29 am
I think it's pretty much the same question as "which is better, red or blue?"
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 7:27 am
Staging tables like that work quite well. Yep.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 7:23 am
declare @pFile XML
set @pFile = '(Your XML string)'
select @pFile.value('(*:Enroll/Context/@SubmitterUserId)[1]','varchar(100)')
Result:
THEUSER
(Can't post the XML here, but it's a copy-and-paste from your file.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 7:20 am
The default trace should have the command in it that is doing the disabling. That should give you the source.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 6:55 am
Jeff Moden (1/14/2009)
John Dempsey (1/14/2009)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 6:46 am
Grant Fritchey (1/15/2009)
jcrawf02 (1/15/2009)
Have I mentioned how much I LOVE all of you, and REALLY APPRECIATE all of your help on the forum?(laughs nervously, backs away slowly...)
Oh now, don't be...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 6:42 am
If you have a situation where some of the Customer_No values will already be in the target table, and you just have more rows about more stuff with the same...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 14, 2009 at 3:32 pm
Viewing 15 posts - 11,521 through 11,535 (of 14,953 total)