The reason I would want the results from the second procedure to go into a cursor from the first procedure, because the second procedure results are more than 1. It...

Would I be able to add my results from the second stored procedure into a cursor in the first procedure?

Thanks

Thanks for your advice.

I tried that SQL on a view and i recieved the error below:

"Cannot create index on view '[ViewName]' because the view is not schema bound"

My apologies for not being clear.

Can I extract the Months from the datepart on the pivot table and insert the month as a seperate field in a table?

January varchar(35)

February varchar(35)

March...

Sweet this looks good. This is the code that I used:

select * from

(select DATEPART(M,DATETRANS) AS ORDERMONTH, DELTA,staffkey

FROM BIL_ARTRANSLOG

WHERE DATETRANS BETWEEN '1/1/2009' AND '10/1/2009'AND TRANSTYPELU= 3) SRC

PIVOT (SUM(DELTA) FOR...

What if I just deleted these full index catalogs? I dont think i need them right now? Would I loose any data?

Did you migrate your db by using a backup or did you detach your db?

Thanks for your help.

Did you migrate your db by using a backup or did you detach your db?

Thanks for your help.

Yes we just upgraded from 2000 to 2005.

I did uninstall the SQL Native Client, but when I try to re-install the software I keep getting that error. It's really weird. I think the Software is trying to...

select count(*)

from table_name

Thats a simple way of getting an total amount of rows in your table. If you select count(columnname)

you might not get back accurate results since their might be...

That actually moved over all of the rows, but the field Staffkey was null in the tables that I inserted from the source table. Is there another parameter that I...

Does this Database Mail work in conjunction with Microsoft Outlook Exchange?

Thanks for the feedback. I am a rookie and still in the process of learning how to create store procedures.

This stored procedure is executed in the front end of the...