When you say you store the size, I'm assuming you mean something other than width and height. File size maybe?

If it's file size, then no, you can't calculate width...

The most likely problem is that the database is in Compatibility level 80 (or earlier). Check that.

It does depend a lot on what the auditors would consider an adequate level of monitoring.

Perhaps a server-side trace would be good enough. That would be pretty minimal level,...

Instead of doing it in the Where clause, do it with a Join.

select *

from Table1

inner join Table2

on Table1.Col1 like '%' + Table2.ColA + '%'

where Table1.Col2 = 'xx';

Like that.

I haven't worked with SQL 2000 in a while, but here's something that might help:

http://www.databasejournal.com/features/mssql/article.php/2196461/XML-and-SQL-2000-Part-1.htm

patrickmcginnis59 (6/18/2012)

---

GSquared (6/18/2012)

---

patrickmcginnis59 (6/18/2012)

---

Matt Miller (#4) (6/18/2012)

---

patrickmcginnis59 (6/18/2012)

---

Everybody on the lower income...

If you mean login requests, you can do that through what's called a Login Trigger. Data on those is here: http://msdn.microsoft.com/en-us/library/bb326598.aspx

If the only thing you're doing is inserts, I'd suggest Insert Select instead of Merge. That's usually faster.

However, on very large datasets, inserts can end up slow too, depending...

You're welcome.

Okay, given the clarifications provided, this isn't something SQL is good at, so it's going to be awkward to implement in it.

What you have to do build a recursive function...

When that happens to me, it's usually either that the workstation I'm at is overloaded (check Task Manager), or some piece of the project I'm working on is being problematic...

The easiest way to do this would be to consolidate the data into a single database, from all servers. Create a single table with a GUID column in it,...

Phil Parkin (6/19/2012)

---

Everyone who fought the Nazis, including internal rebels within Germany, took risks. The article doesn't say "Americans beat the Nazis", it says people who took risks did that....

Are you looking for ANY combination of Items where the quantity = 10 (or whatever number), or per-item?

For example, if item 1000 has qty 6 and item 1001 has qty...

george sibbald (6/19/2012)

---

Its interesting this editorial was first written in 2007, pre the credit crunch.

I wonder if the promotion of risk would be so enthusiastic now we know just how...