Viewing 15 posts - 11,371 through 11,385 (of 14,953 total)
Perry Whittle (1/22/2009)
GSquared (1/22/2009)
how often in a DBA's career does it really matter that pages are 8k in size,
database sizing springs to mind, something a DBA may well 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 23, 2009 at 9:34 am
Jeff Moden (1/22/2009)
GSquared (1/22/2009)
Needed in batches of about 5-10,000 at a time, usually about 100k per week.So, there's on situation where I consider procedural code valid.
Are you saying it took...
- 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 23, 2009 at 9:17 am
I'm assuming that you're logged into Vista using a domain account, that it's not Home version (meaning it's either Business or Ultimate), and you're connecting (or at least trying to)...
- 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 23, 2009 at 7:36 am
You're welcome.
- 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 23, 2009 at 7:28 am
Try this:
create table #T (
ID int identity primary key,
Col1 char(10));
insert into #T (Col1)
select '1' union all
select 'a';
select *
from #T
where Col1 like '%[a-z]%';
See what that gives you.
If it's not working for...
- 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 23, 2009 at 7:27 am
On the point of both being real tables, the error from the code is because the table doesn't exist at the time the code is being compiled. The table...
- 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 23, 2009 at 7:22 am
JPLeBlanc (1/22/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 23, 2009 at 7:21 am
To select the experts with a certain code, you could use In, or Join. Either will work.
In would look like this:
select Email
from dbo.Experts
where ExpertID in
(select ExpertID
...
- 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 22, 2009 at 3:09 pm
Are you connecting via Management Studio on the Vista machine, or via remote desktop? I guess that's where I got lost in your first post.
I've used Vista to connect...
- 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 22, 2009 at 3:01 pm
I don't see anything horribly wrong with the query. A few minor details, like adding the domain to the table names, might get some tiny improvement. But the...
- 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 22, 2009 at 2:58 pm
With that clarification, I agree with you. Thought you meant something other than what you intended.
- 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 22, 2009 at 2:56 pm
In this line:
FROM (SELECT BOWEEKLYCLEAR, CONVERT(varchar(16), BOCLEARDATE, 101) AS BOCLEARDATE
change it to:
FROM (SELECT isnull(BOWEEKLYCLEAR, 0) as BOWEEKLYCLEAR, CONVERT(varchar(16), BOCLEARDATE, 101) AS BOCLEARDATE
That...
- 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 22, 2009 at 2:54 pm
praveen.g.thampi (1/22/2009)
GSquared (1/22/2009)
Add a step in between that checks the end-time of step 3 (currently job 3), and continues to step 4 depending on the time.
Hi,
Can you pls elaborate that...
- 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 22, 2009 at 2:49 pm
You're very welcome. Helping people out is the main reason I visit this site.
- 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 22, 2009 at 2:46 pm
Since it has "CT" on the first part of the join math, it's refering to the table that was aliased as "CT", which, in this case, is the credit transactions...
- 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 22, 2009 at 2:45 pm
Viewing 15 posts - 11,371 through 11,385 (of 14,953 total)