Is it a For Each loop from a list, or a For Each File loop? A For Each File loop will exit gracefully if there are no files. ...

Yep. If you need them done in a particular sequence, you pretty much need to start staging stuff into temp tables.

That would get databases that begin with M, I'm pretty...

Not sure what you mean. Do you mean all databases on one server where the name starts with N or later in the alphabet?

It would be easy enough to...

First, check for IsNumeric. On the rows that pass that test, check the range with a Between statement.

Run each test as a series of checks. Rows that pass...

One thing you can do is set those as variables, pull data from a table, and set the values of the variables from the values in a table.

ScottPletcher (1/15/2009)

If SQL Server evaluated left to right, in the above query, it wouldn't have to evaluate the second condition if the first was false (short circuit) because it would...

ScottPletcher (1/15/2009)

I thought SQL Server did...

All the products I've heard of that do that for you are quite expensive. You can find them by searching in Google/Live/whatever.

There are a couple of different ways. I like:

select Names.ID, Names.Name, Height, Weight

from

(select ID, Value as Name

from dbo.Table

where Key = 'Name') Names

inner join...

On the font and the config file, ask the hosting service about those. They're almost certainly in charge of those, unless you have a whole server/virtual machine of your...

I guess I'm not clear on what's happening with your form. You are setting the sort-by property of the form, and it's not sorting? Or something else?

I built...

You'll have to enable distributed transactions (and possibly RPC) on the remote server. Books Online has instructions on both of those things.

Just to check something on this, I put together this test:

create table #T1 (

ID int identity primary key,

Col1 int);

insert into #T1 (Col1)

select number

from dbo.numbers;

select *

from dbo.Numbers

cross apply

(select col1

from #T1

where col1...

Jack Corbett (1/15/2009)

GSquared (1/15/2009)

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