This is me, the "unfortunate DBA"

I just ran into this exact situation and it led to a liscense evaluation of ALL programs throuout our network.

they are set for automatic. I tried to reboot and they wont start I also tried to start them manually and that doesn't work. What do you mean by "What...

So, I can purchase SQL Server without a PROC

Thank you.

I could not figure out how to return the data length.

final:

Substring(Field,3,(Datalength(Field)-2))

thanks again.

this is for a text field. the 3rd argument needs to represent a multiple length string and up untill this point I thought % would do this.

example:

SUBSTRING(FIELD,3,%) 'should return the...

but char(8) will not work if I'm using a mm/dd/yyyy format.

Sorry, I didn't realize what the DATEDIFF was for. Thank you.

Perhaps I was not clear, let me post the code.

CREATE VIEW dbo.vwImport

AS

SELECT dbo.tblSHOrderItems.dteShipped, dbo.tblSHOrderItems.txtInvNum, dbo.tblSHOrderItems.txtSuffix, dbo.tblSHOrdHead.txtCustomerPO,

...

ok, how do i avoid the ERROR:

"divide by zero error encountered"

GREAT! it works

final code:

Avg(DATEDIFF(day,[dteprinted],[dtereceived])) AS AvgLead