Try this - run profiler, and then run your code. Double-check what is happening.

There's definitely something odd going on, since the VALUES syntax only outputs one row....

Devo - have you actually tried the methods in Jeff's article? There's no reason you couldn't use the function run against DISTINCT values in SSRS.

You'll probably want to explore a CLR function to do this. It's not going to be any kind of speed demon, but it can access things like EVAL. ...

That's essentially what fixed it for something similar we were doing. Setting up the package on a dev bax and trying to move that over to a server didn't...

Control Panel, Administrative tools, data sources (ODBC).

Just for testing purposes - turn off your Windows Firewall, and try that again. Make suer that SQL Browser is running as well.

Also - can you connect through the...

My first title sounded a little more like...

Gail - in 2005, if you knew it was going to recompile - would you FORCE the recompile on a given statement?

It is theoretically supposed to speed things...

One thing that might be throwing you off is that @@rowcount returns the rowcount of the LATEST OPERATION, in this case the IF statement., so your return isn't telling you...

The syntax peter is getting at also works against table columns. you just have to use CROSS APPLY.

Should be something like this (Fair warning - coding with a substantial...

I think all you need is that interop DLL file appropriately loaded into the Server's GAC. I used to have a procedure for getting that done, but for the...

Use SUBSTRING in conjunction with a CHARINDEX function. CHARINDEX will allow you to find the starting point of your return string

Something like:

declare @fun varchar(75)

set @fun='ZION ...

Keep in mind that heaps (tables with no clustered index) cannot be defragmented. So they can be very useful for fast load and things that are fairly heavy on...

Agreed as long as we're only talking about non-clustered indexes.

If we were talking clustered indexes, it becomes a "it depends". Assuming the data files were roughly in...

Hmm - here's a battery of things I ran repeatedly. Captured the stats via a trace to a table.

here's what I come up with:

(Average CPU, MaxCPU, MinCPU, repetitions)

select count(*)...