And that's even cooler yet since it gives me milliseconds as well. I like it! Thank you.

Thank you both Steve and Matt.

Steve;

While you were replying I was doing research and came across the date math solution that you mentioned at

http://www.sqlteam.com/article/working-with-time-spans-and-durations-in-sql-server

It wound up looking like this;

PRINT...

So - if I have BULK INSERT privilages in the TempDb I'll be able to make this work?

Hmm.

Sounds like the upshot is that something that should be simple - isn't.

Here's the nut of my problem.

I have an application which can execute SQL scripts directly (I have the...

Well! That would be an important piece of information! I've been doing a lot of research on this problem and haven't come across that.

Do you have any docmenteted...

I'm using Windows authentication.

Yes I have.

I have also tried it creating a permanent table (I have dbo authority) and it works as desired. The problem has something to do with it being...

Hi Loner. Thanks for the reply.

I've tried your ideas. Still no joy.

I think it has something to do with privileges but I'm not sure what it is yet.

I...

Anyone... anyone...?

That would explain it.

We're in the midst of transitioning from 2000 to 2005. I'm kind of schizophrenic myself these days 😉

Hi Jason;

Thanks for the post. I had some trouble with the syntax. I don't have sys.tables or sys.indexes. I think sys.indexes should have been dbo.sysindexes

Anyway - this...

More...

I'm hoping to use something like;

SELECT [TABLENAME] from WHERE FileGroup = [FILEGROUPNAME]

Am I dreaming in technicolor?

I believe that the source of my problem is that I (and the users who will use this SQL script) do not - and would never be permitted to -...

I'm effectively using a simple sql script with variables and hoping to pass in the name of the CSV in one of the variables.

Something like this

IF OBJECT_ID(N'TempDb..#SCOPE',N'U') IS NOT NULL...

I think that the difference is attributable to the where clause where we are comparing the length value of the N row to the length of the bounding Y rows.

I'm...