badkow

It would help those who want to help you to have some further information. Can you post the table definition, perhaps some sample data (does not have to be...

Clicked on Compare-28Jan

Go this reply

Clicked as I normally do on Prompt-17August

and got this

A further few hints. Never ever send a cover letter/resume to a Chief Technical Officer or IT Manger in which you ask for a job. In many companies...

Did a quick search (google) and Results 1 - 10 of about 2,830,000 for resume cover letter samples. Might find a few you can use by cutting and pasting...

Now if you desire to have your first batch of T-SQL function, that is create a temp table, in one connection and query it from another connection, create a GLOBAL...

Go to this posting by Lynn Pettis for almost every useful datetime T-SQL examples.

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

I am sure you will find what you need in the extensive listing.

Yes that was the purpose of...

I guess the answer to your question is "It depends"

Search TECHNET at:

http://technet.microsoft.com/en-us/default.aspx

using as the search words "SQL Server computed columns" and it will list for you a good deal...

Purchase my copy of SQL Server 2008 Developer Edition for 50 USD from Anazon.com .. just checked and price is now down to 40.49 Here is the link I...

My off the cuff answer is that universal "It all depends"

Read this page...

Your revised T_SQL to adjust the calculated value of MonthsInService appears to do the job properly .. Go ahead and test further.

Have you considered eliminating the computed...

If this is a one time event - have you considered using the upsizing wizard available in Access - very, very simple to use and no work writing a script

Nickson Asiimwe

Pardon me for injecting this comment, but I believe your problem to some extent currently lies outside of being a T-SQL problem. Rather it lies in the...

Kevin Gill

From

SQL Server 2008 Books Online (November 2009)

SET ANSI_DEFAULTS (Transact-SQL)

AT:

http://msdn.microsoft.com/en-us/library/ms188340.aspx

In my explanation all I did was add the words "SET IMPLICIT_TRANSACTIONS" to...