Perry Whittle (1/22/2009)

---

database sizing springs to mind, something a DBA may well be...

Jeff Moden (1/22/2009)

---

Are you saying it took...

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)...

You're welcome.

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...

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...

JPLeBlanc (1/22/2009)

---

Awesome, i see where you are going from there, just a quick check that after the conversion is performed, that it is greater than the lowest date possible....

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

...

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...

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...

With that clarification, I agree with you. Thought you meant something other than what you intended.

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...

praveen.g.thampi (1/22/2009)

---

Hi,

Can you pls elaborate that...

You're very welcome. Helping people out is the main reason I visit this site.

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...