Results for SQL 2008 Developer edition run on a desk top with slightly more memory and slightly higher speed Running Windows XP - code run was that after you edited...

Results for SQL 2005 Developer edition run on a desk top with slightly more memory and slightly higher speed Running Windows XP

Now do you need one run on SQL...

Results for SQL 2008 Developer edition run on a desk top with slightly more memory and slightly higher speed Running Windows XP

Between this and my prior post should...

Jeff ran test on the oldest, least amount of memory, slowest desktop, age - older than dirt. Running Windows XP

Result for SQL 2005 Express in attached word doc.

Will...

Are you familiar with the SP (In master DB) sp_FOREACHDB? To read how to use this go to:

http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm

abcim

When posting a performance problem, to assist you in obtaining the best answer, please click on the second link in my signature block, and attempt to follow its instruction...

I would suggest reading the following

http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/

AND the comments on the article describing some different approaches.

I had to test this code in 2005, but it should perform identically in 2008

Your data with a few entries added

CREATE TABLE #T(Addrid INT, Addr VARCHAR(15), datex DATETIME)

INSERT INTO...

From a SQL 2000 Server.

The following assumes you are using EXCEL 2003 or earlier. If you are using EXCEL 2007 or later then the command must be altered to...

Go back to the post in question.

Click on the "Edit" button

It will open in a window similar to...

GilaMonster (9/17/2010)

jcrawf02 (9/17/2010)

Haven't been able to eat crab since we went to Alaska...

Is this what you are looking for?

SELECT DAY =

CASE STR(DAY(GETDATE()))

WHEN...

I do not understand why you wish to do this to values in a table and not in the T-SQL statement which selects the data from the table, but you...

Please, please the next time you post include the table definition, sample input data in a format easy to use. To learn how to do this quickly and easily...

Wayne this is a follow on for the posting in SQL 2000 Forum:

Table definition:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GPM_Safety_Inspection]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[GPM_Safety_Inspection]

GO

/******...