Ken,

 The datatypes for the table as well as the view are varchar(10).

Andrew and Ian I give both your suggestions a try and post the results when I'm done.

Thanks.

Sergiy,

As I posted to Ken before the first post wasn't an accurate portrayal of our SP. It was a generalization, however I"ve rewritten the SP to include only two IF statemenst both of which...

Thanks for the posts.

Sreejith,

I missed one of your questions. I didn't have an Index on the Status Column so I added one. There was no performance difference after I added...

Ken,

I was digging around a little and the view I'm calling actually has the status name in it. I actually have two parameters that I need to pass to the...

Sreejith,

Yes it runs a select statement with a "Where status = " filter.

Ken,

I'll have to tool around with your suggestion. I didn't 100% accurately represent my query in my previous post but it was...

Yeah I do. My reporting services install is located there.

Prasad,

Thanks for the reply. I searched a lot of places for this and couldn't come up with a solution that fit. Your's however did work. I don't get an error...

Thanks Farrell, will work on it with that suggestion! Have a good one.

Good point. I haven't used any third party backup software for SQL yet. I still just use MS SQL backup. So far this has worked great. I guess when...

Removing the first print command and moving the second like you said Noel worked. I'm gonna have to play around with cursors a little more. Thanks all for the responses.

Noel,

THanks for the response. I'm generating a list of Bill_IDs that are from the view. With this list I am going to autogenerate invoices and email these customers....

Thanks John,

This was not for the CA SQL Backup Agent but for the actual base product to store it's backup info. (i.e. What sessions have what data, which tapes...

Thanks John. I was trying to avoid having to create two tables if there was a way. But I guess not. I just thought maybe there was some sort of...

Thanks Peter. I am checking out that tool now. It looks like it stress tests the disk subsystem simulating a heavily loaded server. (Sound Correct?)

While this stress test may...

Thanks Peter. I did that with all the columns from view. Seems to work well. Thanks again.

select

sum(datalength(col1))+sum(datalength(col2)) as DataSize from v_View1