You cannot just change the type in syscolumns.  Even though you may only store integer data in a varchar column, the data is not stored the same way in the...

You can use PATINDEX to find the location of the pipe and then use that in the substring function. 

You are doing the query for multiple encounters, so won't you have multiple records in the #Sps table?  Do you just want the first record? Min/Max?

You will need to set the...

If I read your code correctly, you only insert into the #Log table if the #Sps table is empty.  If so, you don't have any values in the FirstEncDt or...

Look at the code for sp_spaceused to get the exact.  But here is a quick, and fairly accurate way.

SELECT so.Name, SUM(dpages)*8/1024. pagesMB, SUM(Reserved)*8/1024. reservedMB

FROM sysobjects so, sysindexes si

where so.type='u'

and so.id=si.id

group...

Are the dev and prod databases similar in size and data?  Did your prod query have an order by clause that you didn't include on the dev query?

Brian

I would also suggest using the column list to guarantee the data is inserted properly.  Otherwise you can have problems if the columns are not in the same order, or...

If you use Windows Authentication for the database connections, you will use your login when you run it manually.  However, when you schedule it to run, it will use the...

So you want to set the RegionID value to the maximum empid for a given city?

UPDATE e

SET RegionID=t.EmpID

FROM table_Employees e, (SELECT CityID, MAX(EmpID) EmpID FROM table_Employees GROUP BY CityID) t

WHERE...

ROWCOUNT limits the number of rows a query will use.  ROWCOUNT n - n is the number of rows you want to return.  0 is unlimited. 

SET ROWCOUNT 1

SELECT *...

What is the DDL for table_employees and your procedure?  I would tend to think that EmpID would be unique for each record in table_Employees.  If so, why would you need...

You only escape out the character if you are using LIKE.

='%'

Brian

Try

Like '%[%]%'

Brian

I stand corrected.  Thanks Greg and Steve.  I should have my coffee before I start typing.