I suggest that you test Jeff Moden's 8K splitter.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Nice question - good to know my memory is not failing me

if memory serves me correcting xp_backup_database is a Litespeed product and technically the error is from SQL Server and not lightspeed at the root of the failure, but lightspeed itself...

If you run this

EXEC sp_helpdb 'tempdb'

What values are returned for maxsize and growth of templog ?

Before making the upgrade you might want to do some testing.

The Developer Edition of SQL 2005 is I think still available at a cost of about $50 (although not from...

I would suggest checking BOL (Books On Line) for the MERGE STATEMENT.

SQL Server 2008 Books Online (July 2009)

Inserting, Updating, and Deleting Data by Using MERGE ...

You can use a CTE (Common Table Expression) for example:

CREATE TABLE #T(Date_Stamp DATETIME,KW1 DECIMAL(5,1), KW2 DECIMAL(5,1))

INSERT INTO #T

SELECT '12/10/2010', 5.3, 3.1 UNION ALL

SELECT '12/10/2010', 5.3, 3.1 UNION ALL

SELECT '12/9/2010', 4,...

Going back to the basics - Nice question

Read the prior post by Jeff Moden. Using it

DECLARE @Amount Money

SET @Amount = -158.98

SELECT @Amount = @Amount - @Amount % .05

SELECT @Amount

Result:

(No column name)

-158.95

DECLARE @Amount Money

SET @Amount =...

Prior last post Posted Today @ 1:03 PM

Now 8:25 PM DECLARE @t TIME

SELECT @t = '7:22'

SELECT DATEDIFF(mi, 0, @t)

Which is 442 minutes

What did the site crash, this thread get...

You could use the MERGE statement. For an explanation and an example go to

http://technet.microsoft.com/en-us/library/bb510625.aspx

or

http://www.simple-talk.com/sql/learn-sql-server/the-merge-statement-in-sql-server-2008/

or

SQL SERVER – 2008 – Introduction to Merge Statement – One Statement for INSERT, UPDATE,...

For EXCEL read the following as EXCEL by default will only display a maximum of 255 characters in a text cell, the links below should be of assistance.

http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx#top

and

http://ewbi.blogs.com/develops/2005/02/autofit_an_exce.html

Be very careful when using IDENTITY_INSERT note what may occur if you are not very careful

CREATE TABLE #City(Id INT IDENTITY(1,1),[Name] VARCHAR(10))

INSERT INTO #City

SELECT 'ABC' UNION ALL

SELECT 'yz' UNION ALL

SELECT 'Etc'

SET...

My thanks to you. I have followed your posting here on SSC and...

Siva Ramasamy (1/30/2012)

I was just following this thread and understood the requirement and I also executed your solution and found that it satisfies the requirement...but not able to understand how...