Set the default value for this new colum to equal getdate() , this will ensure that any new data added will have a date and this wont affect the...

It should really only be the dba that is allowed to attach databases to a...

Okay, what is the question?

Pros = You will be able to put string characters into your field now

Cons = Any application, procedure or function that relies on this data type as an INT will...

they are the same value 1024 KB = MB, not 1000 KB

So 1801920 KB / 1024 = 1759.69 MB

It sounds like that SSIS is trying to put an empty string into the field which will not work.

You may have to use a function on this field that converts...

You will need to put commas (,) between your Params..

exec sp_DeleteDatafromAudit

@ProcMonth = 9 ,

@Company = 'FUL',

@Extract_type ='A'

If you really want to store the data in HH:MM then you could use a CLR UDT, this would allow you to put validations on the data...

The problem is the '-' your where clause

where changedate - 5

this does not make sense, it should have a '=' , ' '

eg

where changedate = 5

You are trying to convert a fraction (.40146) to datatype of INT, INT datatype does not allow this try converting to a float

SELECT CAST('.40146' AS float)

It would depend on how you are accessing the data in your production system.

A front-end applicaiton that expects this value to be an int will fail if you change...

you could do back-up / restore

or dettach /attach

or script out the database, and wrtie a SSIS package to transfer the data

why wont dettach / attach work?

try this..

SELECT Titles, Clasification, SUM([Number of Borrows])

FROM YourTable

GROUP BY Titles, Clasification

ORDER BY SUM([Number of Borrows]) DESC

do you mean MS access ? or is DBAccess a third party tool for querying sql server?

rbarryyoung (10/9/2008)

Also the CSI's they show on TV are some kind of "Super-Science Cop" that does not exist in any police department in the U.S. Real CSI's do not...