I apologize for not being clear. I am looking for a script that gives me the schema, name of the table, and rowcount for all tables in a database. I've...

Thank you!

I've also tried running it as a job as 'sa' with the same response. it continues to execute but does nothing.

It works through a command prompt from my desktop. i'm sure it will not have a problem on the server.

I was running it from the client. Running task manager shows many many processes. Is there something in specific I should be looking for?

Thank you. I have not had a chance to work on this last week, My code is on the computer at work and I will be picking it up tomorrow....

Okie doke Master Seth...

Working on it today and Monday if I dont finish...

Thank you and in case I don't get it by the end of day... have a...

I've tried all kinds of keys to replace that and it has not been working soo.. phew! 🙂 So I would comment out the EntityID columns, pk's, and joins correct?...

You rock Seth! Thank you!

1. I'm sorry. I think I messed that part up too. I need to group the sum by WorkingDayOfMonth as well. I'll send you a new...

I have attached everything I think you need. Let me know if I am missing anything!

Thanks again!

Hi there,

It seems as though the case statement is not reading the total collections from the join at the top. I'm getting this error.

Msg 207, Level 16, State 1, Line...

Okie doke... i'll get back to you tomorrow... 🙂

No problem at all, here it is and thank you so much for your help.

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

...

I am completely sorry. The link completely went over my head. I will provide you with the specific format. Again, I'm sorry.

Thank you Seth...

Here is the result set I am looking for:

GrossCollection should be GrossCollection/sum(gross collection)

Field3Field2GrossCollectionMonthlyTotal CumulativeTotal

20 0 ...