Another way to check files is

EXEC master..xp_getfiledetails @File_with_path

It gives you more than just size, maybe these other values can help you as well:

Alternate Name, Size, Creation Date, Creation Time, Last Written...

Hi,

you say that column A does not always contain only numbers - that means you can not convert it to FLOAT (or any other number datatype). What other values can...

Yes, I have an idea. Don't do that. What is N, how much is that? 10 million? 100 million? Even that can still stay in one table.

I don't like the idea...

I see we posted about the same time... I'm sorry, but the data you supplied is absolutely illegible. Please, could you post a CREATE TABLE statement for your table (you...

"Also, is it just the 'user' that the script tries to return??  If so it's the whole row that I want, not just the user!!"

What do you mean by "whole row"?...

Typical bad design that we meet so often... making one row per user with lots of columns holding the same information. If this is something you can influence, you should normalize the table...

As to the question about checking, you could write a cursor that would check all databases on the server for cursors :-).

Problem is, that some cursors are "hidden" to such check,...

Hmmm.. let's think about it. Which numbers are on stock? Those, where the last entry for them is not ISSUE (i.e. it is either Receive or Return). Problem is, how...

Yes, I think that's how I understood it. Did you try the code I posted yesterday? It should do precisely what you want.

Column "pk" in mytable is the column that identifies...

That's a bit confusing... let's say you have received 250 items, No 1-250. You have issued them in 5 blocks of 50. Items No. 3, 27 and 41 were returned (all together,...

I have some problems to understand what you want to do... I'll try to describe how I got it.

You have a log table of updates, that contains updateDate. There are...

Hi,

problem is that SQL Server does not allow dates prior to year 1900 in smalldatetime, so you have to set the datetype of column dtTime to DATETIME - nor SMALLDATETIME.

You can...

You're welcome ... and I see you already got response to that other post from other people - there is nothing I can...

You have to make the condition part of LEFT JOIN clause. Then the LEFT JOIN (i.e. NULLs are included) applies also to this condition, whereas if you put the condition...

Yes, this should work. Just remember to enclose the email in single quotes, too.