select ec.CAR, ec.MODEL, ec.DATE_ACQUIRED, (select DATEDIFF(YEAR,max(DATE_ACQUIRED),GETDATE()) from PROD.dbo.EMPCODES where CAR=ec.CAR AND TYPE='CE' and EMP_APP = 0 and MODEL=ec.MODEL) AS YEARSACQUIRED from PROD.dbo.EMPCODES ec where TYPE='CE' and EMP_APP = 0 and MODEL in ('TY','FD', 'AU', 'CV') and ec.OWNER = '')
|SQL Server: The performance goes down, but re-build statistics boost up performance||32||57|
|generate script create schema without authorization with smo||3||30|
|Error "String or binary data would be truncated" in an update on a datatable||7||28|
|SQL Server memory sizing - reallocation||16||38|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!