Viewing 15 posts - 706 through 720 (of 3,221 total)
I suggest that you test Jeff Moden's 8K splitter.
February 6, 2012 at 6:27 am
Nice question - good to know my memory is not failing me
February 4, 2012 at 8:48 pm
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...
February 4, 2012 at 12:41 pm
If you run this
EXEC sp_helpdb 'tempdb'
What values are returned for maxsize and growth of templog ?
February 3, 2012 at 8:15 am
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...
February 3, 2012 at 7:09 am
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 ...
February 2, 2012 at 11:32 am
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,...
February 2, 2012 at 9:52 am
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 =...
February 1, 2012 at 6:53 pm
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...
February 1, 2012 at 6:31 pm
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,...
February 1, 2012 at 5:54 pm
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
February 1, 2012 at 3:14 pm
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...
February 1, 2012 at 8:41 am
Revenant (1/31/2012)
A simple yer or no, and I got it wrong... Thanks, Bitbucket -- a good lesson!
My thanks to you. I have followed your posting here on SSC and...
January 31, 2012 at 10:20 am
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...
January 30, 2012 at 3:44 pm
Viewing 15 posts - 706 through 720 (of 3,221 total)