Hi Ian,

As far as I can tell, you'll need something like a SUM with a CASE, like this:

SELECT ColumnA,

SUM(CASE WHEN ColumnB BETWEEN StartDate AND EndDate THEN 1 ELSE 0 END)

FROM...

Lynn Pettis (7/19/2012)

---

Koen Verbeeck (7/19/2012)

---

100 books? I'm glad I can read 2 on a whole year (technical books not included).

Don't get me wrong, I love to read (read the whole...

Me too. Mostly.

Muphry's Law always good for a laugh, whether deliberate or not 🙂

Hi mate,

2GB is definitely low!

As this is 64-bit Windows & SQL you can ignore AWE.

With 8GB I'd be looking at setting max memory to 5-6GB if there's no other applications...

Yep, not exists would capture new rows based on a suitable identifier, but won't get updates to extant rows.

Unless that's all you need 🙂

Amend? :hehe:

Interesting, I didn't know you could call functions using EXECUTE!

Agreed.

I looked into this a few months ago, and I remember I found that you can't reduce licensing costs this way.

Will try and find some more info for you to...

Good question. Interesting point made by some that you can, if you delete the other snapshots.

Hi,

Is TCP/IP enabled for the named instance?

Check in SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for instancename

Cheers

Thanks, hope it helps. Agree it's a strange one!

Hi, more a workaround than a solution, but could you change the query to union the two selects together?

Should help performance while you're looking for something more permanent.

When you said...

Yes, you'll need a user/group in the other database and select permission on any tables that the view references.

You only need select on the view when all tables are in...

Best case scenario, if you know the table name & column names & it's an exact match on the string, it's a fairly simple query:

select *

from table

where 'CDT' in (column1,...