Run this query and note the anomalies in the results:

SELECT DateEngaged,MonthsInService As 'YearsinService',DATEDIFF(Month,DateEngaged,GETDATE()) AS 'Months Dif'

,DATEDIFF(Month,DateEngaged,GETDATE())/12 AS 'Pseudo Years'

,MonthsInService*2 AS 'MyColumn3' FROM dbo.MyComputedColumn ORDER BY DateEngaged

DateEngagedYearsinServiceMonths DifPseudo YearsMyColumn3

1990-03-01 00:00:00.00020 ...

Northern Ohio - 20 miles west of Cleveland

Born in the borough of BROOKLYN in New York City.

Ernie Schlangen

Can someone verify for me that this is different in SQL 2008 vs SQL 2005? I get a different result using 2005 (I don't have access to a 2008...

Here is an excellent function developed by Lynn Pettis ...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[MyNewID]'))

EXEC dbo.sp_executesql @statement = N'create view...

I suggest you look at

http://www.sqlservercentral.com/Forums/Topic845680-338-1.aspx

For grins and giggles I modified the input data for the above forum to replace the commas in the string with tabs.

INSERT INTO @test-2

SELECT REPLACE('xyz, 54050,...

Whoops incorrect forum

If you believe that the T-SQL is dynamic and coming from an application, you might want to examine (Books On Line) the command DBCC INPUTBUFFER it will return up to...

This will return a list of all SPs in a SQL 2000 db

SELECT so.name, sob.name as 'Stored Procedure name' FROM sysobjects so

LEFT OUTER JOIN (sysobjects sob left outer join...

Before planning to use DTS to import data into a SQL 2008 DB I suggest you read the following articles, which basically say "it ain't simple"

Support for Data Transformation Services...

Take a look at this one

http://www.sqlservercentral.com/Forums/Topic844889-392-1.aspx

It is one of the worst I have seen on SSC in a long long time.

Lynn - I must compliment you on your restraint in...

Please note in SQL 2008:

...

Having had an almost identical problem in days gone by (SQL 2000) allow me to list what I had done, and some of the mishaps encountered.

1. Created a table...

Review your code against this excellent blog post

https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

and see if it matches what you have posted or gives you a different way of doing the same calculation.

1. Do NOT take the belittling comments...

1. You have posted to a SQL Server 2008 Forum.

2. You have posted the definition of a single table - good

3. The sample...